Closed Alice52 closed 3 years ago
show variables like '%max_connections%';
set GLOBAL max_connections=2256;
show global variables like 'wait_timeout';
set global wait_timeout=10;
show processlist
kill pid
show variables like '%max_connections%';: 查看mysql的最大连接数set GLOBAL max_connections=2256;: 重启失效show global variables like 'wait_timeout';: 连接释放时间set global wait_timeout=10;: 每个连接的等待时间, 重启失效show processlist+kill pid: 查看已有连接 + 删除