MySQL 9.0 Release Notes
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.
Press CTRL+C to copymysql> 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 ('%', '%', '%') ...