Bug #39790 There is no way to determine the source of many configuration options values
| Submitted: | 1 Oct 2008 20:33 | Modified: | 3 Oct 2008 4:35 |
|---|---|---|---|
| Reporter: | Shawn Green | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S4 (Feature request) |
| Version: | any | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[1 Oct 2008 20:33]
Shawn Green
[3 Oct 2008 4:35]
Valeriy Kravchuk
Thank you for a reasonable feature request.
[19 Apr 2013 13:19]
MySQL Verification Team
To preserve reverse compatibility, the normal SHOW VARIABLES reports should be maintained. The extra column of source-related information should only appear if we include some extra keyword like EXTENDED. SHOW [GLOBAL|SESSION] VARIABLES[ EXTENDED][ LIKE ... ]
[19 Apr 2013 14:09]
Craig Sylvester
This is an excellent suggestion. I always thought MySQL should at least document which configuration file(s) were used to start the server. But your suggestion is much better.
[23 Apr 2014 20:52]
Stephen Werner
It would be great to know when a parameter was changed. numerous database servers have this as a standard, will at least it is logged to the server log or in Sybase case the configuration file is backed up first sybase.001 from sybase.cfg. Would be a difficult one logging the host though unless the system is locked (no access to the db_server from the localhost). Then again I have heard hostnames can be alias via Java. Anyway, if the parameter had a time_of_change, current_setting, old_setting and have this logged to the server.log, updated in the config (and roll the config file) as will as table entry. Possibly have an audit trigger (optional, as some overnight processing may use different parameter settings) to log an audit table configuration changes etc.. My 5 cent rant. (possibly more to come..)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.