Bug #88382 Persisted configuration in mysqld-auto.cnf is not reflected in mysqld output

• Submitted: 7 Nov 2017 9:13
• Modified: 7 Nov 2017 13:08
• Reporter: Oli Sennhauser
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 8.0.3
• OS: Any
• CPU Architecture: Any

[7 Nov 2017 9:13] Oli Sennhauser

Description:
Persisted configuration in mysqld-auto.cnf is not reflected in mysqld --help --verbose output

How to repeat:
SET PERSIST slow_query_log = ON;
--> Writes mysqld-auto.cnf

mysqld --help --verbose
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf /home/mysql/database/mysql-8.0/data/my.cnf ~/.my.cnf 

Does not show, that mysqld-auto is read during start. Which SHOULD IMHO.

Suggested fix:
add $datadir/mysqld-auto.cnf to mysqld --help --verbose output!

[7 Nov 2017 13:08] MySQL Verification Team

Hello Oli,

Thank you for the report and feedback!

Thanks,
Umesh