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

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

Hello David Ducos,

Thank you for the report and feedback!

Thanks,
Umesh

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.