how to check global and session wait_timeout and interactive_timeout variables

how to check global and session wait_timeout and interactive_timeout

Here is a quick select to validate global and session timeout variables

view al at once

SELECT 
     @@global.wait_timeout, 
     @@global.interactive_timeout, 
     @@session.wait_timeout, 
     @@session.interactive_timeout;

View global

SELECT 
     @@global.wait_timeout, 
     @@global.interactive_timeout;

View session

SELECT
     @@session.wait_timeout, 
     @@session.interactive_timeout;


to set the variables

Global

set global interactive_timeout=28800;   # default
set global wait_timeout=28800;  # default

Session

set session wait_timeout=28800;
set session interactive_timeout=28800;   # default