MySQL 9.3 Reference Manual Including MySQL NDB Cluster 9.3
Resets the Performance Schema configuration to its default settings.
in_verbose BOOLEAN
: Whether to
display information about each setup stage during
procedure execution. This includes the SQL statements
executed.
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 ('%', '%', '%')
...