简介
performance_schema_max_digest_length
用于控制performance_schema在做sql统计分析时,可以保留的sql语句的最大长度,官方文档上此值范围在0-1048576之间,而当设置此值为1048576时,performance_schema无法正常的工作。
影响版本:mysql-5.7.19
复现
Description:
Add
"performance_schema_max_digest_length=1048576"
to my.cnf and then restart the server.
mysql> show global variables like '%performance%'
-> ;
Empty set (0.00 sec)
mysql>
mysql>
mysql>
mysql> select * from performance_schema.setup_actors;
Empty set (0.01 sec)
mysql> select * from performance_schema.setup_consumers;
Empty set (0.00 sec)
How to repeat:
Add performance_schema_max_digest_length=1048576 to my.cnf.
and restart mysqld.