Bug #49762 Get online meta-information about configuration parameters
Submitted: 17 Dec 2009 9:09 Modified: 17 Dec 2009 13:49
Reporter: Sivert Sørumgård Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.1+ OS:Any
Assigned to: CPU Architecture:Any

[17 Dec 2009 9:09] Sivert Sørumgård 
Description:
In various situations, getting information about configuration parameters online would be very convenient. Supported parameters could be listed with name, type. default value, value limits, etc. 

How to repeat:
FR

Suggested fix:
Could extend existing utility mysql_config. For MySQL Cluster, the utility ndb_config has been extended to provide the required information, e.g.:

<section name="NDBD" primarykeys="NodeId">
  <param name="MaxNoOfSubscriptions" comment="Max no of subscriptions (default 0 == MaxNoOfTables)" type="unsigned" default="0" min="0" max="4294967039"/>
  <param name="MaxNoOfSubscribers" comment="Max no of subscribers (default 0 == 2 * MaxNoOfTables)" type="unsigned" default="0" min="0" max="4294967039"/>
  ...etc...
[17 Dec 2009 13:49] Valeriy Kravchuk 
It would be really nice to get this information included into I_S.GLOBAL_VARIABLES table (http://dev.mysql.com/doc/refman/5.1/en/variables-table.html), for example.
[11 Jan 2010 7:54] Jon Stephens 
Re Valeriy's comment -- this was also the first thing I thought of when I saw this proposal.

For docs, it would also be nice to get the output in XML format.