sys Schema Stored Procedures Example 28.4.4.14 The ps_setup_save() Procedure Parameters Example 28.4.4.15 The ps_setup_show_disabled() Procedure Parameters 5190 • in_show_instruments BOOLEAN : Whether to display disabled instruments. This might be a long list. • in_show_threads BOOLEAN : Whether to display disabled threads. • in_timeout INT : How many seconds to wait to obtain the  sys.ps_setup_save  lock. A negative timeout value means infinite timeout. 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 (’%’, ’%’, ’%’) ... mysql>  CALL sys.ps_setup_save(10); ...  make Performance Schema configuration changes  ... mysql>  CALL sys.ps_setup_reload_saved(); Displays all currently disabled Performance Schema configuration. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin  system variable. That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . It is intended you call  ps_setup_reload_saved()  later within the  same  session as  ps_setup_save() because the configuration is saved in  TEMPORARY  tables.  ps_setup_save()  drops the temporary tables and releases the lock. If you end your session without invoking  ps_setup_save() , the tables and lock disappear automatically. To prevent other simultaneous calls to save the configuration,  ps_setup_save()  acquires an advisory lock named  sys.ps_setup_save  by calling the  GET_LOCK()  function.  ps_setup_save()  takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). If the timeout expires without obtaining the lock,  ps_setup_save()  fails. Saves the current Performance Schema configuration. This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved()  procedure.