Bug #111109 mysqld --print-defaults doesn't display set persist variables

• Submitted: 22 May 2023 17:24
• Modified: 23 May 2023 12:22
• Reporter: Mike Griffin
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Any
• CPU Architecture: Any

[22 May 2023 17:24] Mike Griffin

Description:
Before starting mysqld it can be useful to see which variables will be used by various included configuration files. Currently, it does not appear that mysqld-auto.cnf in displayed.

How to repeat:
Configure some options in my.cnf and then change some variables at runtime with SET PERSIST. Verify that the json values are stored in $datadir/mysqld-auto.cnf and then attempt to display these with mysqld --print-defaults

[23 May 2023 12:22] MySQL Verification Team

Hi Mr. Griffin,

Thank you very much for your bug report.

However, you have not provided a full test case.

Next, persisted variables will NOT be displayed on the command line. 

That is why we have Performance_Schema, so that you can do that. This is much better solution, since start-up code of our server would require many changes in order to display this online. 

You already have this functionality. You can display those variable with mysql CLI, so there is no need to invent a totally new feature.

Not a bug.