Bug #89673 Default values showed by "--verbose --help" doesn't match with the documentation
Submitted: 14 Feb 2018 17:57 Modified: 15 Feb 2018 6:52
Reporter: David Ducos Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.7, 5.7.9, 5.7.21 OS:Linux
Assigned to: CPU Architecture:Any

[14 Feb 2018 17:57] David Ducos
Description:
According to MySQL documentation from 5.7.9 the default for innodb_file_format_max is Barracuda but when we execute "mysqld --no-defaults --verbose --help" it shows Antelope. 

There are also another variables like innodb-buffer-pool-instances

How to repeat:
[root@centos_mysql ~]# mysqld --version
mysqld  Ver 5.7.21 for Linux on x86_64 (MySQL Community Server (GPL))

[root@centos_mysql ~]# mysqld --no-defaults --verbose --help | grep innodb-file-format-max
  --innodb-file-format-max[=name]
innodb-file-format-max                                       Antelope

[root@centos_mysql ~]# mysqld --no-defaults --verbose --help | grep innodb-buffer-pool-instances
  --innodb-buffer-pool-instances=#
innodb-buffer-pool-instances                                 0

[root@centos_mysql ~]# mysqld --no-defaults --verbose --help | grep innodb-io-capacity-max
  --innodb-io-capacity-max=#
innodb-io-capacity-max                                       18446744073709551615
[15 Feb 2018 6:52] MySQL Verification Team
Hello David Ducos,

Thank you for the report and feedback!

Thanks,
Umesh