The Ultimate Guide to High Availability with MariaDB

Performance Schema events_statements_summary_by_user_by_event_name Table

You are viewing an old version of this article. View the current version here.

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

ColumnDescription
USERUser. Used together with EVENT_NAME for grouping events.
EVENT_NAMEEvent name. Used together with USER 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_user_by_event_name\G
...
*************************** 521. row ***************************
                       USER: NULL
                 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
*************************** 522. row ***************************
                       USER: NULL
                 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.