maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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