MySQL :: MySQL 8.4 Reference Manual :: 30.4.4.24 The ps_truncate_all

version 8.4

8.0 current
5.7

8.0 Japanese

MySQL 8.4 Reference Manual / ... / The ps_truncate_all_tables() Procedure

30.4.4.24 Performance Schema ps_truncate_all_tables() Procedure

将所有性能Schema汇总表截断，重置所有聚合计量仪器为快照。生成一个结果集，指示截断了多少个表。

in_verbose BOOLEAN: 是否在执行前显示每个TRUNCATE TABLE语句。

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

PREV HOME UP NEXT