mysql内存过高解决办法
mysql内存过高解决办法:vi /etc/my.cnf
performance_schema_max_table_instances=600(默认为12500)
table_definition_cache=400 (默认为1400)
table_open_cache=256 (默认为2000)
:wq
service mysql restart
查看命令:
show variables like '%performance_schema_max_table_instances%';
show variables like '%table_definition_cache%';
show variables like '%table_open_cache%';
页:
[1]