Bug #108376 The explain of --column-statistics option is different
Submitted: 5 Sep 2022 2:50 Modified: 5 Sep 2022 5:37
Reporter: Jinghua Lin Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[5 Sep 2022 2:50] Jinghua Lin
The explain of --column-statistics option is different between the documentation and mysqldump's help.

the documentation:


Add ANALYZE TABLE statements to the output to generate histogram statistics for dumped tables when the dump file is reloaded. This option is disabled by default because histogram generation for large tables can take a long time.

mysqldump's help:

--column-statistics Add an ANALYZE TABLE statement to regenerate any existing
                      column statistics.
                      (Defaults to on; use --skip-column-statistics to disable.)

One said this option is disabled by default, anothor one said deefaults to on.

So there must be a mistake in one place and it should be fixed.

How to repeat:
1. open https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_column-statistics

2. execute `mysqldump --help`, search for "--column-statistics".

3. compare their contents.
[5 Sep 2022 5:37] MySQL Verification Team
Hello Jinghua Lin,

Thank you for the report and feedback.