Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / MySQL sys Schema  / sys Schema Object Reference  / sys Schema Stored Procedures  /  The ps_truncate_all_tables() Procedure

26.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 eachTRUNCATE TABLE statement before executing it.

Example
mysql> CALL sys.ps_truncate_all_tables(FALSE);+---------------------+| summary             |+---------------------+| Truncated 44 tables |+---------------------+