Bug #110129 Wrong explanation in innodb_stats_auto_recalc

• Submitted: 20 Feb 2023 8:03
• Modified: 20 Mar 2024 17:20
• Reporter: Tsubasa Tanaka (OCA)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Any
• 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

[20 Mar 2024 17:20] Philip Olson

Posted by developer:
 
Thank you for reporting this, it's now fixed in the documentation source.