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%';
转载于:https://blog.51cto.com/yangzhiming/2043708