maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #04188
Re: Aborted connection (CLOSE_CONNECTION)
Woops, sorry, I missed the GLOBAL word :)
Federico
--------------------------------------------
Mer 30/11/16, Ian Gilfillan <ian@xxxxxxxxxxx> ha scritto:
Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
A: maria-discuss@xxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp