Performance Schema events_statements_summary_by_thread_by_event_name Table

MariaDB starting with 10.0

The events_statements_summary_by_thread_by_event_name table, along with many other new Performance Schema tables, was added in MariaDB 10.0.

The Performance Schema events_statements_summary_by_thread_by_event_name table contains statement events summarized by thread and event name. It contains the following columns:

ColumnDescription
THREAD_IDThread associated with the event. Together with EVENT_NAME uniquely identifies the row.
EVENT_NAMEEvent name. Used together with THREAD_ID for grouping events.
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.
SUM_LOCK_TIMESum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORSSum of the ERRORS column in the events_statements_current table.
SUM_WARNINGSSum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTEDSum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENTSum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINEDSum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLESSum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLESSum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOINSum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOINSum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGESum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECKSum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCANSum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSESSum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGESum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWSSum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCANSum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USEDSum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USEDSum of the NO_GOOD_INDEX_USED column in the events_statements_current table.

The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.

Example

SELECT * FROM events_statements_summary_by_thread_by_event_name\G
...
*************************** 3653. row ***************************
                  THREAD_ID: 64
                 EVENT_NAME: statement/com/Error
                 COUNT_STAR: 0
             SUM_TIMER_WAIT: 0
             MIN_TIMER_WAIT: 0
             AVG_TIMER_WAIT: 0
             MAX_TIMER_WAIT: 0
              SUM_LOCK_TIME: 0
                 SUM_ERRORS: 0
               SUM_WARNINGS: 0
          SUM_ROWS_AFFECTED: 0
              SUM_ROWS_SENT: 0
          SUM_ROWS_EXAMINED: 0
SUM_CREATED_TMP_DISK_TABLES: 0
     SUM_CREATED_TMP_TABLES: 0
       SUM_SELECT_FULL_JOIN: 0
 SUM_SELECT_FULL_RANGE_JOIN: 0
           SUM_SELECT_RANGE: 0
     SUM_SELECT_RANGE_CHECK: 0
            SUM_SELECT_SCAN: 0
      SUM_SORT_MERGE_PASSES: 0
             SUM_SORT_RANGE: 0
              SUM_SORT_ROWS: 0
              SUM_SORT_SCAN: 0
          SUM_NO_INDEX_USED: 0
     SUM_NO_GOOD_INDEX_USED: 0
*************************** 3654. row ***************************
                  THREAD_ID: 64
                 EVENT_NAME: statement/com/
                 COUNT_STAR: 0
             SUM_TIMER_WAIT: 0
             MIN_TIMER_WAIT: 0
             AVG_TIMER_WAIT: 0
             MAX_TIMER_WAIT: 0
              SUM_LOCK_TIME: 0
                 SUM_ERRORS: 0
               SUM_WARNINGS: 0
          SUM_ROWS_AFFECTED: 0
              SUM_ROWS_SENT: 0
          SUM_ROWS_EXAMINED: 0
SUM_CREATED_TMP_DISK_TABLES: 0
     SUM_CREATED_TMP_TABLES: 0
       SUM_SELECT_FULL_JOIN: 0
 SUM_SELECT_FULL_RANGE_JOIN: 0
           SUM_SELECT_RANGE: 0
     SUM_SELECT_RANGE_CHECK: 0
            SUM_SELECT_SCAN: 0
      SUM_SORT_MERGE_PASSES: 0
             SUM_SORT_RANGE: 0
              SUM_SORT_ROWS: 0
              SUM_SORT_SCAN: 0
          SUM_NO_INDEX_USED: 0
     SUM_NO_GOOD_INDEX_USED: 0

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.