Bug #112839 performance_schema_max_memory_classes has new default value in 8.2.0

• Submitted: 26 Oct 2023 7:28
• Modified: 26 Oct 2023 14:49
• Reporter: Shawn Yan (OCA)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.2.0
• OS: Any
• CPU Architecture: Any

[26 Oct 2023 7:28] Shawn Yan

Description:
The default value of performance_schema_max_memory_classes was changed to 470 in 8.2.0

How to repeat:
See 
https://dev.mysql.com/doc/refman/8.2/en/performance-schema-system-variables.html#sysvar_pe...
https://github.com/mysql/mysql-server/blob/mysql-8.2.0/storage/perfschema/pfs_server.h#L85

and:

mysql> SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME IN ('version', 'performance_schema_max_memory_classes');
+---------------------------------------+----------------+
| VARIABLE_NAME                         | VARIABLE_VALUE |
+---------------------------------------+----------------+
| performance_schema_max_memory_classes | 470            |
| version                               | 8.2.0          |
+---------------------------------------+----------------+
2 rows in set (0.01 sec)

Suggested fix:
Suggested fix:
Update the default value to be 470 in 8.2.0

[26 Oct 2023 7:43] MySQL Verification Team

Hello Shawn Yan,

Thank you for the report and feedback.

regards,
Umesh

[26 Oct 2023 14:49] Edward Gilmore

Posted by developer:
 
The documentation has been updated and will be online shortly.
Thank you for the bug report.