MySQL 9.5 Reference Manual Including MySQL NDB Cluster 9.5

30.4.4.24 The ps_truncate_all_tables() Procedure

Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Produces a result set indicating how many tables were truncated.

Parameters

  • in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it.

Example
mysql> CALL sys.ps_truncate_all_tables(FALSE);
+---------------------+
| summary             |
+---------------------+
| Truncated 49 tables |
+---------------------+
MySQL Documentation Library