MySQL 8.4 Release Notes
30.4.4.13 The ps_setup_reset_to_default() Procedure
重置性能架构到默认设置。
-
in_verbose BOOLEAN: 在执行过程中是否显示每个设置阶段的信息。这包括执行的SQL语句。
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 ('%', '%', '%')
...