Possible Memory Leak with Heavy Insert InnoDB Config
I built mysql from the source distribution available here: http://
************** mysqlreport *******
MySQL 5.0.67-log uptime 0 4:24:52 Wed Dec 3 19:11:42 2008
__ Key _______
Buffer used 17.00k of 8.00M %Used: 0.21
Current 1.46M %Usage: 18.25
Write hit 100.00%
Read hit 99.69%
__ Questions _______
Total 13.67M 860.0/s
DMS 10.34M 650.7/s %Total: 75.66
Com_ 2.94M 184.9/s 21.50
QC Hits 397.21k 25.0/s 2.91
-Unknown 12.14k 0.8/s 0.09
COM_QUIT 2.22k 0.1/s 0.02
Slow 1 s 17.42k 1.1/s 0.13 %DMS: 0.17 Log: ON
DMS 10.34M 650.7/s 75.66
INSERT 8.22M 517.4/s 60.16 79.52
UPDATE 1.53M 96.3/s 11.20 14.81
SELECT 578.32k 36.4/s 4.23 5.59
DELETE 8.77k 0.6/s 0.06 0.08
REPLACE 0 0/s 0.00 0.00
Com_ 2.94M 184.9/s 21.50
show_warnin 2.91M 183.3/s 21.32
admin_comma 12.07k 0.8/s 0.09
set_option 8.80k 0.6/s 0.06
__ SELECT and Sort _______
Scan 8.75k 0.6/s %SELECT: 1.51
Range 0 0/s 0.00
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 171.67k 10.8/s
Sort range 2.40k 0.2/s
Sort mrg pass 3 0.0/s
__ Query Cache _______
Memory usage 22.32k of 100.00M %Used: 0.02
Block Fragmnt 16.67%
Hits 397.21k 25.0/s
Inserts 551.40k 34.7/s
Insrt:Prune 551.40k:1 34.7/s
Hit:Insert 0.72:1
__ Table Locks _______
Waited 0 0/s %Total: 0.00
Immediate 10.35M 651.2/s
__ Tables _______
Open 64 of 64 %Cache: 100.00
Opened 2.99k 0.2/s
__ Connections _______
Max used 75 of 250 %Max: 30.00
Total 2.23k 0.1/s
__ Created Temp _______
Disk table 1.13k 0.1/s
Table 8.56k 0.5/s Size: 32.0M
File 1.33k 0.1/s
__ Threads _______
Running 25 of 41
Cached 4 of 8 %Hit: 72.13
Created 621 0.0/s
Slow 0 0/s
__ Aborted _______
Clients 6 0.0/s
Connects 0 0/s
__ Bytes _______
Sent 960.99M 60.5k/s
Received 6.88G 433.0k/s
__ InnoDB Buffer Pool _______
Usage 4.00G of 4.00G %Used: 100.00
Read hit 99.95%
Pages
Free 0 %Total: 0.00
Data 256.62k 97.89 %Drty: 1.05
Misc 5527 2.11
Latched 15 0.01
Reads 506.70M 31.9k/s
From file 264.03k 16.6/s 0.05
Ahead Rnd 1386 0.1/s
Ahead Sql 161 0.0/s
Writes 82.48M 5.2k/s
Flushes 4.52M 284.5/s
Wait Free 19 0.0/s
__ InnoDB Lock _______
Waits 54 0.0/s
Current 0
Time acquiring
Total 19878 ms
Average 368 ms
Max 3817 ms
__ InnoDB Data, Pages, Rows _______
Data
Reads 367.87k 23.1/s
Writes 3.50M 220.1/s
fsync 385.69k 24.3/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 516.30k 32.5/s
Read 382.93k 24.1/s
Written 4.52M 284.5/s
Rows
Deleted 64.40k 4.1/s
Inserted 8.21M 516.8/s
Read 213.64M 13.4k/s
Updated 650.46k 40.9/s
*******
Variable_name Value
auto_increment_
auto_increment_
automatic_
back_log 50
basedir /usr/local/
binlog_cache_size 32768
bulk_insert_
character_
character_
character_
character_
character_
character_
character_
character_sets_dir /usr/local/
collation_
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
completion_type 0
concurrent_insert 1
connect_timeout 10
datadir /vol/data/
date_format %Y-%m-%d
datetime_format %Y-%m-%d %H:%i:%s
default_week_format 0
delay_key_write ON
delayed_
delayed_
delayed_queue_size 1000
div_precision_
keep_files_
engine_
expire_logs_days 3
flush OFF
flush_time 0
ft_boolean_syntax + -><()~*:""&|
ft_max_word_len 84
ft_min_word_len 4
ft_query_
ft_stopword_file (built-in)
group_concat_
have_archive NO
have_bdb NO
have_blackhole_
have_compress YES
have_crypt YES
have_csv NO
have_dynamic_
have_example_engine NO
have_federated_
have_geometry YES
have_innodb YES
have_isam NO
have_merge_engine YES
have_ndbcluster NO
have_openssl NO
have_ssl NO
have_query_cache YES
have_raid NO
have_rtree_keys YES
have_symlink YES
hostname ip-10-251-22-47
init_connect
init_file
init_slave
innodb_
innodb_
innodb_
innodb_
innodb_checksums ON
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_doublewrite ON
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_flush_method O_DIRECT
innodb_
innodb_
innodb_
innodb_log_arch_dir
innodb_log_archive OFF
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_open_files 300
innodb_
innodb_support_xa ON
innodb_
innodb_table_locks ON
innodb_
innodb_
innodb_io_capacity 100
innodb_read_ahead 3
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8384512
key_cache_
key_cache_
key_cache_
language /usr/local/
large_files_support ON
large_page_size 0
large_pages OFF
lc_time_names en_US
license GPL
local_infile ON
locked_in_memory OFF
log OFF
log_bin ON
log_bin_
log_error /vol/logs/error.log
log_queries_
log_slave_updates OFF
log_slow_queries ON
log_slow_filter
log_slow_rate_limit 1
log_slow_verbosity microtime
log_warnings 1
long_query_time 1.000000
low_priority_
lower_case_
lower_case_
max_allowed_packet 1048576
max_binlog_
max_binlog_size 1073741824
max_connect_errors 10
max_connections 250
max_delayed_threads 20
max_error_count 64
max_heap_table_size 16777216
max_insert_
max_join_size 184467440737095
max_length_
max_prepared_
max_relay_log_size 0
max_seeks_for_key 184467440737095
max_sort_length 1024
max_sp_
max_tmp_tables 32
max_user_
max_write_
min_examined_
multi_range_count 256
myisam_
myisam_
myisam_
myisam_
myisam_
myisam_stats_method nulls_unequal
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
old_passwords OFF
open_files_limit 1250
optimizer_
optimizer_
pid_file /vol/data/
plugin_dir
port 3306
preload_buffer_size 32768
profiling OFF
profiling_
protocol_version 10
query_alloc_
query_cache_limit 1048576
query_cache_
query_cache_size 104857600
query_cache_type ON
query_cache_
query_prealloc_size 8192
range_alloc_
read_buffer_size 131072
read_only OFF
read_rnd_
relay_log
relay_log_index
relay_log_info_file relay-log.info
relay_log_purge ON
relay_log_
rpl_recovery_rank 0
secure_auth OFF
secure_file_priv
server_id 1
skip_external_
skip_networking OFF
skip_show_database OFF
slave_compresse
slave_load_tmpdir /tmp/
slave_net_timeout 3600
slave_skip_errors OFF
slave_transacti
slow_launch_time 2
socket /tmp/mysql.sock
sort_buffer_size 2097144
sql_big_selects ON
sql_mode
sql_notes ON
sql_warnings OFF
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_key
storage_engine MyISAM
sync_binlog 0
sync_frm ON
system_time_zone UTC
table_cache 64
table_lock_
table_type MyISAM
thread_cache_size 8
thread_stack 262144
time_format %H:%i:%s
time_zone SYSTEM
timed_mutexes OFF
tmp_table_size 33554432
tmpdir /tmp/
transaction_
transaction_
tx_isolation REPEATABLE-READ
updatable_
version 5.0.67-log
version_comment Source distribution
version_
version_compile_os unknown-linux-gnu
wait_timeout 28800
***************** free *******
total used free shared buffers cached
Mem: 7872040 7857036 15004 0 70176 573416
-/+ buffers/cache: 7213444 658596
Swap: 10485752 3082304 7403448
Question information
- Language:
- English Edit question
- Status:
- Answered
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask sagehen03 for more information if necessary.