Bug #69147 Variable defaults in information_schema
Submitted: 5 May 2013 10:07 Modified: 12 Oct 2014 13:17
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[5 May 2013 10:07] Daniël van Eeden 
Description:
It would be nice to be able to report all non-default MySQL settings.

Especially with information_schema. Then we could make a query which reports all non-default settings.

How to repeat:
See Description

Suggested fix:
Add information_schema table.

It would be nice to see it on a global level.

Optionally it could also be show on a session level:

| variable         | session_value | global_value | unit  |
-----------------------------------------------------------
| sort_buffer_size | 2048          | 1024         | bytes |
... 

It could even be extended to show the values from all sessions, which can be used to show if long_query_time was changed for all sessions or just new ones. If it's writable then it could be used to change values for running sessions without any application adjustments or reconnects.
[5 May 2013 10:09] Daniël van Eeden 
The output of PHP's phpinfo() shows local values and master values. This could be used as an example.
[5 Jul 2013 5:43] Erlend Dahl 
Thank you for the feature request.
[28 Jul 2013 14:43] Daniël van Eeden 
Somewhat related to Bug #68451