MySql内存增长过快导致崩溃的问题
我服务器配置是：Linux 5.5 CPU：16核，内存：64GB MySql 5.5.18
问题是：
MySQL稳定运行10天，内存在15G左右，CPU也很平稳，在5%左右。10天以后（也不一定，也就是达到一定时间以后），在其后的几天内，内存增长加速，一天内达到10%，而且CPU也会增长。这个问题一直没有查出来，网上内似的信息也很少。这还是跟内存的使用有关，但也找不到具体的原因。各位高手帮忙看看，是什么个问题。
现在增长中的状态值：（大部分是0的我都去掉了，免得看起来很多。）
Aborted_clients28936121
Aborted_connects2332
Binlog_cache_use4481333
Binlog_stmt_cache_use1937129
Bytes_received2564
Bytes_sent182321
Com_select12
Com_set_option8
CompressionOFF
Connections43985567
Created_tmp_files481
Created_tmp_tables24
Handler_read_key1431
Handler_read_rnd171
Handler_read_rnd_next2935
Handler_update1260
Handler_write2911
Innodb_buffer_pool_pages_data569825
Innodb_buffer_pool_pages_dirty344
Innodb_buffer_pool_pages_flushed29073286
Innodb_buffer_pool_pages_free1485891
Innodb_buffer_pool_pages_misc41435
Innodb_buffer_pool_pages_total2097151
Innodb_buffer_pool_read_ahead73057
Innodb_buffer_pool_read_requests134992208571
Innodb_buffer_pool_reads424003
Innodb_buffer_pool_write_requests62473513
Innodb_data_fsyncs10666195
Innodb_data_pending_fsyncs1
Innodb_data_read8436584448
Innodb_data_reads444508
Innodb_data_writes21480882
Innodb_data_written486137894912
Innodb_dblwr_pages_written14536643
Innodb_dblwr_writes220262
Innodb_have_atomic_builtinsON
Innodb_log_write_requests14694711
Innodb_log_writes9129785
Innodb_os_log_fsyncs9215320
Innodb_os_log_pending_fsyncs1
Innodb_os_log_written9757420032
Innodb_page_size16384
Innodb_pages_created58204
Innodb_pages_read514630
Innodb_pages_written14536643
Innodb_row_lock_time639073
Innodb_row_lock_time_avg176
Innodb_row_lock_time_max31962
Innodb_row_lock_waits3611
Innodb_rows_deleted77365
Innodb_rows_inserted2151604
Innodb_rows_read109709175982
Innodb_rows_updated3938873
Key_blocks_not_flushed2
Key_blocks_unused26768
Key_blocks_used984
Key_read_requests703118813
Key_reads49
Key_write_requests30062010
Key_writes516196
Last_query_cost12.499000
Max_used_connections501
Open_files332
Open_table_definitions113
Open_tables887
Opened_files59764277
Prepared_stmt_count94
Qcache_free_blocks4
Qcache_free_memory67030952
Qcache_hits28062
Qcache_inserts13686
Qcache_not_cached1079396116
Qcache_queries_in_cache24
Qcache_total_blocks64
Queries7995684443
Questions48
Select_scan12
Sort_rows171
Sort_scan12
Table_locks_immediate5233183853
Table_locks_waited1314
Threads_cached27
Threads_connected173
Threads_created1965
Threads_running3
Uptime828692
Uptime_since_flush_status828692
my.cnf的配置如下：
[client]
back_log = 256
max_connections = 500
max_connect_errors = 10000
table_open_cache = 4096
max_allowed_packet = 16M
binlog_cache_size = 1M
read_buffer_size = 12M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
join_buffer_size = 8M
thread_cache_size = 64
thread_concurrency = 32
query_cache_size = 64M
query_cache_limit = 2M
ft_min_word_len = 4
default-storage-engine = MYISAM
thread_stack = 192K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 64M
log-bin=mysql-bin
binlog_format=mixed
slow_query_log
long_query_time = 2
server-id = 1
key_buffer_size = 32M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 5G
myisam_repair_threads = 1
myisam_recover
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 32G
innodb_file_per_table = 1
innodb_data_file_path = ibdata1:10M:autoextend
innodb_write_io_threads = 8
innodb_read_io_threads = 16
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 8M
innodb_log_file_size = 256M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
skip-name-resolve
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
open-files-limit = 8192
内存：
$ free -m
total used free shared buffers cached
Mem: 64449 41183 23266 0 164 4810
-/+ buffers/cache: 36208 28241
Swap: 4094 0 4094
[解决办法]
innodb_buffer_pool_size = 32G
这个值设置太大小点，10G
[解决办法]
看下慢查询 定位到具体是哪些sql导致的
