mysql连接数max_connections设置

• my.ini

[mysqld]
max_connections 10000 #总数

#max_user_connections #设置每个用户的连接数

UPDATE mysql.user SET max_user_connections = 1600 WHERE user='lren' AND host='%'; 
FLUSH PRIVILEGES;

#查看修改结果
show variables like 'max_connections';
show status like 'max_used_connections';

#查看当前的连接数和进程数
show status like 'Threads%';