Bug #25252 global config changes should write to my.cnf file and create backup copy
Submitted: 22 Dec 2006 20:08 Modified: 24 Apr 2018 11:43
Reporter: john danilson Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Installing Severity:S4 (Feature request)
Version:5.0.26 OS:Linux (GNU/Linux)
Assigned to: CPU Architecture:Any
Tags: my.cnf @@global
Triage: D5 (Feature request)

[22 Dec 2006 20:08] john danilson
Changes made to global variables using the command set @@global <variable>=<value> are not retained across server restarts.  

When this command is entered, the variable value(s) should be updated in the my.cnf file and a copy made of the existing my.cnf file so that rollback would be possible.  Presently, it is up the sysadmin to manually update the my.cnf file if a global change is made.  This makes the process of retaining variable settings prone to error. And, if a change is made, there is no easy way to find the old value and restore it. 

How to repeat:
Modify any global variable.  Note that this changes in the server but not in the my.cnf file. 

Suggested fix:
see Description.
[26 Dec 2006 11:35] Valeriy Kravchuk
Thank you for a reasonable feature request.
[7 Dec 2016 16:20] Yngve Svendsen
Posted by developer:
This is a feature request for the Server Dev team.
[24 Apr 2018 11:43] Yngve Svendsen
Posted by developer:
This has largely been taken care of with the set persist functionality in 8.0 onwards.