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 : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
