ps_setup_reset_to_default()过程
将性能架构配置重置为其默认设置。
参量
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 ('%', '%', '%') ...