| 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 5:37]
MySQL Verification Team
Hello Jinghua Lin, Thank you for the report and feedback. regards, Umesh

Description: The explain of --column-statistics option is different between the documentation and mysqldump's help. the documentation: --column-statistics 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.