The objects_summary_global_by_type
table, along with many other new Performance Schema tables, was added in MariaDB 10.0.
It aggregates object wait events, and contains the following columns:
Column | Description |
---|---|
OBJECT_TYPE |
Groups records together with OBJECT_SCHEMA and OBJECT_NAME . |
OBJECT_SCHEMA |
Groups records together with OBJECT_TYPE and OBJECT_NAME . |
OBJECT_NAME |
Groups records together with OBJECT_SCHEMA and OBJECT_TYPE . |
COUNT_STAR |
Number of summarized events |
SUM_TIMER_WAIT |
Total wait time of the summarized events that are timed. |
MIN_TIMER_WAIT |
Minimum wait time of the summarized events that are timed. |
AVG_TIMER_WAIT |
Average wait time of the summarized events that are timed. |
MAX_TIMER_WAIT |
Maximum wait time of the summarized events that are timed. |
You can TRUNCATE the table, which will reset all counters to zero.
SELECT * FROM objects_summary_global_by_type\G ... *************************** 101. row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: test OBJECT_NAME: v COUNT_STAR: 0 SUM_TIMER_WAIT: 0 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 0 MAX_TIMER_WAIT: 0 *************************** 102. row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: test OBJECT_NAME: xx2 COUNT_STAR: 2 SUM_TIMER_WAIT: 1621920 MIN_TIMER_WAIT: 481344 AVG_TIMER_WAIT: 810960 MAX_TIMER_WAIT: 1140576
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-objects_summary_global_by_type-table/