Performance Schema objects_summary_global_by_type Table
You are viewing an old version of this article. View
the current version here.
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.
Example
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
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
