MYSQL根据状态优化

SHOW VARIABLES LIKE '%slow%';

SHOW GLOBAL STATUS LIKE '%slow%';

SHOW PROCESSLIST;

SHOW VARIABLES LIKE 'max_connections';

SHOW GLOBAL STATUS LIKE 'max_used_connections';

SHOW GLOBAL STATUS LIKE 'thread%';

SHOW VARIABLES LIKE 'thread_cache_size';

SHOW VARIABLES LIKE 'query_cache%';

参考：https://cloud.tencent.com/developer/article/1114302