Woops, sorry, I missed the GLOBAL word :) Federico -------------------------------------------- Mer 30/11/16, Ian Gilfillan ha scritto: Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) A: maria-discuss@lists.launchpad.net Data: Mercoledì 30 novembre 2016, 15:13 On 30/11/2016 15:13, Federico Razzoli wrote:

This always shows the global value: SHOW VARIABLES LIKE ...

This always shows the current session value:

SHOW SESSION VARIABLES LIKE ... This is not correct. SHOW VARIABLES shows the session value: SET GLOBAL wait_timeout=601; SET SESSION wait_timeout=599; SHOW SESSION VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout  | 599   | +---------------+-------+ SHOW GLOBAL VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout  | 601   | +---------------+-------+ SHOW VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout  | 599   | +---------------+-------+ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to     : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help   : https://help.launchpad.net/ListHelp