Bug #102466 Wrong default for performance_schema_digests_size on Statement Summary Tables
Submitted: 3 Feb 2021 9:32 Modified: 5 Feb 2021 7:22
Reporter: Georgi Sotirov Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[3 Feb 2021 9:32] Georgi Sotirov
The page Statement Summary Tables (see https://dev.mysql.com/doc/refman/5.7/en/statement-summary-tables.html) wrongly states that the default size for digest summary table is 200 (I mean precisely the sentence "The default size is 200."). The size of the table is controlled by performance_schema_digests_size system variable (see https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html#sysvar_pe...) whose default value is -1 (i.e. autosizing).

How to repeat:
Open the URLs from description and compare defaults.

Suggested fix:
The Statement Summary Tables should state the correct default size.
[3 Feb 2021 9:39] MySQL Verification Team
Hello Georgi Sotirov,

Thank you for the report!

[4 Feb 2021 21:41] Paul DuBois
Posted by developer:
Changed the text to read:

By default, the table is autosized, but if this size is too small,
set the performance_schema_digests_size system variable to a larger
value at server startup.
[5 Feb 2021 7:22] Georgi Sotirov
Thanks! :-)