Bug #72048 SET GLOBAL not changing variable values
Submitted: 15 Mar 2014 17:41 Modified: 16 Mar 2014 11:16
Reporter: Aidana Kishlyarova Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.6 OS:MacOS
Assigned to: CPU Architecture:Any
Tags: SET GLOBAL

[15 Mar 2014 17:41] Aidana Kishlyarova 
Description:
I was trying to change dynamic system variables by setting them to different values. However SET GLOBAL some variable = some value, does not change the variable value I am setting, even after I restart the server.

How to repeat:
Read the previous bug reports
[16 Mar 2014 11:16] MySQL Verification Team 
One has to edit the my.cnf to make change persist after a restart.
Then, make sure you check the global variable after setting it.

SET GLOBAL .....;
SHOW GLOBAL VARIABLES LIKE '...';
[31 Mar 2014 12:01] Hartmut Holzgraefe 
Part of the story may also be that for session variables SET GLOBAL only changes the default for new sessions, but not the current value of the already existing connections/sessions ... ?