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) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.2.0 OS:Any
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.