请教下mysql内存一直在不断增长的原因，谢谢

zhengsenlin888

我采用的是percona5.5.21 mysql数据库。全部都是innodb表，我给mysql分配的内存是16G.
随着时间的推移，为什么会一直慢慢的增长到占用30G的内存。请问下是什么原因，谢谢。

a.a

看看你的proceslist，或是启用你log_error  general_log log-slow-queries
再查看你的mysqld.log ，从日志入手进行分析。

devilkin0312

先计算下你的配置上限内存，

zhengsenlin888

好的，谢谢。我去查看看。

小版主杀手

看看配置

zhengsenlin888

回复 5# 小版主杀手

机器总内存32G 16核

[client]
port                = 3306
socket                = /var/spool/mysql.sock

[mysqld]
server-id        = 1
log-bin=mysql-bin
expire_logs_days = 7
port                = 3306
socket                = /var/spool/mysql.sock
skip-external-locking
key_buffer_size = 1M
max_allowed_packet = 16M
table_open_cache = 8192
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 1M
thread_cache_size = 2048
query_cache_size= 1M
thread_concurrency = 16
skip-name-resolve
default-storage-engine = InnoDB
# binary logging format - mixed recommended
binlog_format=mixed
query_cache_type = 2
max_connections = 4000
max_connect_errors = 1000
open_files_limit = 65535


# Uncomment the following if you are using InnoDB tables
#percona-5.5.21
innodb_data_file_path = ibdata1:512M:autoextend
innodb_buffer_pool_size = 16G
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 5G
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 0
innodb_lock_wait_timeout = 50
innodb_file_per_table
innodb_thread_concurrency = 0
memlock

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout