Bug #87438 Store default values in i_s.global_variables for quick overview
Submitted: 16 Aug 2017 12:33 Modified: 16 Aug 2017 12:36
Reporter: Thomas Benkert Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[16 Aug 2017 12:33] Thomas Benkert 
Description:
It would be nice to store the default values in the information_schema.global_variables table. 

Use case would be, you have a new workplace and want to have a quick glance how a server is configured.

Just looking at the configuration files and start-up parameters won't give the full picture, as someone might have used a SET GLOBAL whatever=x; statement.

With a column like VARIABLE_DEFAULT one could use the following query to quickly have a full report on what has been changed without having to compare _every_ value with the manual.

SELECT * 
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
WHERE VARIABLE_VALUE <> VARIABLE_DEFAULT;

How to repeat:
-- there's nothing to repeat, this is a feature request --
[16 Aug 2017 12:36] Thomas Benkert 
added a reason to the synopsis