Bug #64474 No clean way to get compiled-in settings from mysqld for a storage engine
Submitted: 27 Feb 2012 20:06 Modified: 28 Feb 2012 5:04
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.5.16 (but general) OS:Any
Assigned to:
Tags: windmill
Triage: Needs Triage: D5 (Feature request)

[27 Feb 2012 20:06] Simon Mudd
Description:
mysqld --no-defaults --verbose --help does not provide engine settings.

Oracle support have shown that mysqld --no-defaults --user=mysql --verbose --help does provide InnoDB default settings which is good, but hardly intuitive.

It would be good to know how one should generically be able to retrieve these settings as they are not available from the SQL command line and currently calling mysqld this way, while it works, is not really ideal.

How to repeat:
See above.

Suggested fix:
Provide a cleaner mechanism for doing this, so that default and running settings can be easily queried, and also ensure the documentation is clear on how to do this.
[28 Feb 2012 5:04] Valeriy Kravchuk
Thank you for the feature request. I think extra column (variable_default_value?) in I_S.GLOBAL_VARIABLES will be enough.
[28 Feb 2012 12:22] Shane Bester
I already filed a FR for this last year:
Bug 12719455 - ALLOW HARDCODED DEFAULT VALUES OF VARIABLES TO BE QUERIED VIA I_S