网上常用方法,但不适用。
innodb_buffer_pool_size=576M ->256M InnoDB引擎缓冲区占了大头,首要就是拿它开刀
query_cache_size=100M ->16M 查询缓存
tmp_table_size=102M ->64M 临时表大小
key_buffer_size=256m ->32M
正确方法:
- performance_schema_max_table_instances=600
- table_definition_cache=400
- table_open_cache=256
即在my.ini文件的mysqld下添加该块内容
- # The MySQL server
- [wampmysqld]
- port = 3306
- socket = /tmp/mysql.sock
- key_buffer = 16M
- max_allowed_packet = 1M
- sort_buffer_size = 512K
- net_buffer_length = 8M
- read_buffer_size = 256K
- read_rnd_buffer_size = 512K
- myisam_sort_buffer_size = 8M
- basedir=c:/wamp/bin/mysql/mysql5.6.12
- log-error=c:/wamp/logs/mysql.log
- #datadir=c:/wamp/bin/mysql/mysql5.6.12/data
- datadir=e:/mysql/data
- performance_schema_max_table_instances=600
- table_definition_cache=400
- table_open_cache=256
重启后,mysqld内存减少很多
原文地址:http://blog.csdn.net/webnoties/article/details/20034967