Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
Woops, sorry, I missed the GLOBAL word :)
Federico
-------------------------------------------- Mer 30/11/16, Ian Gilfillan ian@mariadb.org 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
participants (1)
-
Federico Razzoli