sys Schema Stored Procedures +-------------------------------------------------------------------+ | Convert to PNG | +-------------------------------------------------------------------+ | dot -Tpng -o /tmp/stack_25.png /tmp/stack-2014-02-16-21:18:41.dot | +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ | dot -Tpdf -o /tmp/stack_25.pdf /tmp/stack-2014-02-16-21:18:41.dot | +-------------------------------------------------------------------+ +------------------+ | summary | +------------------+ | Enabled 1 thread | +------------------+ 1 row in set (60.07 sec) 1 row in set (60.07 sec) 1 row in set (60.32 sec) +---------------------+ | summary | +---------------------+ | Truncated 49 tables | +---------------------+ mysql>  CALL sys.ps_truncate_all_tables(FALSE); 28.4.4.24 The ps_truncate_all_tables() Procedure Parameters Example 28.4.4.25 The statement_performance_analyzer() Procedure Parameters Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Produces a result set indicating how many tables were truncated. • in_verbose BOOLEAN : Whether to display each  TRUNCATE TABLE  statement before executing it. • in_action ENUM(’snapshot’, ’overall’, ’delta’, ’create_tmp’, ’create_table’, ’save’, ’cleanup’) : The action to take. These values are permitted: • snapshot : Store a snapshot. The default is to make a snapshot of the current content of the Performance Schema  events_statements_summary_by_digest  table. By setting  in_table , this can be overwritten to copy the content of the specified table. The snapshot is stored in the  sys schema  tmp_digests  temporary table. • overall : Generate an analysis based on the content of the table specified by  in_table . For the overall analysis,  in_table  can be  NOW()  to use a fresh snapshot. This overwrites an existing snapshot. Use  NULL  for  in_table  to use the existing snapshot. If  in_table  is 5197 Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. 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” .