Bug #102466 Wrong default for performance_schema_digests_size on Statement Summary Tables
Submitted: 3 Feb 9:32 Modified: 5 Feb 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 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 9:39] MySQL Verification Team
Hello Georgi Sotirov,

Thank you for the report!

[4 Feb 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 7:22] Georgi Sotirov
Thanks! :-)