> 文章列表 > mysql 8.0 too many connections问题 相关操作

mysql 8.0 too many connections问题 相关操作

mysql 8.0 too many connections问题 相关操作

– set persist interactive_timeout=600;
– set session interactive_timeout=600;

– set persist wait_timeout=600;
– set session wait_timeout=600;

– set persist max_connections=800;

– show global variables like “wait_timeout”;
– show session variables like “wait_timeout”;

– show global variables like “interactive_timeout”;
– show session variables like “interactive_timeout”;

– show global variables like “%_connections%”;
– show session variables like “max_connections”;

– show processlist

– select version() from dual;