Performance Schema objects_summary_global_by_type Table

MariaDB starting with 10.0

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:

ColumnDescription
OBJECT_TYPEGroups records together with OBJECT_SCHEMA and OBJECT_NAME.
OBJECT_SCHEMAGroups records together with OBJECT_TYPE and OBJECT_NAME.
OBJECT_NAMEGroups records together with OBJECT_SCHEMA and OBJECT_TYPE.
COUNT_STARNumber of summarized events
SUM_TIMER_WAITTotal wait time of the summarized events that are timed.
MIN_TIMER_WAITMinimum wait time of the summarized events that are timed.
AVG_TIMER_WAITAverage wait time of the summarized events that are timed.
MAX_TIMER_WAITMaximum 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...