Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.2Mb
PDF (A4) - 38.2Mb
PDF (RPM) - 37.1Mb
HTML Download (TGZ) - 10.1Mb
HTML Download (Zip) - 10.2Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 206.2Kb
Man Pages (Zip) - 314.5Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  The ps_truncate_all_tables() Procedure 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.

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

mysql> CALL ps_truncate_all_tables(FALSE);
| summary             |
| Truncated 44 tables |

User Comments
Sign Up Login You must be logged in to post a comment.