mysql 优化：

转载：

查询连接数：
show variables like '%max_connection%';
查询当前连接数：
show status like 'Threads%';
看thread_connected
设置临时：
set global max_connections=1000;

https://blog.51cto.com/yanconggod/2058551

https://www.cnblogs.com/rocky404/p/6807744.html
show status like 'Threads%';
set global thread_cache_size=64;

https://blog.csdn.net/u010667710/article/details/102842721
https://www.cnblogs.com/yufeng218/p/10029862.html

 

show full processlist; 查看当前进程 mysql 出现: too many connection  1、定位慢sql 加索引  2、提高数据库最大连接数