MySQL 8.0 参考手册 / 第 28 章 MySQL 系统模式 / 28.4 sys 模式对象参考 / 28.4.4 sys 模式存储过程 /
28.4.4.13 ps_setup_reset_to_default() 过程
将性能架构配置重置为其默认设置。
mysql> CALL sys.ps_setup_reset_to_default(TRUE)\G
*************************** 1. row ***************************
status: Resetting: setup_actors
DELETE
FROM performance_schema.setup_actors
WHERE NOT (HOST = '%' AND USER = '%' AND ROLE = '%')
*************************** 1. row ***************************
status: Resetting: setup_actors
INSERT IGNORE INTO performance_schema.setup_actors
VALUES ('%', '%', '%')
...