Bug #110129 Wrong explanation in innodb_stats_auto_recalc
Submitted: 20 Feb 2023 8:03 Modified: 20 Feb 2023 8:15
Reporter: Tsubasa Tanaka (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0.32 OS:Any
Assigned to: CPU Architecture:Any

[20 Feb 2023 8:03] Tsubasa Tanaka
Description:
This is documentation issue.

The doc says in https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_stats_auto_re...

> Automatic statistics recalculation may also be configured by specifying STATS_PERSISTENT=1 in a CREATE TABLE or ALTER TABLE statement.

But actually, recalculation is configured by specifying *STATS_AUTO_RECALC=1* .
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html

How to repeat:
See https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_stats_auto_re...

Suggested fix:
Fix as STATS_AUTO_RECALC=1.
[20 Feb 2023 8:15] MySQL Verification Team
Hello tanaka-San,

Thank you for the report and feedback.

regards,
Umesh