Name: MySQL Global Vars wait_timeout & max_connections
Rating: 3.3 (9844 reviews)
Author: adamkdean

MySQL Global Vars wait_timeout & max_connections

Adam K Dean - Nov 22 '11 -

- Dev Community

Just some more code for me to bookmark. Problem was the MySQL connections were not being closed, the timeout was set at 8 hours and the connection limit was 400.

SHOW VARIABLES LIKE "%wait%"
SET @@GLOBAL.wait_timeout=300

SHOW VARIABLES LIKE "%max%"
SET @@GLOBAL.max_connections=1000