MySQL wait_timeout Variable – GLOBAL vs SESSION
Your session status are set once you start a session, and by default, take the current GLOBAL value. If you disconnected after you did SET @@GLOBAL.wait_timeout=300, then subsequently reconnected, you’d see SHOW SESSION VARIABLES LIKE “%wait%”; Result: 300 Similarly, at any time, if you did mysql> SET session wait_timeout=300; You’d get mysql> SHOW SESSION VARIABLES … Read more