MySQL Global Vars wait_timeout & max_connections

Published on 22 November 2011 at 22:19 by Adam

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

This post was first published on 22 November 2011 at 22:19. It was filed under archive with tags sql.