Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Explore the tables in the performance_schema database, which expose granular metrics on server events, locks, threads, and I/O for detailed performance analysis.
The Performance Schema accounts table stores statistics on current and total connections for each client account connecting to the server.
Each account that connects to the server is stored as a row in the accounts table, along with current and total connections.
The table size is determined at startup by the value of the performance_schema_accounts_size system variable. If this is set to 0, account statistics will be disabled.
The USER and HOST values shown here are the username and host used for user connections, not the patterns used to check permissions.
This page is licensed: CC BY-SA / Gnu FDL
The cond_instances table lists all active condition objects (internal code mechanisms for thread signaling) currently on the server.
The cond_instances table lists all conditions while the server is executing. A condition, or instrumented condition object, is an internal code mechanism used for signalling that a specific event has occurred so that any threads waiting for this condition can continue.
The maximum number of conditions stored in the performance schema is determined by the system variable.
This table summarizes stage events aggregated by user name and event name, helping to identify users with resource-intensive stages.
The events_transactions_summary_by_user_by_event_name table contains information on transaction events aggregated by user and event name.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
The file_instances table lists all file objects currently open by the server, including filenames and the number of open handles.
The file_instances table lists instances of instruments seen by the Performance Schema when executing file I/O instrumentation, and the associated files. Only files that have been opened, and that have not been deleted, will be listed in the table.
The system variable specifies the maximum number of instrumented file objects.
The session_status table displays status variable values for the current session, providing data equivalent to the SHOW SESSION STATUS statement.
The session_status table contains a list of status variables for the current session. The table only stores status variable statistics for threads which are instrumented, and does not collect statistics for Com_xxx variables.
The table contains the following columns:
NAME
Client user name for the connection, or NULL if an internal thread.
OBJECT_INSTANCE_BEGIN
Address in memory of the instrumented condition.
This page is licensed: CC BY-SA / Gnu FDL
FILE_NAME
File name.
EVENT_NAME
Instrument name associated with the file.
OPEN_COUNT
Open handles on the file. A value of greater than zero means that the file is currently open.
This page is licensed: CC BY-SA / Gnu FDL
SELECT * FROM performance_schema.file_instances WHERE OPEN_COUNT>0;
+----------------------------------------------------+--------------------------------------+------------+
| FILE_NAME | EVENT_NAME | OPEN_COUNT |
+----------------------------------------------------+--------------------------------------+------------+
| /var/log/mysql/mariadb-bin.index | wait/io/file/sql/binlog_index | 1 |
| /var/lib/mysql/ibdata1 | wait/io/file/innodb/innodb_data_file | 2 |
| /var/lib/mysql/ib_logfile0 | wait/io/file/innodb/innodb_log_file | 2 |
| /var/lib/mysql/ib_logfile1 | wait/io/file/innodb/innodb_log_file | 2 |
| /var/lib/mysql/mysql/gtid_slave_pos.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /var/lib/mysql/mysql/innodb_index_stats.ibd | wait/io/file/innodb/innodb_data_file | 3 |
| /var/lib/mysql/mysql/innodb_table_stats.ibd | wait/io/file/innodb/innodb_data_file | 3 |
...VARIABLE_NAME
The session status variable name.
VARIABLE_VALUE
The session status variable value.
It is not possible to empty this table with a TRUNCATE TABLE statement.
This page is licensed: CC BY-SA / Gnu FDL
USER
The connection's client user name for the connection, or NULL if an internal thread.
HOST
The connection client's host name, or NULL if an internal thread.
CURRENT_CONNECTIONS
Current connections for the account.
TOTAL_CONNECTIONS
Total connections for the account.
+----------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------------+------+-----+---------+-------+
| USER | char(32) | YES | | NULL | |
| EVENT_NAME | varchar(128) | NO | | NULL | |
| COUNT_STAR | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| COUNT_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| COUNT_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
+----------------------+---------------------+------+-----+---------+-------+The events_stages_current table shows the current stage event for each thread, including timer information and nesting details.
The events_stages_current table contains current stage events, with each row being a record of a thread and its most recent stage event.
The table contains the following columns:
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID
It is possible to empty this table with a TRUNCATE TABLE statement.
The related tables, and derive their values from the current events.
This page is licensed: CC BY-SA / Gnu FDL
The events_stages_history_long table stores the most recent 10,000 completed stage events globally, providing a deeper history than per-thread tables.
The events_stages_history_long table by default contains the ten thousand most recent completed stage events. This number can be adjusted by setting the performance_schema_events_stages_history_long_size system variable when the server starts up.
The table structure is identical to the events_stage_current table structure, and contains the following columns:
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
It is possible to empty this table with a TRUNCATE TABLE statement.
and are related tables.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes stage events aggregated by the client host and the event name, allowing performance analysis per host.
The table lists stage events, summarized by thread and event name.
It contains the following columns:
EVENT_NAME
Event name.
COUNT_STAR
Number of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAIT
Total wait time of the timed summarized events.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes stage events aggregated by the client host and the event name, allowing performance analysis per host.
The table lists stage events, summarized by host and event name.
It contains the following columns:
HOST
Host. Used together with EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with HOST for grouping events.
COUNT_STAR
Number of summarized events, which includes all timed and untimed events.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes stage events aggregated by user name and event name, helping to identify users with resource-intensive stages.
The table lists stage events, summarized by user and event name.
It contains the following columns:
USER
User. Used together with EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with USER for grouping events.
COUNT_STAR
Number of summarized events, which includes all timed and untimed events.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes stage events aggregated by the client account and the specific event name, showing counts and wait times.
The table lists stage events, summarized by account and event name.
It contains the following columns:
USER
User. Used together with HOST and EVENT_NAME for grouping events.
HOST
Host. Used together with USER and EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with USER and HOST for grouping events.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes stage events aggregated by thread and event name, providing granular statistics on thread execution stages.
The table lists stage events, summarized by thread and event name.
It contains the following columns:
THREAD_ID
Thread associated with the event. Together with EVENT_NAME uniquely identifies the row.
EVENT_NAME
Event name. Used together with THREAD_ID for grouping events.
COUNT_STAR
Number of summarized events, which includes all timed and untimed events.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes wait events aggregated by user name and event name, helping to identify users triggering significant wait events.
The Performance Schema events_waits_summary_by_user_by_event_name table contains wait events summarized by user and event name. It contains the following columns:
USER
User. Used together with EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with USER for grouping events.
COUNT_STAR
Number of summarized events
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes wait events aggregated by thread and event name, useful for pinpointing threads experiencing high wait times.
The Performance Schema events_waits_summary_by_thread_by_event_name table contains wait events summarized by thread and event name. It contains the following columns:
THREAD_ID
Thread associated with the event. Together with EVENT_NAME uniquely identifies the row.
EVENT_NAME
Event name. Used together with THREAD_ID for grouping events.
COUNT_STAR
Number of summarized events
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
This page is licensed: CC BY-SA / Gnu FDL
This table provides a global summary of wait events aggregated by event name, showing total server-wide wait statistics.
The Performance Schema events_waits_summary_global_by_event_name table contains wait events summarized by event name. It contains the following columns:
EVENT_NAME
Event name.
COUNT_STAR
Number of summarized events
SUM_TIMER_WAIT
Total wait time of the summarized events that are timed.
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
This page is licensed: CC BY-SA / Gnu FDL
The global_status table provides a persistent view of global server status variables, aggregating statistics across all threads.
The global_status table contains a list of status variables and their global values. The table only stores status variable statistics for threads which are instrumented, and does not collect statistics for Com_xxx variables.
The table contains the following columns:
resets global status variables, including thread, account, host, and user status, but not those that are never reset by the server.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes wait events per instrument instance, allowing detailed analysis of specific locks, mutexes, or conditions.
The Performance Schema events_waits_summary_by_instance table contains wait events summarized by instance. It contains the following columns:
EVENT_NAME
Event name. Used together with OBJECT_INSTANCE_BEGIN for grouping events.
OBJECT_INSTANCE_BEGIN
If an instrument creates multiple instances, each instance has a unique OBJECT_INSTANCE_BEGIN value to allow for grouping by instance.
COUNT_STAR
Number of summarized events
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
This page is licensed: CC BY-SA / Gnu FDL
The performance_timers table lists available event timers (cycle, nanosecond, microsecond, millisecond) and their overhead characteristics.
The performance_timers table lists available event timers.
It contains the following columns:
Any NULL values indicate that particular timer is not available on your platform, Any timer names with a non-NULL value can be used in the table.
This page is licensed: CC BY-SA / Gnu FDL
The setup_objects table configures which database objects (tables, stored programs) are instrumented, enabling filtering by schema or name.
The setup_objects table determines whether objects are monitored by the performance schema or not. By default limited to 100 rows, this can be changed by setting the performance_schema_setup_objects_size system variable when the server starts.
It contains the following columns:
When the Performance Schema looks for matches in the setup_objects, there may be more than one row matching, with different ENABLED and TIMED values. It looks for the most specific matches first, that is, it will first look for the specific database and table name combination, then the specific database, only then falling back to a wildcard for both.
Rows can be added or removed from the table, while for existing rows, only the TIMED and ENABLED columns can be updated. By default, all tables except those in the performance_schema, information_schema and mysql databases are instrumented.
This page is licensed: CC BY-SA / Gnu FDL
This table exposes connection attributes for the current session's account, providing metadata passed by the client application for identification.
The session_account_connect_attrs table shows connection attributes for the current session.
Applications can pass key/value connection attributes to the server when a connection is made. The session_connect_attrs and session_account_connect_attrs tables provide access to this information, for all sessions and the current session respectively.
The C API functions and are used for passing connection attributes to the server.
session_account_connect_attrs contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
This table displays the configuration parameters used by the replica to connect to the primary server, such as host, port, and user credentials.
The Performance Schema replication_applier_configuration table contains configuration settings affecting replica transactions.
It contains the following fields.
This page is licensed: CC BY-SA / Gnu FDL
The status_by_thread table lists session status variables for each active thread, effectively providing a "SHOW SESSION STATUS" for every connection.
The status_by_thread table contains status variable information about active foreground threads. The table does not collect statistics for Com_xxx variables.
The table contains the following columns:
If is run, will aggregate the status for all threads to the global status and account status, then reset the thread status. If account statistics are not collected but host and user status are, the session status is added to host and user status.
This page is licensed: CC BY-SA / Gnu FDL
The replication_applier_status_by_worker table provides status information for each worker thread involved in parallel replication.
The Performance Schema replication_applier_status table contains information about the general transaction execution status on the replica.
It contains the following fields.
This page is licensed: CC BY-SA / Gnu FDL
The status_by_host table aggregates session status variables by client host, useful for tracking activity levels from specific application servers.
The status_by_host table contains status variable information by host. The table does not collect statistics for Com_xxx variables.
The table contains the following columns:
If is run, will reset the aggregated host status from terminated sessions.
If is run, session status from all active sessions are added to the global status variables, the status of all active sessions are reset, and values aggregated from disconnected sessions are reset.
This page is licensed: CC BY-SA / Gnu FDL
The rwlock_instances table lists all active read-write lock instances, showing the write-lock owner and the number of waiting readers or writers.
The prepared_statements_instances table contains aggregated statistics of prepared statements.
The maximum number of rows in the table is determined by the performance_schema_max_prepared_statement_instances system variable, which is by default autosized on startup.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
The status_by_user table aggregates session status variables by user name, summarizing activity across all connections for a specific user identity.
The status_by_account table contains status variable information by user. The table does not collect statistics for Com_xxx variables.
The table contains the following columns:
If is run, will reset the aggregated user status from terminated sessions.
If is run, session status from all active sessions are added to the global status variables, the status of all active sessions are reset, and values aggregated from disconnected sessions are reset.
This page is licensed: CC BY-SA / Gnu FDL
The socket_instances table lists active network socket connections, providing details such as the IP address, port, and state of each socket.
The socket_instances table lists active server connections, with each record being a Unix socket file or TCP/IP connection.
The socket_instances table contains the following columns:
EVENT_NAME
NAME from the setup_instruments table, and the name of the wait/io/socket/* instrument that produced the event.
OBJECT_INSTANCE_BEGIN
Memory address of the object.
This page is licensed: CC BY-SA / Gnu FDL
The rwlock_instances table lists all active read-write lock instances, showing the write-lock owner and the number of waiting readers or writers.
The rwlock_instances table lists all read write lock (rwlock) instances that the Performance Schema sees while the server is executing. A read write is a mechanism for ensuring threads can either share access to common resources, or have exclusive access.
The performance_schema_max_rwlock_instances system variable specifies the maximum number of instrumented rwlock objects.
The rwlock_instances table contains the following columns:
NAME
Instrument name associated with the read write lock
This page is licensed: CC BY-SA / Gnu FDL
The setup_actors table configures which foreground threads (users/hosts) are monitored, allowing for targeted instrumentation of specific accounts.
The setup_actors table contains information for determining whether monitoring should be enabled for new client connection threads.
The default size is 100 rows, which can be changed by modifying the performance_schema_setup_actors_size system variable at server startup.
If a row in the table matches a new foreground thread's client and host, the matching INSTRUMENTED column in the threads table is set to either YES orNO, which allows selective application of instrumenting by host, by user, or combination thereof.
Initially, any user and host is matched:
This page is licensed: CC BY-SA / Gnu FDL
This table records the ten most recent completed stage events per thread, useful for analyzing recent thread activity.
The events_stages_history table by default contains the ten most recent completed stage events per thread. This number can be adjusted by setting the system variable when the server starts up.
The table structure is identical to the table structure, and contains the following columns:
This table summarizes wait events aggregated by client account and event name, providing statistics on wait times and execution counts.
The events_waits_summary_by_account_by_event_name table contains wait events summarized by account and event name. It contains the following columns:
This table summarizes wait events aggregated by client host and event name, helping to analyze wait latencies on a per-host basis.
The events_waits_summary_by_host_by_event_name table contains wait events summarized by host and event name. It contains the following columns:
The setup_consumers table controls which consumers (destinations) are enabled to store event data, managing the flow of metrics to history tables.
Lists the types of consumers for which event information is available.
The setup_consumers table contains the following columns:
The table can be modified directly, or the server started with the option enabled, for example:
The replication_applier_status_by_worker table provides status information for each worker thread involved in parallel replication.
The replication_applier_status_by_worker table displays replica worker thread specific information.
It contains the following fields.
This table aggregates usage statistics for objects (tables, events, etc.) by type, schema, and name, showing global access counts and timers.
It aggregates object wait events, and contains the following columns:
This table shows the status of the coordinator thread when parallel replication is enabled, detailing the distribution of transactions to workers.
The replication_applier_status_by_coordinator table displays the status of the coordinator thread used in multi-threaded replicas to manage multiple worker threads.
It contains the following fields.
The table_handles table lists all open table handles, showing which threads are currently accessing which table instances and the locks they hold.
The table_handles table contains table lock information. It uses the wait/lock/table/sql/handler instrument, which is enabled by default.
Information includes which table handles are open, which sessions are holding the locks, and how they are locked.
The table is read-only, and cannot be performed on the table.
The status_by_account table aggregates session status variables by client account, showing cumulative counters for specific user-host combinations.
The status_by_account table contains status variable information by user/host account. The table does not collect statistics for Com_xxx variables.
The table contains the following columns:
The setup_timers table defines the timer type (e.g., NANOSECOND, MICROSECOND) used for each instrument class within the Performance Schema.
SELECT * FROM performance_schema.accounts;
+------------------+-----------+---------------------+-------------------+
| USER | HOST | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+------------------+-----------+---------------------+-------------------+
| root | localhost | 1 | 2 |
| NULL | NULL | 20 | 23 |
| debian-sys-maint | localhost | 0 | 35 |
+------------------+-----------+---------------------+-------------------++-----------------------------+--------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+--------------------------------------------------------+------+-----+---------+-------+
| OBJECT_INSTANCE_BEGIN | bigint(20) unsigned | NO | | NULL | |
| STATEMENT_ID | bigint(20) unsigned | NO | | NULL | |
| STATEMENT_NAME | varchar(64) | YES | | NULL | |
| SQL_TEXT | longtext | NO | | NULL | |
| OWNER_THREAD_ID | bigint(20) unsigned | NO | | NULL | |
| OWNER_EVENT_ID | bigint(20) unsigned | NO | | NULL | |
| OWNER_OBJECT_TYPE | enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER') | YES | | NULL | |
| OWNER_OBJECT_SCHEMA | varchar(64) | YES | | NULL | |
| OWNER_OBJECT_NAME | varchar(64) | YES | | NULL | |
| TIMER_PREPARE | bigint(20) unsigned | NO | | NULL | |
| COUNT_REPREPARE | bigint(20) unsigned | NO | | NULL | |
| COUNT_EXECUTE | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_EXECUTE | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_EXECUTE | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_EXECUTE | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_EXECUTE | bigint(20) unsigned | NO | | NULL | |
| SUM_LOCK_TIME | bigint(20) unsigned | NO | | NULL | |
| SUM_ERRORS | bigint(20) unsigned | NO | | NULL | |
| SUM_WARNINGS | bigint(20) unsigned | NO | | NULL | |
| SUM_ROWS_AFFECTED | bigint(20) unsigned | NO | | NULL | |
| SUM_ROWS_SENT | bigint(20) unsigned | NO | | NULL | |
| SUM_ROWS_EXAMINED | bigint(20) unsigned | NO | | NULL | |
| SUM_CREATED_TMP_DISK_TABLES | bigint(20) unsigned | NO | | NULL | |
| SUM_CREATED_TMP_TABLES | bigint(20) unsigned | NO | | NULL | |
| SUM_SELECT_FULL_JOIN | bigint(20) unsigned | NO | | NULL | |
| SUM_SELECT_FULL_RANGE_JOIN | bigint(20) unsigned | NO | | NULL | |
| SUM_SELECT_RANGE | bigint(20) unsigned | NO | | NULL | |
| SUM_SELECT_RANGE_CHECK | bigint(20) unsigned | NO | | NULL | |
| SUM_SELECT_SCAN | bigint(20) unsigned | NO | | NULL | |
| SUM_SORT_MERGE_PASSES | bigint(20) unsigned | NO | | NULL | |
| SUM_SORT_RANGE | bigint(20) unsigned | NO | | NULL | |
| SUM_SORT_ROWS | bigint(20) unsigned | NO | | NULL | |
| SUM_SORT_SCAN | bigint(20) unsigned | NO | | NULL | |
| SUM_NO_INDEX_USED | bigint(20) unsigned | NO | | NULL | |
| SUM_NO_GOOD_INDEX_USED | bigint(20) unsigned | NO | | NULL | |
+-----------------------------+--------------------------------------------------------+------+-----+---------+-------+NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
NESTING_EVENT_ID
EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE
Nesting event type. One of transaction, statement, stage or wait.
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID
NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if timing is not collected.
NESTING_EVENT_ID
EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE
Nesting event type. One of transaction, statement, stage or wait.
VARIABLE_NAME
The global status variable name.
VARIABLE_VALUE
The global status variable value.
OBJECT_TYPE
Type of object to instrument, currently only . Currently, only TABLE', for base table.
OBJECT_SCHEMA
Schema containing the object, either the literal or % for any schema.
OBJECT_NAME
Name of the instrumented object, either the literal or % for any object.
ENABLED
Whether the object's events are instrumented or not. Can be disabled, in which case monitoring is not enabled for those objects.
TIMED
Whether the object's events are timed or not. Can be modified.
CHANNEL_NAME
char(64)
NO
Replication channel name.
DESIRED_DELAY
int(11)
NO
Target number of seconds the replica should be delayed to the master.
THREAD_ID
The thread identifier of the session in which the status variable is defined.
VARIABLE_NAME
Status variable name.
VARIABLE_VALUE
Aggregated status variable value.
CHANNEL_NAME
char(64)
NO
The replication channel name.
SERVICE_STATE
enum('ON','OFF')
NO
Shows ON when the replication channel's applier threads are active or idle, OFF means that the applier threads are not active.
REMAINING_DELAY
int(10) unsigned
YES
Seconds the replica needs to wait to reach the desired delay from master.
COUNT_TRANSACTIONS_RETRIES
bigint(20) unsigned
NO
The number of retries that were made because the replication SQL thread failed to apply a transaction.
HOST
Host for which the status variable is reported.
VARIABLE_NAME
Status variable name.
VARIABLE_VALUE
Aggregated status variable value
USER
User for which the status variable is reported.
VARIABLE_NAME
Status variable name.
VARIABLE_VALUE
Aggregated status variable value
THREAD_ID
Thread identifier that the server assigns to each socket.
SOCKET_ID
The socket's internal file handle.
IP
Client IP address. Blank for Unix socket file, otherwise an IPv4 or IPv6 address. Together with the PORT identifies the connection.
PORT
TCP/IP port number, from 0 to 65535. Together with the IP identifies the connection.
STATE
Socket status, either IDLE if waiting to receive a request from a client, or ACTIVE
OBJECT_INSTANCE_BEGIN
Address in memory of the instrumented lock
WRITE_LOCKED_BY_THREAD_ID
THREAD_ID of the locking thread if locked in write (exclusive) mode, otherwise NULL.
READ_LOCKED_BY_COUNT
Count of current read locks held
NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if timing is not collected.
NESTING_EVENT_ID
EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE
Nesting event type. One of transaction, statement, stage or wait.
It is possible to empty this table with a TRUNCATE TABLE statement.
events_stages_current and events_stages_history_long are related tables.
This page is licensed: CC BY-SA / Gnu FDL
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID
USER
User for which the status variable is reported.
HOST
Host for which the status variable is reported.
VARIABLE_NAME
Status variable name.
VARIABLE_VALUE
Aggregated status variable value
If TRUNCATE TABLE is run, will aggregate the status from terminated sessions to user and host status, then reset the account status.
If FLUSH STATUS is run, session status from all active sessions are added to the global status variables, the status of all active sessions are reset, and values aggregated from disconnected sessions are reset.
This page is licensed: CC BY-SA / Gnu FDL
MIN_TIMER_WAIT
Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT
Average wait time of the timed summarized events.
MAX_TIMER_WAIT
Maximum wait time of the timed summarized events.
SUM_TIMER_WAIT
Total wait time of the timed summarized events.
MIN_TIMER_WAIT
Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT
Average wait time of the timed summarized events.
MAX_TIMER_WAIT
Maximum wait time of the timed summarized events.
SUM_TIMER_WAIT
Total wait time of the timed summarized events.
MIN_TIMER_WAIT
Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT
Average wait time of the timed summarized events.
MAX_TIMER_WAIT
Maximum wait time of the timed summarized events.
COUNT_STAR
Number of summarized events, which includes all timed and untimed events.
SUM_TIMER_WAIT
Total wait time of the timed summarized events.
MIN_TIMER_WAIT
Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT
Average wait time of the timed summarized events.
MAX_TIMER_WAIT
Maximum wait time of the timed summarized events.
SUM_TIMER_WAIT
Total wait time of the timed summarized events.
MIN_TIMER_WAIT
Minimum wait time of the timed summarized events.
AVG_TIMER_WAIT
Average wait time of the timed summarized events.
MAX_TIMER_WAIT
Maximum wait time of the timed 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.
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.
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.
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.
TIMER_NAME
Time name, used in the setup_timers table.
TIMER_FREQUENCY
Number of timer units per second. Dependent on the processor speed.
TIMER_RESOLUTION
Number of timer units by which timed values increase each time.
TIMER_OVERHEAD
Minimum timer overhead, determined during initialization by calling the timer 20 times and selecting the smallest value. Total overhead will be at least double this, as the timer is called at the beginning and end of each timed event.
HOST
Host name, either a literal, or the % wildcard representing any host.
USER
User name, either a literal or the % wildcard representing any name.
ROLE
Unused
SELECT * FROM performance_schema.setup_actors;
+------+------+------+
| HOST | USER | ROLE |
+------+------+------+
| % | % | % |
+------+------+------+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.
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
This page is licensed: CC BY-SA / Gnu FDL
USER
User. Used together with HOST and EVENT_NAME for grouping events.
HOST
Host. Used together with USER and EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with USER and HOST for grouping events.
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.
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
This page is licensed: CC BY-SA / Gnu FDL
HOST
Host. Used together with EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with USER and HOST for grouping events.
COUNT_STAR
Number of summarized events
SUM_TIMER_WAIT
This page is licensed: CC BY-SA / Gnu FDL
NAME
Consumer name
ENABLED
YES or NO for whether or not the consumer is enabled. You can modify this column to ensure that event information is added, or is not added.
performance-schema-consumer-events-waits-history=ONSUM_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.
This page is licensed: CC BY-SA / Gnu FDL
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
NAME
Type of instrument the timer is used for.
TIMER_NAME
Timer applying to the instrument type. Can be modified.
The TIMER_NAME value can be changed to choose a different timer, and can be any non-NULL value in the performance_timers.TIMER_NAME column.
If you modify the table, monitoring is immediately affected, and currently monitored events would use a combination of old and new timers, which is probably undesirable. It is best to reset the Performance Schema statistics if you make changes to this table.
This page is licensed: CC BY-SA / Gnu FDL
SELECT * FROM setup_timers;
+-----------+-------------+
| NAME | TIMER_NAME |
+-----------+-------------+
| idle | MICROSECOND |
| wait | CYCLE |
| stage | NANOSECOND |
| statement | NANOSECOND |
+-----------+-------------+SELECT * FROM events_stages_summary_global_by_event_name\G
...
*************************** 106. row ***************************
EVENT_NAME: stage/sql/Waiting for trigger metadata lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 107. row ***************************
EVENT_NAME: stage/sql/Waiting for event metadata lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 108. row ***************************
EVENT_NAME: stage/sql/Waiting for commit lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 109. row ***************************
EVENT_NAME: stage/aria/Waiting for a resource
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0SELECT * FROM events_stages_summary_by_host_by_event_name\G
...
*************************** 216. row ***************************
HOST: NULL
EVENT_NAME: stage/sql/Waiting for event metadata lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 217. row ***************************
HOST: NULL
EVENT_NAME: stage/sql/Waiting for commit lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 218. row ***************************
HOST: NULL
EVENT_NAME: stage/aria/Waiting for a resource
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0SELECT * FROM events_stages_summary_by_user_by_event_name\G
...
*************************** 325. row ***************************
USER: NULL
EVENT_NAME: stage/sql/Waiting for event metadata lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 326. row ***************************
USER: NULL
EVENT_NAME: stage/sql/Waiting for commit lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 327. row ***************************
USER: NULL
EVENT_NAME: stage/aria/Waiting for a resource
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0SELECT * FROM events_stages_summary_by_account_by_event_name\G
...
*************************** 325. row ***************************
USER: NULL
HOST: NULL
EVENT_NAME: stage/sql/Waiting for event metadata lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 326. row ***************************
USER: NULL
HOST: NULL
EVENT_NAME: stage/sql/Waiting for commit lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 327. row ***************************
USER: NULL
HOST: NULL
EVENT_NAME: stage/aria/Waiting for a resource
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0SELECT * FROM events_stages_summary_by_thread_by_event_name\G
...
*************************** 2287. row ***************************
THREAD_ID: 64
EVENT_NAME: stage/sql/Waiting for event metadata lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 2288. row ***************************
THREAD_ID: 64
EVENT_NAME: stage/sql/Waiting for commit lock
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 2289. row ***************************
THREAD_ID: 64
EVENT_NAME: stage/aria/Waiting for a resource
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0SELECT * FROM events_waits_summary_by_user_by_event_name\G
...
*************************** 916. row ***************************
USER: NULL
EVENT_NAME: wait/io/socket/sql/server_unix_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 917. row ***************************
USER: NULL
EVENT_NAME: wait/io/socket/sql/client_connection
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 918. row ***************************
USER: NULL
EVENT_NAME: idle
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0SELECT * FROM events_waits_summary_by_thread_by_event_name\G
...
*************************** 6424. row ***************************
THREAD_ID: 64
EVENT_NAME: wait/io/socket/sql/server_unix_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 6425. row ***************************
THREAD_ID: 64
EVENT_NAME: wait/io/socket/sql/client_connection
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 6426. row ***************************
THREAD_ID: 64
EVENT_NAME: idle
COUNT_STAR: 73
SUM_TIMER_WAIT: 22005252162000000
MIN_TIMER_WAIT: 3000000
AVG_TIMER_WAIT: 301441810000000
MAX_TIMER_WAIT: 4912417573000000SELECT * FROM events_waits_summary_global_by_event_name\G
...
*************************** 303. row ***************************
EVENT_NAME: wait/io/socket/sql/server_tcpip_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 304. row ***************************
EVENT_NAME: wait/io/socket/sql/server_unix_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 305. row ***************************
EVENT_NAME: wait/io/socket/sql/client_connection
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 306. row ***************************
EVENT_NAME: idle
COUNT_STAR: 265
SUM_TIMER_WAIT: 46861125181000000
MIN_TIMER_WAIT: 1000000
AVG_TIMER_WAIT: 176834434000000
MAX_TIMER_WAIT: 4912417573000000SELECT * FROM events_waits_summary_by_instance\G
...
*************************** 202. row ***************************
EVENT_NAME: wait/io/file/sql/binlog
OBJECT_INSTANCE_BEGIN: 140578961969856
COUNT_STAR: 6
SUM_TIMER_WAIT: 90478331960
MIN_TIMER_WAIT: 263344
AVG_TIMER_WAIT: 15079721848
MAX_TIMER_WAIT: 67760576376
*************************** 203. row ***************************
EVENT_NAME: wait/io/file/sql/dbopt
OBJECT_INSTANCE_BEGIN: 140578961970560
COUNT_STAR: 6
SUM_TIMER_WAIT: 39891428472
MIN_TIMER_WAIT: 387168
AVG_TIMER_WAIT: 6648571412
MAX_TIMER_WAIT: 24503293304
*************************** 204. row ***************************
EVENT_NAME: wait/io/file/sql/dbopt
OBJECT_INSTANCE_BEGIN: 140578961971264
COUNT_STAR: 6
SUM_TIMER_WAIT: 39902495024
MIN_TIMER_WAIT: 177888
AVG_TIMER_WAIT: 6650415692
MAX_TIMER_WAIT: 21026400404SELECT * FROM performance_timers;
+-------------+-----------------+------------------+---------------------+
| TIMER_NAME | TIMER_FREQUENCY | TIMER_RESOLUTION | TIMER_OVERHEAD |
+-------------+-----------------+------------------+---------------------+
| CYCLE | 2293651741 | 1 | 28 |
| NANOSECOND | 1000000000 | 1 | 48 |
| MICROSECOND | 1000000 | 1 | 52 |
| MILLISECOND | 1000 | 1000 | 9223372036854775807 |
| TICK | 106 | 1 | 496 |
+-------------+-----------------+------------------+---------------------+SELECT * FROM events_waits_summary_by_account_by_event_name\G
...
*************************** 915. row ***************************
USER: NULL
HOST: NULL
EVENT_NAME: wait/io/socket/sql/server_tcpip_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 916. row ***************************
USER: NULL
HOST: NULL
EVENT_NAME: wait/io/socket/sql/server_unix_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 917. row ***************************
USER: NULL
HOST: NULL
EVENT_NAME: wait/io/socket/sql/client_connection
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 918. row ***************************
USER: NULL
HOST: NULL
EVENT_NAME: idle
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0SELECT * FROM events_waits_summary_by_host_by_event_name\G
...
*************************** 610. row ***************************
HOST: NULL
EVENT_NAME: wait/io/socket/sql/server_unix_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 611. row ***************************
HOST: NULL
EVENT_NAME: wait/io/socket/sql/client_connection
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 612. row ***************************
HOST: NULL
EVENT_NAME: idle
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0SELECT * FROM performance_schema.setup_consumers;
+--------------------------------+---------+
| NAME | ENABLED |
+--------------------------------+---------+
| events_stages_current | NO |
| events_stages_history | NO |
| events_stages_history_long | NO |
| events_statements_current | YES |
| events_statements_history | NO |
| events_statements_history_long | NO |
| events_waits_current | NO |
| events_waits_history | NO |
| events_waits_history_long | NO |
| global_instrumentation | YES |
| thread_instrumentation | YES |
| statements_digest | YES |
+--------------------------------+---------+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: 1140576CHANNEL_NAME
Name of replication channel through which the transaction is received.
THREAD_ID
Thread_Id as displayed in the table for thread with name 'thread/sql/rpl_parallel_thread'. THREAD_ID will be NULL when worker threads are stopped due to error/force stop.
SERVICE_STATE
Whether or not the thread is running.
LAST_SEEN_TRANSACTION
Last GTID executed by worker
LAST_ERROR_NUMBER
Last Error that occurred on a particular worker.
LAST_ERROR_MESSAGE
Last error specific message.
LAST_ERROR_TIMESTAMP
Time stamp of last error.
WORKER_IDLE_TIME
Total idle time in seconds that the worker thread has spent waiting for work from SQL thread.
LAST_TRANS_RETRY_COUNT
Total number of retries attempted by last transaction.
This page is licensed: CC BY-SA / Gnu FDL
CHANNEL_NAME
varchar(256)
NO
Replication channel name.
THREAD_ID
bigint(20) unsigned
YES
The SQL/coordinator thread ID.
SERVICE_STATE
enum('ON','OFF')
NO
ON (thread exists and is active or idle) or OFF (thread no longer exists).
LAST_ERROR_NUMBER
int(11)
NO
Last error number that caused the SQL/coordinator thread to stop.
LAST_ERROR_MESSAGE
This page is licensed: CC BY-SA / Gnu FDL
The table contains the following columns:
OBJECT_TYPE
The table opened by a table handle.
OBJECT_SCHEMA
The schema that contains the object.
OBJECT_NAME
The name of the instrumented object.
OBJECT_INSTANCE_BEGIN
The table handle address in memory.
OWNER_THREAD_ID
The thread owning the table handle.
OWNER_EVENT_ID
The event which caused the table handle to be opened.
This page is licensed: CC BY-SA / Gnu FDL
PROCESSLIST_ID
Session connection identifier.
ATTR_NAME
Attribute name.
ATTR_VALUE
Attribute value.
ORDINAL_POSITION
Order in which attribute was added to the connection attributes.
This table summarizes stage events aggregated by the client account and the specific event name, showing counts and wait times.
The events_transactions_summary_by_account_by_event_name table contains information on transaction events aggregated by account and event name.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes stage events aggregated by the client host and the event name, allowing performance analysis per host.
The events_transactions_summary_by_host_by_event_name table contains information on transaction events aggregated by host and event name.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
This table aggregates statement events by schema and digest, providing execution counts, latency, and locking statistics for normalized queries.
The Performance Schema digest is a hashed, normalized form of a statement with the specific data values removed. It allows statistics to be gathered for similar kinds of statements.
The Performance Schema events_statements_summary_by_digest table records statement events summarized by schema and digest. It contains the following columns:
SCHEMA NAME
Database name. Records are summarised together with DIGEST.
DIGEST
. Records are summarised together with SCHEMA NAME.
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
The events_statements_summary_by_digest table is limited in size by the system variable. Once the limit has been reached and the table is full, all entries are aggregated in a row with a NULL digest. The COUNT_STAR value of this NULL row indicates how many digests are recorded in the row and therefore gives an indication of whether performance_schema_digests_size should be increased to provide more accurate statistics.
This page is licensed: CC BY-SA / Gnu FDL
The events_waits_history_long table stores the most recent 10,000 completed wait events globally, autosized at startup.
The events_waits_history_long table by default contains the ten thousand most recent completed wait events. This number can be adjusted by setting the performance_schema_events_waits_history_long_size system variable when the server starts up.
The table structure is identical to the events_waits_current table structure, and contains the following columns:
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together withTHREAD_IDuniquely identifies the row.
It is possible to empty this table with a TRUNCATE TABLE statement.
events_waits_current and events_waits_history are related tables.
This page is licensed: CC BY-SA / Gnu FDL
This table records the ten most recent completed wait events per thread, useful for diagnosing recent latency issues.
The events_waits_history table by default contains the ten most recent completed wait events per thread. This number can be adjusted by setting the performance_schema_events_waits_history_size system variable when the server starts up.
The table structure is identical to the events_waits_current table structure, and contains the following columns:
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
It is possible to empty this table with a TRUNCATE TABLE statement.
and are related tables.
This page is licensed: CC BY-SA / Gnu FDL
The metadata_locks table lists currently held and requested metadata locks, which protect database object definitions from concurrent modification.
The metadata_locks table contains metadata lock information.
To enable metadata lock instrumention, at runtime:
UPDATE performance_schema.setup_instruments SET enabled='YES', timed='YES'
WHERE name LIKE 'wait/lock/metadata%';Or in the configuration file:
performance-schema-instrument='wait/lock/metadata/sql/mdl=ON'The table is by default autosized, but the size can be configured with the performance_schema_max_metadata_locks system variable.
The table is read-only, and cannot be used to empty the table.
The table contains the following columns:
OBJECT_TYPE
VARCHAR(64)
Null: No
Default: NULL
This page is licensed: CC BY-SA / Gnu FDL
This table provides a global summary of statement events aggregated by event name, showing total execution counts and wait times for the server.
The events_statements_summary_global_by_event_name table contains statement events summarized by event name. It contains the following columns:
The events_transactions_current table displays the current transaction event for each thread, including state, isolation level, and GTID.
The events_transactions_current table contains current transaction events for each thread.
The table size cannot be figured, and always stores one row for each thread, showing the current status of the thread's most recent monitored transaction event.
The table contains the following columns:
This table records the ten most recent completed stage events per thread, useful for analyzing recent thread activity.
The events_transactions_history table contains the most recent completed transaction events for each thread.
The number of records stored per thread in the table is determined by the system variable, which is autosized on startup.
If adding a completed transaction event would cause the table to exceed this limit, the oldest thread row is discarded.
All of a thread's rows are discarded when the thread ends.
The events_waits_current table displays the most recent wait event for each thread, including timer and object information.
The events_waits_current table contains the status of a thread's most recently monitored wait event, listing one event per thread.
The table contains the following columns:
This table summarizes file I/O events aggregated by file instance, providing granular I/O statistics for individual files.
The file_summary_by_instance table contains file events summarized by instance. It contains the following columns:
The host_cache table exposes the internal host cache contents, including IP-to-hostname resolution details and connection error counters.
The host_cache table contains host and IP information from the host_cache, used for avoiding DNS lookups for new client connections.
The host_cache table contains the following columns:
This table summarizes memory usage events aggregated by client account and event name, tracking current usage and high-water marks.
There are five memory summary tables in the Performance Schema that share a number of fields in common. These include:
This table exposes user-defined variables set within active threads, allowing inspection of custom variables across all sessions.
The user_variables_by_thread table contains information about and the threads that defined them.
cannot be performed on the table.
The table contains the following columns:
SELECT * FROM performance_schema.session_account_connect_attrs;
+----------------+-----------------+------------------+------------------+
| PROCESSLIST_ID | ATTR_NAME | ATTR_VALUE | ORDINAL_POSITION |
+----------------+-----------------+------------------+------------------+
| 45 | _os | debian-linux-gnu | 0 |
| 45 | _client_name | libmysql | 1 |
| 45 | _pid | 7711 | 2 |
| 45 | _client_version | 10.0.5 | 3 |
| 45 | _platform | x86_64 | 4 |
| 45 | program_name | mysql | 5 |
+----------------+-----------------+------------------+------------------+varchar(1024)
NO
Last error message that caused the SQL/coordinator thread to stop.
LAST_ERROR_TIMESTAMP
timestamp
NO
Timestamp that shows when the most recent SQL/coordinator error occured.
LAST_SEEN_TRANSACTION
char(57)
NO
The transaction the worker has last seen.
LAST_TRANS_RETRY_COUNT
int(11)
NO
Total number of retries attempted by last transaction.
INTERNAL_LOCK
The table lock used at the SQL level.
EXTERNAL_LOCK
The table lock used at the storage engine level.
DIGEST TEXT
The unhashed form of the digest.
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.
SUM_LOCK_TIME
Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS
Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS
Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED
Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT
Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED
Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES
Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES
Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN
Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN
Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE
Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK
Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN
Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES
Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE
Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS
Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN
Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED
Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED
Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.
FIRST_SEEN
Time at which the digest was first seen.
LAST_SEEN
Time at which the digest was most recently seen.
END_EVENT_ID
NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if timing is not collected.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if timing is not collected.
SPINS
Number of spin rounds for a mutex, or NULL if spin rounds are not used, or spinning is not instrumented.
OBJECT_SCHEMA
Name of the schema that contains the table for table I/O objects, otherwise NULL for file I/O and synchronization objects.
OBJECT_NAME
File name for file I/O objects, table name for table I/O objects, the socket's IP:PORT value for a socket object or NULL for a synchronization object.
INDEX_NAME
Name of the index, PRIMARY for the primary key, or NULL for no index used.
OBJECT_TYPE
FILE for a file object, TABLE or TEMPORARY TABLE for a table object, or NULL for a synchronization object.
OBJECT_INSTANCE_BEGIN
Address in memory of the object.
NESTING_EVENT_ID
EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE
Nesting event type. Either statement, stage or wait.
OPERATION
Operation type, for example read, write or lock
NUMBER_OF_BYTES
Number of bytes that the operation read or wrote, or NULL for table I/O waits.
FLAGS
Reserved for use in the future.
END_EVENT_ID
NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if timing is not collected.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if timing is not collected.
SPINS
Number of spin rounds for a mutex, or NULL if spin rounds are not used, or spinning is not instrumented.
OBJECT_SCHEMA
Name of the schema that contains the table for table I/O objects, otherwise NULL for file I/O and synchronization objects.
OBJECT_NAME
File name for file I/O objects, table name for table I/O objects, the socket's IP:PORT value for a socket object or NULL for a synchronization object.
INDEX NAME
Name of the index, PRIMARY for the primary key, or NULL for no index used.
OBJECT_TYPE
FILE for a file object, TABLE or TEMPORARY TABLE for a table object, or NULL for a synchronization object.
OBJECT_INSTANCE_BEGIN
Address in memory of the object.
NESTING_EVENT_ID
EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE
Nesting event type. Either statement, stage or wait.
OPERATION
Operation type, for example read, write or lock
NUMBER_OF_BYTES
Number of bytes that the operation read or wrote, or NULL for table I/O waits.
FLAGS
Reserved for use in the future.
The minimum wait time of the summarized timed events.
AVG_TIMER_WAIT
bigint(20) unsigned
The average wait time of the summarized timed events.
MAX_TIMER_WAIT
bigint(20) unsigned
The maximum wait time of the summarized timed events.
COUNT_READ_WRITE
bigint(20) unsigned
The total number of only READ/WRITE transaction events.
SUM_TIMER_READ_WRITE
bigint(20) unsigned
The total wait time of only READ/WRITE transaction events.
MIN_TIMER_READ_WRITE
bigint(20) unsigned
The minimum wait time of only READ/WRITE transaction events.
AVG_TIMER_READ_WRITE
bigint(20) unsigned
The average wait time of only READ/WRITE transaction events.
MAX_TIMER_READ_WRITE
bigint(20) unsigned
The maximum wait time of only READ/WRITE transaction events.
COUNT_READ_ONLY
bigint(20) unsigned
The total number of only READ ONLY transaction events.
SUM_TIMER_READ_ONLY
bigint(20) unsigned
The total wait time of only READ ONLY transaction events.
MIN_TIMER_READ_ONLY
bigint(20) unsigned
The minimum wait time of only READ ONLY transaction events.
AVG_TIMER_READ_ONLY
bigint(20) unsigned
The average wait time of only READ ONLY transaction events.
MAX_TIMER_READ_ONLY
bigint(20) unsigned
The maximum wait time of only READ ONLY transaction events.
USER
char(32)
User for which summary is generated.
HOST
char(60)
Host for which summary is generated.
EVENT_NAME
varchar(128)
Event name for which summary is generated.
COUNT_STAR
bigint(20) unsigned
The number of summarized events. This value includes all events, whether timed or nontimed.
SUM_TIMER_WAIT
bigint(20) unsigned
The total wait time of the summarized timed events. This value is calculated only for timed events because nontimed events have a wait time of NULL. The same is true for the other xxx_TIMER_WAIT values.
MIN_TIMER_WAIT
bigint(20) unsigned
The average wait time of the summarized timed events.
MAX_TIMER_WAIT
bigint(20) unsigned
The maximum wait time of the summarized timed events.
COUNT_READ_WRITE
bigint(20) unsigned
The total number of only READ/WRITE transaction events.
SUM_TIMER_READ_WRITE
bigint(20) unsigned
The total wait time of only READ/WRITE transaction events.
MIN_TIMER_READ_WRITE
bigint(20) unsigned
The minimum wait time of only READ/WRITE transaction events.
AVG_TIMER_READ_WRITE
bigint(20) unsigned
The average wait time of only READ/WRITE transaction events.
MAX_TIMER_READ_WRITE
bigint(20) unsigned
The maximum wait time of only READ/WRITE transaction events.
COUNT_READ_ONLY
bigint(20) unsigned
The total number of only READ ONLY transaction events.
SUM_TIMER_READ_ONLY
bigint(20) unsigned
The total wait time of only READ ONLY transaction events.
MIN_TIMER_READ_ONLY
bigint(20) unsigned
The minimum wait time of only READ ONLY transaction events.
AVG_TIMER_READ_ONLY
bigint(20) unsigned
The average wait time of only READ ONLY transaction events.
MAX_TIMER_READ_ONLY
bigint(20) unsigned
The maximum wait time of only READ ONLY transaction events.
HOST
char(60)
Host for which summary is generated.
EVENT_NAME
varchar(128)
Event name for which summary is generated.
COUNT_STAR
bigint(20) unsigned
The number of summarized events. This value includes all events, whether timed or nontimed.
SUM_TIMER_WAIT
bigint(20) unsigned
The total wait time of the summarized timed events. This value is calculated only for timed events because nontimed events have a wait time of NULL. The same is true for the other xxx_TIMER_WAIT values.
MIN_TIMER_WAIT
bigint(20) unsigned
The minimum wait time of the summarized timed events.
AVG_TIMER_WAIT
bigint(20) unsigned
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
SPINS
Number of spin rounds for a mutex, or NULL if spin rounds are not used, or spinning is not instrumented.
OBJECT_SCHEMA
Name of the schema that contains the table for table I/O objects, otherwise NULL for file I/O and synchronization objects.
OBJECT_NAME
File name for file I/O objects, table name for table I/O objects, the socket's IP:PORT value for a socket object or NULL for a synchronization object.
INDEX NAME
Name of the index, PRIMARY for the primary key, or NULL for no index used.
OBJECT_TYPE
FILE for a file object, TABLE or TEMPORARY TABLE for a table object, or NULL for a synchronization object.
OBJECT_INSTANCE_BEGIN
Address in memory of the object.
NESTING_EVENT_ID
EVENT_ID of event within which this event nests.
NESTING_EVENT_TYPE
Nesting event type. Either statement, stage or wait.
OPERATION
Operation type, for example read, write or lock
NUMBER_OF_BYTES
Number of bytes that the operation read or wrote, or NULL for table I/O waits.
FLAGS
Reserved for use in the future.
It is possible to empty this table with a TRUNCATE TABLE statement.
The related tables, events_waits_history and events_waits_history_long derive their values from the current events.
This page is licensed: CC BY-SA / Gnu FDL
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID
NULL when the event starts, set to the thread's current event number at the end of the event.
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.
SUM_LOCK_TIME
Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS
Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS
Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED
Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT
Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED
Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES
Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES
Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN
Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN
Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE
Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK
Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN
Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES
Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE
Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS
Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN
Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED
Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED
Sum 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.
This page is licensed: CC BY-SA / Gnu FDL
EVENT_NAME
Event name.
COUNT_STAR
Number of summarized events
SUM_TIMER_WAIT
Total wait time of the summarized events that are timed.
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.
COUNT_READ
Number of all read operations, including FGETS, FGETC, FREAD, and READ.
SUM_TIMER_READ
Total wait time of all read operations that are timed.
MIN_TIMER_READ
Minimum wait time of all read operations that are timed.
AVG_TIMER_READ
Average wait time of all read operations that are timed.
MAX_TIMER_READ
Maximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READ
Bytes read by read operations.
COUNT_WRITE
Number of all write operations, including FPUTS, FPUTC, FPRINTF, VFPRINTF, FWRITE, and PWRITE.
SUM_TIMER_WRITE
Total wait time of all write operations that are timed.
MIN_TIMER_WRITE
Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE
Average wait time of all write operations that are timed.
MAX_TIMER_WRITE
Maximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITE
Bytes written by write operations.
COUNT_MISC
Number of all miscellaneous operations not counted above, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
SUM_TIMER_MISC
Total wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISC
Minimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISC
Average wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISC
Maximum wait time of all miscellaneous operations that are timed.
I/O operations can be avoided by caching, in which case they will not be recorded in this table.
You can TRUNCATE the table, which will reset all counters to zero.
This page is licensed: CC BY-SA / Gnu FDL
FILE_NAME
File name.
EVENT_NAME
Event name.
OBJECT_INSTANCE_BEGIN
Address in memory. Together with FILE_NAME and EVENT_NAME uniquely identifies a row.
COUNT_STAR
THREAD_ID
The thread identifier of the session in which the variable is defined.
VARIABLE_NAME
The variable name, without the leading @ character.
VARIABLE_VALUE
The variable value
This page is licensed: CC BY-SA / Gnu FDL
SELECT * FROM events_statements_summary_global_by_event_name\G
...
*************************** 173. row ***************************
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
*************************** 174. row ***************************
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: 0SELECT * FROM file_summary_by_instance\G
...
*************************** 204. row ***************************
FILE_NAME: /var/lib/mysql/test/db.opt
EVENT_NAME: wait/io/file/sql/dbopt
OBJECT_INSTANCE_BEGIN: 140578961971264
COUNT_STAR: 6
SUM_TIMER_WAIT: 39902495024
MIN_TIMER_WAIT: 177888
AVG_TIMER_WAIT: 6650415692
MAX_TIMER_WAIT: 21026400404
COUNT_READ: 1
SUM_TIMER_READ: 21026400404
MIN_TIMER_READ: 21026400404
AVG_TIMER_READ: 21026400404
MAX_TIMER_READ: 21026400404
SUM_NUMBER_OF_BYTES_READ: 65
COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
SUM_NUMBER_OF_BYTES_WRITE: 0
COUNT_MISC: 5
SUM_TIMER_MISC: 18876094620
MIN_TIMER_MISC: 177888
AVG_TIMER_MISC: 3775218924
MAX_TIMER_MISC: 18864558060
*************************** 205. row ***************************
FILE_NAME: /var/log/mysql/mariadb-bin.000157
EVENT_NAME: wait/io/file/sql/binlog
OBJECT_INSTANCE_BEGIN: 140578961971968
COUNT_STAR: 6
SUM_TIMER_WAIT: 73985877680
MIN_TIMER_WAIT: 251136
AVG_TIMER_WAIT: 12330979468
MAX_TIMER_WAIT: 73846656340
COUNT_READ: 0
SUM_TIMER_READ: 0
MIN_TIMER_READ: 0
AVG_TIMER_READ: 0
MAX_TIMER_READ: 0
SUM_NUMBER_OF_BYTES_READ: 0
COUNT_WRITE: 2
SUM_TIMER_WRITE: 62583004
MIN_TIMER_WRITE: 27630192
AVG_TIMER_WRITE: 31291284
MAX_TIMER_WRITE: 34952812
SUM_NUMBER_OF_BYTES_WRITE: 369
COUNT_MISC: 4
SUM_TIMER_MISC: 73923294676
MIN_TIMER_MISC: 251136
AVG_TIMER_MISC: 18480823560
MAX_TIMER_MISC: 73846656340SET @var = 0;
SELECT * FROM user_variables_by_thread;
+-----------+---------------+----------------+
| THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE |
+-----------+---------------+----------------+
| 11 | var | 0 |
+-----------+---------------+----------------+Description: Object type. One of BACKUP, COMMIT, EVENT, FUNCTION, GLOBAL, LOCKING SERVICE, PROCEDURE, SCHEMA, TABLE, TABLESPACE, TRIGGER (unused) or USER LEVEL LOCK.
OBJECT_SCHEMA
VARCHAR(64)
Null: Yes
Default: NULL
Description: Object schema.
OBJECT_NAME
VARCHAR(64)
Null: Yes
Default: NULL
Description: Object name.
OBJECT_INSTANCE_BEGIN
BIGINT(20) UNSIGNED
Null: No
Default: NULL
Description: Address in memory of the instrumented object.
LOCK_TYPE
VARCHAR(32)
Null: No
Default: NULL
Description: Lock type. One of BACKUP_FTWRL1, BACKUP_START, BACKUP_TRANS_DML, EXCLUSIVE, INTENTION_EXCLUSIVE, SHARED, SHARED_HIGH_PRIO, SHARED_NO_READ_WRITE, SHARED_NO_WRITE, SHARED_READ, SHARED_UPGRADABLE, or SHARED_WRITE
LOCK_DURATION
VARCHAR(32)
Null: No
Default: NULL
Description: Lock duration. One of EXPLICIT (locks released by explicit action, for example a global lock acquired with FLUSH TABLES WITH READ LOCK) , STATEMENT (locks implicitly released at statement end), or TRANSACTION (locks implicitly released at transaction end).
LOCK_STATUS
VARCHAR(32)
Null: No
Default: NULL
Description: Lock status. One of GRANTED, KILLED, PENDING, POST_RELEASE_NOTIFY, PRE_ACQUIRE_NOTIFY, TIMEOUT, or VICTIM.
SOURCE
VARCHAR(64)
Null: Yes
Default: NULL
Description: Source file containing the instrumented code that produced the event, as well as the line number where the instrumentation occurred. This allows one to examine the source code involved.
OWNER_THREAD_ID
BIGINT(20) UNSIGNED
Null: Yes
Default: NULL
Description: Thread that requested the lock.
OWNER_EVENT_ID
BIGINT(20) UNSIGNED
Null: Yes
Default: NULL
Description: Event that requested the lock.
THREAD_ID
bigint(20) unsigned
The thread associated with the event.
EVENT_ID
bigint(20) unsigned
The event id associated with the event.
END_EVENT_ID
bigint(20) unsigned
This column is set to NULL when the event starts and updated to the thread current event number when the event ends.
EVENT_NAME
varchar(128)
The name of the instrument from which the event was collected. This is a NAME value from the setup_instruments table.
STATE
enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')
The current transaction state. The value is ACTIVE (after START TRANSACTION or BEGIN), COMMITTED (after COMMIT), or ROLLED BACK (after ROLLBACK).
TRX_ID
This page is licensed: CC BY-SA / Gnu FDL
The table contains the following columns:
THREAD_ID
bigint(20) unsigned
The thread associated with the event.
EVENT_ID
bigint(20) unsigned
The event id associated with the event.
END_EVENT_ID
bigint(20) unsigned
This column is set to NULL when the event starts and updated to the thread current event number when the event ends.
EVENT_NAME
varchar(128)
The name of the instrument from which the event was collected. This is a NAME value from the setup_instruments table.
This page is licensed: CC BY-SA / Gnu FDL
SUM_CONNECT_ERRORS
Number of connection errors. Counts only protocol handshake errors for hosts that passed validation. These errors count towards .
COUNT_HOST_BLOCKED_ERRORS
Number of blocked connections because SUM_CONNECT_ERRORS exceeded the system variable.
COUNT_NAMEINFO_TRANSIENT_ERRORS
Number of transient errors during IP-to-host DNS lookups.
COUNT_NAMEINFO_PERMANENT_ERRORS
Number of permanent errors during IP-to-host DNS lookups.
COUNT_FORMAT_ERRORS
Number of host name format errors, for example a numeric host column.
COUNT_ADDRINFO_TRANSIENT_ERRORS
Number of transient errors during host-to-IP reverse DNS lookups.
COUNT_ADDRINFO_PERMANENT_ERRORS
Number of permanent errors during host-to-IP reverse DNS lookups.
COUNT_FCRDNS_ERRORS
Number of forward-confirmed reverse DNS errors, which occur when IP-to-host DNS lookup does not match the originating IP address.
COUNT_HOST_ACL_ERRORS
Number of errors occurring because no user from the host is permitted to log in. These attempts return and do not proceed to username and password authentication.
COUNT_NO_AUTH_PLUGIN_ERRORS
Number of errors due to requesting an authentication plugin that was not available. This can be due to the plugin never having been loaded, or the load attempt failing.
COUNT_AUTH_PLUGIN_ERRORS
Number of errors reported by an authentication plugin. Plugins can increment COUNT_AUTHENTICATION_ERRORS or COUNT_HANDSHAKE_ERRORS instead, but, if specified or the error is unknown, this column is incremented.
COUNT_HANDSHAKE_ERRORS
Number of errors detected at the wire protocol level.
COUNT_PROXY_USER_ERRORS
Number of errors detected when a proxy user is proxied to a user that does not exist.
COUNT_PROXY_USER_ACL_ERRORS
Number of errors detected when a proxy user is proxied to a user that exists, but the proxy user doesn't have the PROXY privilege.
COUNT_AUTHENTICATION_ERRORS
Number of errors where authentication failed.
COUNT_SSL_ERRORS
Number of errors due to TLS problems.
COUNT_MAX_USER_CONNECTIONS_ERRORS
Number of errors due to the per-user quota being exceeded.
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS
Number of errors due to the per-hour quota being exceeded.
COUNT_DEFAULT_DATABASE_ERRORS
Number of errors due to the user not having permission to access the specified default database, or it not existing.
COUNT_INIT_CONNECT_ERRORS
Number of errors due to statements in the system variable.
COUNT_LOCAL_ERRORS
Number of local server errors, such as out-of-memory errors, unrelated to network, authentication, or authorization.
COUNT_UNKNOWN_ERRORS
Number of unknown errors that cannot be allocated to another column.
FIRST_SEEN
Timestamp of the first connection attempt by the IP.
LAST_SEEN
Timestamp of the most recent connection attempt by the IP.
FIRST_ERROR_SEEN
Timestamp of the first error seen from the IP.
LAST_ERROR_SEEN
Timestamp of the most recent error seen from the IP.
The host_cache table, along with the host_cache, is cleared with FLUSH HOSTS, TRUNCATE TABLE host_cache or by setting the host_cache_size system variable at runtime.
This page is licensed: CC BY-SA / Gnu FDL
IP
Client IP address.
HOST
IP's resolved DNS host name, or NULL if unknown.
HOST_VALIDATED
YES if the IP-to-host DNS lookup was successful, and the HOST column can be used to avoid DNS calls, or NO if unsuccessful, in which case DNS lookup is performed for each connect until either successful or a permanent error.
The memory_summary_by_account_by_event_name table contains memory usage statistics aggregated by account and event.
The table contains the following columns:
USER
char(32)
YES
NULL
User portion of the account.
HOST
char(60)
YES
NULL
Host portion of the account.
This page is licensed: CC BY-SA / Gnu FDL
Browse the List of Performance Schema Tables in MariaDB. Access a comprehensive index of tables and descriptions to assist in monitoring server performance.
Below is a list of all Performance Schema tables as well as a brief description of each of them.
Client account connection statistics.
Synchronization object instances.
Current stage events.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes statement events aggregated by user name and event name, helping to identify users executing specific statement types.
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:
USER
User. Used together with EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with USER for grouping events.
COUNT_STAR
Number of summarized events
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
This page is licensed: CC BY-SA / Gnu FDL
The events_stages_history_long table stores the most recent 10,000 completed stage events globally, providing a deeper history than per-thread tables.
The events_transactions_history_long table contains the most recent completed transaction events that have ended globally, across all threads.
The number of records stored in the table is determined by the performance_schema_events_transactions_history_long_size system variable, which is autosized on startup.
If adding a completed transaction would cause the table to exceed this limit, the oldest row, regardless of thread, is discarded.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes statement events aggregated by thread and event name, allowing analysis of statement execution per individual thread.
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:
THREAD_ID
Thread associated with the event. Together with EVENT_NAME uniquely identifies the row.
EVENT_NAME
Event name. Used together with THREAD_ID for grouping events.
COUNT_STAR
Number of summarized events
The *_TIMER_WAIT columns only calculate results for timed events, as non-timed events have a NULL wait time.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes file I/O events aggregated by event name, detailing read/write counts and bytes transferred for each file type.
The Performance Schema file_summary_by_event_name table contains file events summarized by event name. It contains the following columns:
EVENT_NAME
Event name.
COUNT_STAR
Number of summarized events
SUM_TIMER_WAIT
Total wait time of the summarized events that are timed.
I/O operations can be avoided by caching, in which case they will not be recorded in this table.
You can the table, which will reset all counters to zero.
This page is licensed: CC BY-SA / Gnu FDL
This table displays the configuration parameters used by the replica to connect to the primary server, such as host, port, and user credentials.
The Performance Schema replication_connection_configuration table displays replica's configuration settings used for connecting to the primary.
It contains the following fields.
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes memory usage events aggregated by client host and event name, helping to analyze memory consumption patterns per host.
There are five memory summary tables in the Performance Schema that share a number of fields in common. These include:
memory_summary_by_host_by_event_name
The memory_summary_by_host_by_event_name table contains memory usage statistics aggregated by host and event.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes memory usage events aggregated by thread and event name, allowing for detailed memory profiling of individual threads.
There are five memory summary tables in the Performance Schema that share a number of fields in common. These include:
memory_summary_by_thread_by_event_name
The memory_summary_by_thread_by_event_name table contains memory usage statistics aggregated by thread and event.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
This table summarizes memory usage events aggregated by user name and event name, useful for identifying users with high memory footprints.
There are five memory summary tables in the Performance Schema that share a number of fields in common. These include:
memory_summary_by_user_by_event_name
The memory_summary_by_user_by_event_name table contains memory usage statistics aggregated by user and event.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
This table aggregates I/O wait statistics by index, helping to identify which indexes handle the most traffic or are causing latency.
The table_io_waits_summary_by_index_usage table records table I/O waits by index.
OBJECT_TYPE
TABLE in the case of all indexes.
OBJECT_SCHEMA
Schema name.
OBJECT_NAME
Table name.
You can the table, which will reset all counters to zero. The table is also truncated if the table is truncated.
If a table's index structure is changed, index statistics recorded in this table may also be reset.
This page is licensed: CC BY-SA / Gnu FDL
This table records the ten most recent completed statement events per thread, offering a short-term history of executed SQL statements.
The events_statements_history table by default contains the ten most recent completed statement events per thread. This number can be adjusted by setting the system variable when the server starts up.
The table structure is identical to the table structure, and contains the following columns:
The table contains the following columns:
The events_statements_history_long table stores the most recent 10,000 completed statement events globally, providing extensive query history.
The events_statements_history_long table by default contains the ten thousand most recent completed statement events. This number can be adjusted by setting the system variable when the server starts up.
The table structure is identical to the table structure, and contains the following columns:
This table summarizes statement events aggregated by client host and event name, showing execution frequency and wait times per host.
The events_statements_summary_by_host_by_event_name table contains statement events summarized by host and event name. It contains the following columns:
This table summarizes statement events aggregated by client account and event name, detailing execution counts and timer statistics.
The events_statements_summary_by_account_by_event_name table contains statement events summarized by account and event name. It contains the following columns:
This table provides a global summary of memory usage events aggregated by event name, showing total memory allocation across the server.
There are five memory summary tables in the Performance Schema that share a number of fields in common. These include:
The session_connect_attrs table lists connection attributes for the current session, offering details about the client library and environment.
session_connect_attrs is a table that shows connection attributes for all sessions. The Performance Schema needs to be enabled for the table to be populated.
Applications can pass key/value connection attributes to the server when a connection is made. The session_connect_attrs and tables provide access to this information, for all sessions and the current session respectively.
The C API functions and
This table summarizes I/O wait events by table, detailing the frequency and latency of fetch, insert, update, and delete operations.
The table_io_waits_summary_by_table table records table I/O waits by table.
This table summarizes socket I/O events aggregated by event name, showing execution counts and wait times for operations like send and receive.
It aggregates timer and byte count statistics for all socket I/O operations by socket instrument.
This table provides a global summary of statement events aggregated by event name, showing total execution counts and wait times for the server.
The events_transactions_summary_global_by_event_name table contains information on transaction events aggregated by event name.
The table contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
bigint(20) unsigned
Unused.
GTID
varchar(64)
Transaction GTID, using the format DOMAIN-SERVER_ID-SEQUENCE_NO.
XID_FORMAT_ID
int(11)
XA transaction format ID for GTRID and BQUAL values.
XID_GTRID
varchar(130)
XA global transaction ID.
XID_BQUAL
varchar(130)
XA transaction branch qualifier.
XA_STATE
varchar(64)
The state of the XA transaction. The value is ACTIVE (after XA START), IDLE (after XA END), PREPARED (after XA PREPARE), ROLLED BACK (after XA ROLLBACK), or COMMITTED (after XA COMMIT).
SOURCE
varchar(64)
The name of the source file containing the instrumented code that produced the event and the line number in the file at which the instrumentation occurs.
TIMER_START
bigint(20) unsigned
The unit is picoseconds. When event timing started. NULL if event has no timing information.
TIMER_END
bigint(20) unsigned
The unit is picoseconds. When event timing ended. NULL if event has no timing information.
TIMER_WAIT
bigint(20) unsigned
The unit is picoseconds. Event duration. NULL if event has not timing information.
ACCESS_MODE
enum('READ ONLY', 'READ WRITE')
Transaction access mode.
ISOLATION_LEVEL
varchar(64)
Transaction isolation level. One of: REPEATABLE READ, READ COMMITTED, READ UNCOMMITTED, or SERIALIZABLE.
AUTOCOMMIT
enum('YES','NO')
Whether autcommit mode was enabled when the transaction started.
NUMBER_OF_SAVEPOINTS
bigint(20) unsigned
The number of SAVEPOINT statements issued during the transaction.
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
bigint(20) unsigned
The number of ROLLBACK_TO_SAVEPOINT statements issued during the transaction.
NUMBER_OF_RELEASE_SAVEPOINT
bigint(20) unsigned
The number of RELEASE_SAVEPOINT statements issued during the transaction.
OBJECT_INSTANCE_BEGIN
bigint(20) unsigned
Unused.
NESTING_EVENT_ID
bigint(20) unsigned
The EVENT_ID value of the event within which this event is nested.
NESTING_EVENT_TYPE
enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT')
The nesting event type.
STATE
enum('ACTIVE', 'COMMITTED',' ROLLED BACK')
The current transaction state. The value is ACTIVE (after START TRANSACTION or BEGIN), COMMITTED (after COMMIT), or ROLLED BACK (after ROLLBACK).
TRX_ID
bigint(20) unsigned
Unused.
GTID
varchar(64)
Transaction GTID, using the format DOMAIN-SERVER_ID-SEQUENCE_NO.
XID_FORMAT_ID
int(11)
XA transaction format ID for GTRID and BQUAL values.
XID_GTRID
varchar(130)
XA global transaction ID.
XID_BQUAL
varchar(130)
XA transaction branch qualifier.
XA_STATE
varchar(64)
The state of the XA transaction. The value is ACTIVE (after XA START), IDLE (after XA END), PREPARED (after XA PREPARE), ROLLED BACK (after XA ROLLBACK), or COMMITTED (after XA COMMIT).
SOURCE
varchar(64)
The name of the source file containing the instrumented code that produced the event and the line number in the file at which the instrumentation occurs.
TIMER_START
bigint(20) unsigned
The unit is picoseconds. When event timing started. NULL if event has no timing information.
TIMER_END
bigint(20) unsigned
The unit is picoseconds. When event timing ended. NULL if event has no timing information.
TIMER_WAIT
bigint(20) unsigned
The unit is picoseconds. Event duration. NULL if event has not timing information.
ACCESS_MODE
enum('READ ONLY', 'READ WRITE')
Transaction access mode.
ISOLATION_LEVEL
varchar(64)
Transaction isolation level. One of: REPEATABLE READ, READ COMMITTED, READ UNCOMMITTED, or SERIALIZABLE.
AUTOCOMMIT
enum('YES', 'NO')
NO
NUMBER_OF_SAVEPOINTS
bigint(20) unsigned
The number of SAVEPOINT statements issued during the transaction.
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
bigint(20) unsigned
The number of ROLLBACK_TO_SAVEPOINT statements issued during the transaction.
NUMBER_OF_RELEASE_SAVEPOINT
bigint(20) unsigned
The number of RELEASE_SAVEPOINT statements issued during the transaction.
OBJECT_INSTANCE_BEGIN
bigint(20) unsigned
Unused.
NESTING_EVENT_ID
bigint(20) unsigned
The EVENT_ID value of the event within which this event is nested.
NESTING_EVENT_TYPE
enum('TRANSACTION',' STATEMENT', 'STAGE', 'WAIT')
The nesting event type.
EVENT_NAME
varchar(128)
NO
NULL
Event name.
COUNT_ALLOC
bigint(20) unsigned
NO
NULL
Total number of allocations to memory.
COUNT_FREE
bigint(20) unsigned
NO
NULL
Total number of attempts to free the allocated memory.
SUM_NUMBER_OF_BYTES_ALLOC
bigint(20) unsigned
NO
NULL
Total number of bytes allocated.
SUM_NUMBER_OF_BYTES_FREE
bigint(20) unsigned
NO
NULL
Total number of bytes freed
LOW_COUNT_USED
bigint(20)
NO
NULL
Lowest number of allocated blocks (lowest value of CURRENT_COUNT_USED).
CURRENT_COUNT_USED
bigint(20)
NO
NULL
Currently allocated blocks that have not been freed (COUNT_ALLOC minus COUNT_FREE).
HIGH_COUNT_USED
bigint(20)
NO
NULL
Highest number of allocated blocks (highest value of CURRENT_COUNT_USED).
LOW_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Lowest number of bytes used.
CURRENT_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Current number of bytes used (total allocated minus total freed).
HIGH_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Highest number of bytes used.
Ten most recent stage events per thread.
Ten thousand most recent stage events.
Summarized stage events per account and event name.
Summarized stage events per host and event name.
Summarized stage events per thread and event name.
Summarized stage events per user name and event name.
Summarized stage events per event name.
Current statement events.
Ten most recent events per thread.
Ten thousand most recent stage events.
Summarized statement events per account and event name.
Summarized statement events by scheme and digest.
Summarized statement events by host and event name.
Events for a particular stored program.
Summarized statement events by thread and event name.
Summarized statement events by user and event name.
Summarized statement events by event name.
Current transaction events for each thread.
Most recent completed transaction events for each thread.
Most recent completed transaction events that have ended globally.
Transaction events aggregated by account and event.
Transaction events aggregated by host and event..
Transaction events aggregated by thread and event..
Transaction events aggregated by user and event..
Transaction events aggregated by event name.
Current wait events.
Ten most recent wait events per thread.
Ten thousand most recent wait events per thread.
Summarized wait events by account and event name.
Summarized wait events by host and event name.
Summarized wait events by instance.
Summarized wait events by thread and event name.
Summarized wait events by user and event name.
Summarized wait events by event name.
Seen files.
File events summarized by event name.
File events summarized by instance.
Global status variables and values.
Host and IP information.
Connections by host.
Memory usage statistics aggregated by account and event.
Memory usage statistics aggregated by host. and event.
Memory usage statistics aggregated by thread and event..
Memory usage statistics aggregated by user and event..
Memory usage statistics aggregated by event.
Seen mutexes.
Object wait events.
Available event timers.
Aggregate statistics of prepared statements.
Configuration settings affecting replica transactions.
General transaction execution status on the replica.
Coordinator thread specific information.
Replica worker thread specific information.
Rreplica's configuration settings used for connecting to the primary.
Seen read-write locks.
Current session connection attributes.
All session connection attributes.
Session status variables and values.
Details on foreground thread monitoring.
Consumers for which event information is stored.
Instrumented objects for which events are collected.
Objects to be monitored.
Currently selected event timers.
Active connections.
Timer and byte count statistics by socket instrument.
Timer and byte count statistics by socket instance.
Status variable info by host/user account.
Status variable info by host.
Status variable info about active foreground threads.
Status variable info by user.
Table lock information.
Aggregate table I/O wait events by index.
Aggregate table I/O wait events by table.
Aggregate table lock wait events by table.
Server thread information.
User-defined variables by thread.
Connection statistics by user.
INDEX_NAME
Index name, or PRIMARY for the primary index, NULL for no index (inserts are counted in this case).
COUNT_STAR
Number of summarized events and the sum of the x_READ and x_WRITE columns.
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.
COUNT_READ
Number of all read operations, and the sum of the equivalent x_FETCH columns.
SUM_TIMER_READ
Total wait time of all read operations that are timed.
MIN_TIMER_READ
Minimum wait time of all read operations that are timed.
AVG_TIMER_READ
Average wait time of all read operations that are timed.
MAX_TIMER_READ
Maximum wait time of all read operations that are timed.
COUNT_WRITE
Number of all write operations, and the sum of the equivalent x_INSERT, x_UPDATE and x_DELETE columns.
SUM_TIMER_WRITE
Total wait time of all write operations that are timed.
MIN_TIMER_WRITE
Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE
Average wait time of all write operations that are timed.
MAX_TIMER_WRITE
Maximum wait time of all write operations that are timed.
COUNT_FETCH
Number of all fetch operations.
SUM_TIMER_FETCH
Total wait time of all fetch operations that are timed.
MIN_TIMER_FETCH
Minimum wait time of all fetch operations that are timed.
AVG_TIMER_FETCH
Average wait time of all fetch operations that are timed.
MAX_TIMER_FETCH
Maximum wait time of all fetch operations that are timed.
COUNT_INSERT
Number of all insert operations.
SUM_TIMER_INSERT
Total wait time of all insert operations that are timed.
MIN_TIMER_INSERT
Minimum wait time of all insert operations that are timed.
AVG_TIMER_INSERT
Average wait time of all insert operations that are timed.
MAX_TIMER_INSERT
Maximum wait time of all insert operations that are timed.
COUNT_UPDATE
Number of all update operations.
SUM_TIMER_UPDATE
Total wait time of all update operations that are timed.
MIN_TIMER_UPDATE
Minimum wait time of all update operations that are timed.
AVG_TIMER_UPDATE
Average wait time of all update operations that are timed.
MAX_TIMER_UPDATE
Maximum wait time of all update operations that are timed.
COUNT_DELETE
Number of all delete operations.
SUM_TIMER_DELETE
Total wait time of all delete operations that are timed.
MIN_TIMER_DELETE
Minimum wait time of all delete operations that are timed.
AVG_TIMER_DELETE
Average wait time of all delete operations that are timed.
MAX_TIMER_DELETE
Maximum wait time of all delete operations that are timed.
NO
Whether replication is using GTIDs or not.
SSL_ALLOWED
enum('YES', 'NO', 'IGNORED')
NO
Whether SSL is allowed for the replica connection.
SSL_CA_FILE
varchar(512)
NO
Path to the file that contains one or more certificates for trusted Certificate Authorities (CA) to use for TLS.
SSL_CA_PATH
varchar(512)
NO
Path to a directory that contains one or more PEM files that contain X509 certificates for a trusted Certificate Authority (CA) to use for TLS.
SSL_CERTIFICATE
varchar(512)
NO
Path to the certificate used to authenticate the master.
SSL_CIPHER
varchar(512)
NO
Which cipher is used for encription.
SSL_KEY
varchar(512)
NO
Path to the private key used for TLS.
SSL_VERIFY_SERVER_CERTIFICATE
enum('YES','NO')
NO
Whether the server certificate is verified as part of the SSL connection.
SSL_CRL_FILE
varchar(255)
NO
Path to the PEM file containing one or more revoked X.509 certificates.
SSL_CRL_PATH
varchar(255)
NO
PATH to a folder containing PEM files containing one or more revoked X.509 certificates.
CONNECTION_RETRY_INTERVAL
int(11)
NO
The number of seconds between connect retries.
CONNECTION_RETRY_COUNT
bigint(20) unsigned
NO
The number of times the replica can attempt to reconnect to the source in the event of a lost connection.
HEARTBEAT_INTERVAL
double(10,3) unsigned
NO
Number of seconds after which a heartbeat will be sent.
IGNORE_SERVER_IDS
longtext
NO
Binary log events from servers (ids) to ignore.
REPL_DO_DOMAIN_IDS
longtext
NO
Only apply binary logs from these domain ids.
REPL_IGNORE_DOMAIN_IDS
longtext
NO
Binary log events from domains to ignore.
CHANNEL_NAME
varchar(256)
NO
The replication channel used.
HOST
char(60)
NO
The host name of the source that the replica is connected to.
PORT
int(11)
NO
The port used to connect to the source.
USER
char(32)
NO
The user name of the replication user account used to connect to the source.
USING_GTID
enum('NO', 'CURRENT_POS', 'SLAVE_POS')
bigint(20) unsigned
NO
NULL
Total number of allocations to memory.
COUNT_FREE
bigint(20) unsigned
NO
NULL
Total number of attempts to free the allocated memory.
SUM_NUMBER_OF_BYTES_ALLOC
bigint(20) unsigned
NO
NULL
Total number of bytes allocated.
SUM_NUMBER_OF_BYTES_FREE
bigint(20) unsigned
NO
NULL
Total number of bytes freed
LOW_COUNT_USED
bigint(20)
NO
NULL
Lowest number of allocated blocks (lowest value of CURRENT_COUNT_USED).
CURRENT_COUNT_USED
bigint(20)
NO
NULL
Currently allocated blocks that have not been freed (COUNT_ALLOC minus COUNT_FREE).
HIGH_COUNT_USED
bigint(20)
NO
NULL
Highest number of allocated blocks (highest value of CURRENT_COUNT_USED).
LOW_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Lowest number of bytes used.
CURRENT_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Current number of bytes used (total allocated minus total freed).
HIGH_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Highest number of bytes used.
HOST
char(60)
YES
NULL
Host portion of the account.
EVENT_NAME
varchar(128)
NO
NULL
Event name.
COUNT_ALLOC
bigint(20) unsigned
NO
NULL
Total number of allocations to memory.
COUNT_FREE
bigint(20) unsigned
NO
NULL
Total number of attempts to free the allocated memory.
SUM_NUMBER_OF_BYTES_ALLOC
bigint(20) unsigned
NO
NULL
Total number of bytes allocated.
SUM_NUMBER_OF_BYTES_FREE
bigint(20) unsigned
NO
NULL
Total number of bytes freed
LOW_COUNT_USED
bigint(20)
NO
NULL
Lowest number of allocated blocks (lowest value of CURRENT_COUNT_USED).
CURRENT_COUNT_USED
bigint(20)
NO
NULL
Currently allocated blocks that have not been freed (COUNT_ALLOC minus COUNT_FREE).
HIGH_COUNT_USED
bigint(20)
NO
NULL
Highest number of allocated blocks (highest value of CURRENT_COUNT_USED).
LOW_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Lowest number of bytes used.
CURRENT_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Current number of bytes used (total allocated minus total freed).
HIGH_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Highest number of bytes used.
THREAD_ID
bigint(20) unsigned
NO
NULL
Thread id.
EVENT_NAME
varchar(128)
NO
NULL
Event name.
COUNT_ALLOC
bigint(20) unsigned
NO
NULL
Total number of allocations to memory.
COUNT_FREE
bigint(20) unsigned
NO
NULL
Total number of attempts to free the allocated memory.
SUM_NUMBER_OF_BYTES_ALLOC
bigint(20) unsigned
NO
NULL
Total number of bytes allocated.
SUM_NUMBER_OF_BYTES_FREE
bigint(20) unsigned
NO
NULL
Total number of bytes freed
LOW_COUNT_USED
bigint(20)
NO
NULL
Lowest number of allocated blocks (lowest value of CURRENT_COUNT_USED).
CURRENT_COUNT_USED
bigint(20)
NO
NULL
Currently allocated blocks that have not been freed (COUNT_ALLOC minus COUNT_FREE).
HIGH_COUNT_USED
bigint(20)
NO
NULL
Highest number of allocated blocks (highest value of CURRENT_COUNT_USED).
LOW_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Lowest number of bytes used.
CURRENT_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Current number of bytes used (total allocated minus total freed).
HIGH_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Highest number of bytes used.
USER
char(32)
YES
NULL
User portion of the account.
EVENT_NAME
varchar(128)
NO
NULL
Event name.
COUNT_ALLOC
Number of summarized events and the sum of the x_READ and x_WRITE columns.
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.
COUNT_READ
Number of all read operations, and the sum of the equivalent x_FETCH columns.
SUM_TIMER_READ
Total wait time of all read operations that are timed.
MIN_TIMER_READ
Minimum wait time of all read operations that are timed.
AVG_TIMER_READ
Average wait time of all read operations that are timed.
MAX_TIMER_READ
Maximum wait time of all read operations that are timed.
COUNT_WRITE
Number of all write operations, and the sum of the equivalent x_INSERT, x_UPDATE and x_DELETE columns.
SUM_TIMER_WRITE
Total wait time of all write operations that are timed.
MIN_TIMER_WRITE
Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE
Average wait time of all write operations that are timed.
MAX_TIMER_WRITE
Maximum wait time of all write operations that are timed.
COUNT_FETCH
Number of all fetch operations.
SUM_TIMER_FETCH
Total wait time of all fetch operations that are timed.
MIN_TIMER_FETCH
Minimum wait time of all fetch operations that are timed.
AVG_TIMER_FETCH
Average wait time of all fetch operations that are timed.
MAX_TIMER_FETCH
Maximum wait time of all fetch operations that are timed.
COUNT_INSERT
Number of all insert operations.
SUM_TIMER_INSERT
Total wait time of all insert operations that are timed.
MIN_TIMER_INSERT
Minimum wait time of all insert operations that are timed.
AVG_TIMER_INSERT
Average wait time of all insert operations that are timed.
MAX_TIMER_INSERT
Maximum wait time of all insert operations that are timed.
COUNT_UPDATE
Number of all update operations.
SUM_TIMER_UPDATE
Total wait time of all update operations that are timed.
MIN_TIMER_UPDATE
Minimum wait time of all update operations that are timed.
AVG_TIMER_UPDATE
Average wait time of all update operations that are timed.
MAX_TIMER_UPDATE
Maximum wait time of all update operations that are timed.
COUNT_DELETE
Number of all delete operations.
SUM_TIMER_DELETE
Total wait time of all delete operations that are timed.
MIN_TIMER_DELETE
Minimum wait time of all delete operations that are timed.
AVG_TIMER_DELETE
Average wait time of all delete operations that are timed.
MAX_TIMER_DELETE
Maximum wait time of all delete operations that are timed.
You can TRUNCATE the table, which will reset all counters to zero. Truncating this table will also truncate the table_io_waits_summary_by_index_usage table.
This page is licensed: CC BY-SA / Gnu FDL
OBJECT_TYPE
Since this table records waits by table, always set to TABLE.
OBJECT_SCHEMA
Schema name.
OBJECT_NAME
Table name.
COUNT_STAR
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.
SUM_LOCK_TIME
Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS
Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS
Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED
Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT
Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED
Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES
Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES
Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN
Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN
Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE
Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK
Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN
Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES
Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE
Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS
Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN
Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED
Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED
Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.
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.
SUM_LOCK_TIME
Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS
Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS
Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED
Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT
Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED
Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES
Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES
Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN
Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN
Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE
Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK
Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN
Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES
Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE
Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS
Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN
Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED
Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED
Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.
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.
COUNT_READ
Number of all read operations, including FGETS, FGETC, FREAD, and READ.
SUM_TIMER_READ
Total wait time of all read operations that are timed.
MIN_TIMER_READ
Minimum wait time of all read operations that are timed.
AVG_TIMER_READ
Average wait time of all read operations that are timed.
MAX_TIMER_READ
Maximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READ
Bytes read by read operations.
COUNT_WRITE
Number of all write operations, including FPUTS, FPUTC, FPRINTF, VFPRINTF, FWRITE, and PWRITE.
SUM_TIMER_WRITE
Total wait time of all write operations that are timed.
MIN_TIMER_WRITE
Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE
Average wait time of all write operations that are timed.
MAX_TIMER_WRITE
Maximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITE
Bytes written by write operations.
COUNT_MISC
Number of all miscellaneous operations not counted above, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
SUM_TIMER_MISC
Total wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISC
Minimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISC
Average wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISC
Maximum wait time of all miscellaneous operations that are timed.
+----------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------------+------+-----+---------+-------+
| EVENT_NAME | varchar(128) | NO | | NULL | |
| COUNT_STAR | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| COUNT_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| COUNT_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
+----------------------+---------------------+------+-----+---------+-------+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.
SUM_LOCK_TIME
Sum of the LOCK_TIME column in the events_statements_currentd table.
SUM_ERRORS
Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS
Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED
Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT
Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED
Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES
Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES
Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN
Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN
Sum of the SELECT_FULL_RANGE_JOINW column in the events_statements_current table.
SUM_SELECT_RANGE
Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK
Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN
Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES
Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE
Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS
Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN
Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED
Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED
Sum 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.
This page is licensed: CC BY-SA / Gnu FDL
HOST
Host. Used together with EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with HOST for grouping events.
COUNT_STAR
Number of summarized events
SUM_TIMER_WAIT
Total wait time of the summarized events that are timed.
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.
SUM_LOCK_TIME
Sum of the LOCK_TIME column in the events_statements_current table.
SUM_ERRORS
Sum of the ERRORS column in the events_statements_current table.
SUM_WARNINGS
Sum of the WARNINGS column in the events_statements_current table.
SUM_ROWS_AFFECTED
Sum of the ROWS_AFFECTED column in the events_statements_current table.
SUM_ROWS_SENT
Sum of the ROWS_SENT column in the events_statements_current table.
SUM_ROWS_EXAMINED
Sum of the ROWS_EXAMINED column in the events_statements_current table.
SUM_CREATED_TMP_DISK_TABLES
Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
SUM_CREATED_TMP_TABLES
Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
SUM_SELECT_FULL_JOIN
Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
SUM_SELECT_FULL_RANGE_JOIN
Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
SUM_SELECT_RANGE
Sum of the SELECT_RANGE column in the events_statements_current table.
SUM_SELECT_RANGE_CHECK
Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
SUM_SELECT_SCAN
Sum of the SELECT_SCAN column in the events_statements_current table.
SUM_SORT_MERGE_PASSES
Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
SUM_SORT_RANGE
Sum of the SORT_RANGE column in the events_statements_current table.
SUM_SORT_ROWS
Sum of the SORT_ROWS column in the events_statements_current table.
SUM_SORT_SCAN
Sum of the SORT_SCAN column in the events_statements_current table.
SUM_NO_INDEX_USED
Sum of the NO_INDEX_USED column in the events_statements_current table.
SUM_NO_GOOD_INDEX_USED
Sum 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.
This page is licensed: CC BY-SA / Gnu FDL
USER
User. Used together with HOST and EVENT_NAME for grouping events.
HOST
Host. Used together with USER and EVENT_NAME for grouping events.
EVENT_NAME
Event name. Used together with USER and HOST for grouping events.
COUNT_STAR
Number of summarized events
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.
COUNT_READ
Number of all read operations, including RECV, RECVFROM, and RECVMSG.
SUM_TIMER_READ
Total wait time of all read operations that are timed.
MIN_TIMER_READ
Minimum wait time of all read operations that are timed.
AVG_TIMER_READ
Average wait time of all read operations that are timed.
MAX_TIMER_READ
Maximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READ
Bytes read by read operations.
COUNT_WRITE
Number of all write operations, including SEND, SENDTO, and SENDMSG.
SUM_TIMER_WRITE
Total wait time of all write operations that are timed.
MIN_TIMER_WRITE
Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE
Average wait time of all write operations that are timed.
MAX_TIMER_WRITE
Maximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITE
Bytes written by write operations.
COUNT_MISC
Number of all miscellaneous operations not counted above, including CONNECT, LISTEN, ACCEPT, CLOSE, and SHUTDOWN.
SUM_TIMER_MISC
Total wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISC
Minimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISC
Average wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISC
Maximum wait time of all miscellaneous operations that are timed.
You can TRUNCATE the table, which will reset all counters to zero.
This page is licensed: CC BY-SA / Gnu FDL
EVENT_NAME
Socket instrument.
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.
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: 0SELECT * 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: 0SELECT * FROM file_summary_by_event_name\G
...
*************************** 49. row ***************************
EVENT_NAME: wait/io/file/aria/MAD
COUNT_STAR: 60
SUM_TIMER_WAIT: 397234368
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 6620224
MAX_TIMER_WAIT: 16808672
COUNT_READ: 0
SUM_TIMER_READ: 0
MIN_TIMER_READ: 0
AVG_TIMER_READ: 0
MAX_TIMER_READ: 0
SUM_NUMBER_OF_BYTES_READ: 0
COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
SUM_NUMBER_OF_BYTES_WRITE: 0
COUNT_MISC: 60
SUM_TIMER_MISC: 397234368
MIN_TIMER_MISC: 0
AVG_TIMER_MISC: 6620224
MAX_TIMER_MISC: 16808672
*************************** 50. row ***************************
EVENT_NAME: wait/io/file/aria/control
COUNT_STAR: 3
SUM_TIMER_WAIT: 24055778544
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 8018592848
MAX_TIMER_WAIT: 24027262400
COUNT_READ: 1
SUM_TIMER_READ: 24027262400
MIN_TIMER_READ: 0
AVG_TIMER_READ: 24027262400
MAX_TIMER_READ: 24027262400
SUM_NUMBER_OF_BYTES_READ: 52
COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
SUM_NUMBER_OF_BYTES_WRITE: 0
COUNT_MISC: 2
SUM_TIMER_MISC: 28516144
MIN_TIMER_MISC: 0
AVG_TIMER_MISC: 14258072
MAX_TIMER_MISC: 27262208SELECT * FROM events_statements_summary_by_host_by_event_name\G
...
*************************** 347. row ***************************
HOST: 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
*************************** 348. row ***************************
HOST: 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: 0SELECT * FROM events_statements_summary_by_account_by_event_name\G
...
*************************** 521. row ***************************
USER: NULL
HOST: 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
HOST: 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: 0SELECT * FROM socket_summary_by_event_name\G
*************************** 1. row ***************************
EVENT_NAME: wait/io/socket/sql/server_tcpip_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
COUNT_READ: 0
SUM_TIMER_READ: 0
MIN_TIMER_READ: 0
AVG_TIMER_READ: 0
MAX_TIMER_READ: 0
SUM_NUMBER_OF_BYTES_READ: 0
COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
SUM_NUMBER_OF_BYTES_WRITE: 0
COUNT_MISC: 0
SUM_TIMER_MISC: 0
MIN_TIMER_MISC: 0
AVG_TIMER_MISC: 0
MAX_TIMER_MISC: 0
*************************** 2. row ***************************
EVENT_NAME: wait/io/socket/sql/server_unix_socket
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
COUNT_READ: 0
SUM_TIMER_READ: 0
MIN_TIMER_READ: 0
AVG_TIMER_READ: 0
MAX_TIMER_READ: 0
SUM_NUMBER_OF_BYTES_READ: 0
COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
SUM_NUMBER_OF_BYTES_WRITE: 0
COUNT_MISC: 0
SUM_TIMER_MISC: 0
MIN_TIMER_MISC: 0
AVG_TIMER_MISC: 0
MAX_TIMER_MISC: 0
...STATE
enum('ACTIVE', 'COMMITTED',' ROLLED BACK')
The current transaction state. The value is ACTIVE (after START TRANSACTION or BEGIN), COMMITTED (after COMMIT), or ROLLED BACK (after ROLLBACK).
TRX_ID
bigint(20) unsigned
Unused.
GTID
varchar(64)
Transaction , using the format DOMAIN-SERVER_ID-SEQUENCE_NO.
XID_FORMAT_ID
int(11)
XA transaction format ID for GTRID and BQUAL values.
XID_GTRID
varchar(130)
XA global transaction ID.
XID_BQUAL
varchar(130)
XA transaction branch qualifier.
XA_STATE
varchar(64)
The state of the XA transaction. The value is ACTIVE (after XA START), IDLE (after XA END), PREPARED (after XA PREPARE), ROLLED BACK (after XA ROLLBACK), or COMMITTED (after XA COMMIT).
SOURCE
varchar(64)
The name of the source file containing the instrumented code that produced the event and the line number in the file at which the instrumentation occurs.
TIMER_START
bigint(20) unsigned
The unit is picoseconds. When event timing started. NULL if event has no timing information.
TIMER_END
bigint(20) unsigned
The unit is picoseconds. When event timing ended. NULL if event has no timing information.
TIMER_WAIT
bigint(20) unsigned
The unit is picoseconds. Event duration. NULL if event has not timing information.
ACCESS_MODE
enum('READ ONLY', 'READ WRITE')
Transaction access mode.
ISOLATION_LEVEL
varchar(64)
Transaction isolation level. One of: REPEATABLE READ, READ COMMITTED, READ UNCOMMITTED, or SERIALIZABLE.
AUTOCOMMIT
enum('YES', 'NO')
NO
NUMBER_OF_SAVEPOINTS
bigint(20) unsigned
The number of SAVEPOINT statements issued during the transaction.
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
bigint(20) unsigned
The number of ROLLBACK_TO_SAVEPOINT statements issued during the transaction.
NUMBER_OF_RELEASE_SAVEPOINT
bigint(20) unsigned
The number of RELEASE_SAVEPOINT statements issued during the transaction.
OBJECT_INSTANCE_BEGIN
bigint(20) unsigned
Unused.
NESTING_EVENT_ID
bigint(20) unsigned
The EVENT_ID value of the event within which this event is nested.
NESTING_EVENT_TYPE
enum('TRANSACTION',' STATEMENT', 'STAGE', 'WAIT')
The nesting event type.
THREAD_ID
bigint(20) unsigned
The thread associated with the event.
EVENT_ID
bigint(20) unsigned
The event id associated with the event.
END_EVENT_ID
bigint(20) unsigned
This column is set to NULL when the event starts and updated to the thread current event number when the event ends.
EVENT_NAME
varchar(128)
The name of the instrument from which the event was collected. This is a NAME value from the setup_instruments table.
END_EVENT_ID
NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if timing is not collected.
LOCK_TIME
Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
SQL_TEXT
The SQL statement, or NULL if the command is not associated with an SQL statement.
DIGEST
.
DIGEST_TEXT
text.
CURRENT_SCHEMA
Statement's default database for the statement, or NULL if there was none.
OBJECT_SCHEMA
Reserved, currently NULL
OBJECT_NAME
Reserved, currently NULL
OBJECT_TYPE
Reserved, currently NULL
OBJECT_INSTANCE_BEGIN
Address in memory of the statement object.
MYSQL_ERRNO
Error code. See for a full list.
RETURNED_SQLSTATE
The value.
MESSAGE_TEXT
Statement error message. See .
ERRORS
0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
WARNINGS
Number of warnings from the diagnostics area.
ROWS_AFFECTED
Number of rows affected the statement affected.
ROWS_SENT
Number of rows returned.
ROWS_EXAMINED
Number of rows read during the statement's execution.
CREATED_TMP_DISK_TABLES
Number of on-disk temp tables created by the statement.
CREATED_TMP_TABLES
Number of temp tables created by the statement.
SELECT_FULL_JOIN
Number of joins performed by the statement which did not use an index.
SELECT_FULL_RANGE_JOIN
Number of joins performed by the statement which used a range search of the first table.
SELECT_RANGE
Number of joins performed by the statement which used a range of the first table.
SELECT_RANGE_CHECK
Number of joins without keys performed by the statement that check for key usage after each row.
SELECT_SCAN
Number of joins performed by the statement which used a full scan of the first table.
SORT_MERGE_PASSES
Number of merge passes by the sort algorithm performed by the statement. If too high, you may need to increase the .
SORT_RANGE
Number of sorts performed by the statement which used a range.
SORT_ROWS
Number of rows sorted by the statement.
SORT_SCAN
Number of sorts performed by the statement which used a full table scan.
NO_INDEX_USED
0 if the statement performed a table scan with an index, 1 if without an index.
NO_GOOD_INDEX_USED
0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the article.
NESTING_EVENT_ID
Reserved, currently NULL.
NESTING_EVENT_TYPE
Reserved, currently NULL.
It is possible to empty this table with a TRUNCATE TABLE statement.
events_statements_current and events_statements_history_long are related tables.
This page is licensed: CC BY-SA / Gnu FDL
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
NULL when the event starts, set to the thread's current event number at the end of the event.
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if timing is not collected.
LOCK_TIME
Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
SQL_TEXT
The SQL statement, or NULL if the command is not associated with an SQL statement.
DIGEST
.
DIGEST_TEXT
text.
CURRENT_SCHEMA
Statement's default database for the statement, or NULL if there was none.
OBJECT_SCHEMA
Reserved, currently NULL
OBJECT_NAME
Reserved, currently NULL
OBJECT_TYPE
Reserved, currently NULL
OBJECT_INSTANCE_BEGIN
Address in memory of the statement object.
MYSQL_ERRNO
Error code. See for a full list.
RETURNED_SQLSTATE
The value.
MESSAGE_TEXT
Statement error message. See .
ERRORS
0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
WARNINGS
Number of warnings from the diagnostics area.
ROWS_AFFECTED
Number of rows affected the statement affected.
ROWS_SENT
Number of rows returned.
ROWS_EXAMINED
Number of rows read during the statement's execution.
CREATED_TMP_DISK_TABLES
Number of on-disk temp tables created by the statement.
CREATED_TMP_TABLES
Number of temp tables created by the statement.
SELECT_FULL_JOIN
Number of joins performed by the statement which did not use an index.
SELECT_FULL_RANGE_JOIN
Number of joins performed by the statement which used a range search of the first table.
SELECT_RANGE
Number of joins performed by the statement which used a range of the first table.
SELECT_RANGE_CHECK
Number of joins without keys performed by the statement that check for key usage after each row.
SELECT_SCAN
Number of joins performed by the statement which used a full scan of the first table.
SORT_MERGE_PASSES
Number of merge passes by the sort algorithm performed by the statement. If too high, you may need to increase the .
SORT_RANGE
Number of sorts performed by the statement which used a range.
SORT_ROWS
Number of rows sorted by the statement.
SORT_SCAN
Number of sorts performed by the statement which used a full table scan.
NO_INDEX_USED
0 if the statement performed a table scan with an index, 1 if without an index.
NO_GOOD_INDEX_USED
0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the article.
NESTING_EVENT_ID
Reserved, currently NULL.
NESTING_EVENT_TYPE
Reserved, currently NULL.
It is possible to empty this table with a TRUNCATE TABLE statement.
events_statements_current and events_statements_history are related tables.
This page is licensed: CC BY-SA / Gnu FDL
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID
memory_summary_global_by_event_name
The memory_summary_global_by_event_name table contains memory usage statistics aggregated by event and event.
The table contains the following columns:
EVENT_NAME
varchar(128)
NO
NULL
Event name.
COUNT_ALLOC
bigint(20) unsigned
NO
NULL
Total number of allocations to memory.
Seeing what memory was most often allocated for:
This page is licensed: CC BY-SA / Gnu FDL
session_connect_attrs contains the following columns:
PROCESSLIST_ID
Session connection identifier.
ATTR_NAME
Attribute name.
ATTR_VALUE
Attribute value.
ORDINAL_POSITION
Order in which attribute was added to the connection attributes.
Returning the current connection's attributes:
Connection attributes values are set using the option .
Example using connection string jdbc:mariadb://localhost/?connectionAttributes=test:test1,test2:test2Val,test3 :
Connection attributes values are set using the option .
Example using connection
Connection attributes values are set using the option .
Example using connection string jdbc:mariadb://localhost/?connectionAttributes=test:test1,test2:test2Val,test3
This page is licensed: CC BY-SA / Gnu FDL
This table provides summary statistics for statements executed within stored programs, such as procedures, functions, triggers, and events.
Each row in the Performance Schema events_statements_summary_by_program table summarizes events for a particular stored program (stored procedure, stored function, trigger or event).
It contains the following fields.
This page is licensed: CC BY-SA / Gnu FDL
The threads table lists all instrumented threads, mapping internal thread IDs to process IDs and providing execution status for every thread.
Each server thread is represented as a row in the threads table.
The threads table contains the following columns:
THREAD_ID
A unique thread identifier.
NAME
Name associated with the server's thread instrumentation code, for example thread/sql/main for the server's main() function, and thread/sql/one_connection for a user connection.
This page is licensed: CC BY-SA / Gnu FDL
The hosts table contains aggregated connection statistics for each client host, including counts for current and total historical connections.
The hosts table contains a row for each host used by clients to connect to the server, containing current and total connections.
The size is determined by the performance_schema_hosts_size system variable, which, if set to zero, will disable connection statistics in the hosts table.
It contains the following columns:
This page is licensed: CC BY-SA / Gnu FDL
The events_statements_current table displays the current statement event for each thread, including SQL text, timer stats, and error codes.
The events_statements_current table contains current statement events, with each row being a record of a thread and its most recent statement event.
The table contains the following columns:
SELECT * FROM memory_summary_global_by_event_name
ORDER BY count_alloc DESC LIMIT 1\G
*************************** 1. row ***************************
EVENT_NAME: memory/sql/QUICK_RANGE_SELECT::alloc
COUNT_ALLOC: 147976
COUNT_FREE: 147976
SUM_NUMBER_OF_BYTES_ALLOC: 600190656
SUM_NUMBER_OF_BYTES_FREE: 600190656
LOW_COUNT_USED: 0
CURRENT_COUNT_USED: 0
HIGH_COUNT_USED: 68
LOW_NUMBER_OF_BYTES_USED: 0
CURRENT_NUMBER_OF_BYTES_USED: 0
HIGH_NUMBER_OF_BYTES_USED: 275808SELECT * FROM performance_schema.session_connect_attrs WHERE processlist_id=CONNECTION_ID();
+----------------+-----------------+------------------+------------------+
| PROCESSLIST_ID | ATTR_NAME | ATTR_VALUE | ORDINAL_POSITION |
+----------------+-----------------+------------------+------------------+
| 45 | _os | debian-linux-gnu | 0 |
| 45 | _client_name | libmysql | 1 |
| 45 | _pid | 7711 | 2 |
| 45 | _client_version | 10.0.5 | 3 |
| 45 | _platform | x86_64 | 4 |
| 45 | program_name | mysql | 5 |
+----------------+-----------------+------------------+------------------+SELECT * FROM performance_schema.session_connect_attrs WHERE processlist_id=17;
+----------------+-----------------+---------------------+------------------+
| PROCESSLIST_ID | ATTR_NAME | ATTR_VALUE | ORDINAL_POSITION |
+----------------+-----------------+---------------------+------------------+
| 17 | _client_name | MariaDB Connector/J | 0 |
| 17 | _client_version | 3.1.3 | 1 |
| 17 | _server_host | localhost | 2 |
| 17 | _os | Windows 11 | 3 |
| 17 | _thread | 1 | 4 |
| 17 | _java_vendor | Oracle Corporation | 5 |
| 17 | _java_version | 19.0.2 | 6 |
| 17 | test | test1 | 7 |
| 17 | test2 | test2Val | 8 |
| 17 | test3 | NULL | 9 |
+----------------+-----------------+---------------------+------------------+const conn = await mariadb.createConnection({
host: 'localhost',
user: 'root',
connectAttributes: { test: 'test1', test2: 'test2Val', test3: 'f' }
});SELECT * FROM performance_schema.session_connect_attrs WHERE processlist_id=30;
+----------------+-----------------+------------------------+------------------+
| PROCESSLIST_ID | ATTR_NAME | ATTR_VALUE | ORDINAL_POSITION |
+----------------+-----------------+------------------------+------------------+
| 30 | _client_name | MariaDB connector/Node | 0 |
| 30 | _client_version | 3.1.1 | 1 |
| 30 | _server_host | ::1 | 2 |
| 30 | _os | win32 | 3 |
| 30 | _client_host | NOSTROMO | 4 |
| 30 | _node_version | 18.15.0 | 5 |
| 30 | test | test1 | 6 |
| 30 | test2 | test2Val | 7 |
| 30 | test3 | f | 8 |
+----------------+-----------------+------------------------+------------------+TreeMap<String, String> connectionAttributes = new TreeMap<>();
connectionAttributes.put("entry1", "val1");
connectionAttributes.put("entry2", "val2");
MariadbConnectionConfiguration conf = MariadbConnectionConfiguration.builder()
.host("localhost")
.port(3306)
.username("root")
.connectionAttributes(connectionAttributes)
.database("test")
.build();
MariadbConnectionFactory connFactory = new MariadbConnectionFactory(conf);
MariadbConnection connection = connFactory.create().block();SELECT * FROM performance_schema.session_connect_attrs WHERE processlist_id=34;
+----------------+-----------------+--------------------+------------------+
| PROCESSLIST_ID | ATTR_NAME | ATTR_VALUE | ORDINAL_POSITION |
+----------------+-----------------+--------------------+------------------+
| 34 | _client_name | mariadb | 0 |
| 34 | _client_version | 1.1.4 | 1 |
| 34 | _server_host | localhost | 2 |
| 34 | _os | Windows 11 | 3 |
| 34 | _thread | 49 | 4 |
| 34 | _java_vendor | Oracle Corporation | 5 |
| 34 | _java_version | 19.0.2 | 6 |
| 34 | entry1 | val1 | 7 |
| 34 | entry2 | val2 | 8 |
+----------------+-----------------+--------------------+------------------+COUNT_FREE
bigint(20) unsigned
NO
NULL
Total number of attempts to free the allocated memory.
SUM_NUMBER_OF_BYTES_ALLOC
bigint(20) unsigned
NO
NULL
Total number of bytes allocated.
SUM_NUMBER_OF_BYTES_FREE
bigint(20) unsigned
NO
NULL
Total number of bytes freed
LOW_COUNT_USED
bigint(20)
NO
NULL
Lowest number of allocated blocks (lowest value of CURRENT_COUNT_USED).
CURRENT_COUNT_USED
bigint(20)
NO
NULL
Currently allocated blocks that have not been freed (COUNT_ALLOC minus COUNT_FREE).
HIGH_COUNT_USED
bigint(20)
NO
NULL
Highest number of allocated blocks (highest value of CURRENT_COUNT_USED).
LOW_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Lowest number of bytes used.
CURRENT_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Current number of bytes used (total allocated minus total freed).
HIGH_NUMBER_OF_BYTES_USED
bigint(20)
NO
NULL
Highest number of bytes used.
HOST
Host name used by the client to connect, NULL for internal threads or user sessions that failed to authenticate.
CURRENT_CONNECTIONS
Current number of the host's connections.
TOTAL_CONNECTIONS
Total number of the host's connections
SELECT * FROM hosts;
+-----------+---------------------+-------------------+
| HOST | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+-----------+---------------------+-------------------+
| localhost | 1 | 45 |
| NULL | 20 | 23 |
+-----------+---------------------+-------------------+This table summarizes stage events aggregated by thread and event name, providing granular statistics on thread execution stages.
The events_transactions_summary_by_thread_by_event_name table contains information on transaction events aggregated by thread and event name.
The table contains the following columns:
+----------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------------+------+-----+---------+-------+
| THREAD_ID | bigint(20) unsigned | NO | | NULL | |
| EVENT_NAME | varchar(128) | NO | | NULL | |
| COUNT_STAR | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | |
| COUNT_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_READ_WRITE | bigint(20) unsigned | NO | | NULL | |
| COUNT_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| SUM_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| MIN_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| AVG_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
| MAX_TIMER_READ_ONLY | bigint(20) unsigned | NO | | NULL | |
+----------------------+---------------------+------+-----+---------+-------+This page is licensed: CC BY-SA / Gnu FDL
NO
The number of summarized events (from events_statements_current). This value includes all events, whether timed or nontimed.
MIN_TIMER_WAIT
bigint(20) unsigned
NO
The minimum wait time of the summarized timed events.
AVG_TIMER_WAIT
bigint(20) unsigned
NO
The average wait time of the summarized timed events.
MAX_TIMER_WAIT
bigint(20) unsigned
NO
The maximum wait time of the summarized timed events.
COUNT_STATEMENTS
bigint(20) unsigned
NO
Total number of nested statements invoked during stored program execution.
SUM_STATEMENTS_WAIT
bigint(20) unsigned
NO
The total wait time of the summarized timed statements. This value is calculated only for timed statements because nontimed statements have a wait time of NULL. The same is true for the other xxx_STATEMENT_WAIT values.
MIN_STATEMENTS_WAIT
bigint(20) unsigned
NO
The minimum wait time of the summarized timed statements.
AVG_STATEMENTS_WAIT
bigint(20) unsigned
NO
The average wait time of the summarized timed statements.
MAX_STATEMENTS_WAIT
bigint(20) unsigned
NO
The maximum wait time of the summarized timed statements.
SUM_LOCK_TIME
bigint(20) unsigned
NO
The total time spent (in picoseconds) waiting for table locks for the summarized statements.
SUM_ERRORS
bigint(20) unsigned
NO
The total number of errors that occurend for the summarized statements.
SUM_WARNINGS
bigint(20) unsigned
NO
The total number of warnings that occurend for the summarized statements.
SUM_ROWS_AFFECTED
bigint(20) unsigned
NO
The total number of affected rows by the summarized statements.
SUM_ROWS_SENT
bigint(20) unsigned
NO
The total number of rows returned by the summarized statements.
SUM_ROWS_EXAMINED
bigint(20) unsigned
NO
The total number of rows examined by the summarized statements.The total number of affected rows by the summarized statements.
SUM_CREATED_TMP_DISK_TABLES
bigint(20) unsigned
NO
The total number of on-disk temporary tables created by the summarized statements.
SUM_CREATED_TMP_TABLES
bigint(20) unsigned
NO
The total number of in-memory temporary tables created by the summarized statements.
SUM_SELECT_FULL_JOIN
bigint(20) unsigned
NO
The total number of full joins executed by the summarized statements.
SUM_SELECT_FULL_RANGE_JOIN
bigint(20) unsigned
NO
The total number of range search joins executed by the summarized statements.
SUM_SELECT_RANGE
bigint(20) unsigned
NO
The total number of joins that used ranges on the first table executed by the summarized statements.
SUM_SELECT_RANGE_CHECK
bigint(20) unsigned
NO
The total number of joins that check for key usage after each row executed by the summarized statements.
SUM_SELECT_SCAN
bigint(20) unsigned
NO
The total number of joins that did a full scan of the first table executed by the summarized statements.
SUM_SORT_MERGE_PASSES
bigint(20) unsigned
NO
The total number of merge passes that the sort algorithm has had to do for the summarized statements.
SUM_SORT_RANGE
bigint(20) unsigned
NO
The total number of sorts that were done using ranges for the summarized statements.
SUM_SORT_ROWS
bigint(20) unsigned
NO
The total number of sorted rows that were sorted by the summarized statements.
SUM_SORT_SCAN
bigint(20) unsigned
NO
The total number of sorts that were done by scanning the table by the summarized statements.
SUM_NO_INDEX_USED
bigint(20) unsigned
NO
The total number of statements that performed a table scan without using an index.
SUM_NO_GOOD_INDEX_USED
bigint(20) unsigned
NO
The total number of statements where no good index was found.
OBJECT_TYPE
enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER')
YES
Object type for which the summary is generated.
OBJECT_SCHEMA
varchar(64)
NO
The schema of the object for which the summary is generated.
OBJECT_NAME
varchar(64)
NO
The name of the object for which the summary is generated.
COUNT_STAR
bigint(20) unsigned
NO
The number of summarized events (from events_statements_current). This value includes all events, whether timed or nontimed.
SUM_TIMER_WAIT
bigint(20) unsigned
EVENT_NAME
Event instrument name and a NAME from the setup_instruments table
SOURCE
Name and line number of the source file containing the instrumented code that produced the event.
TIMER_START
Value in picoseconds when the event timing started or NULL if timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_END
Value in picoseconds when the event timing ended, or NULL if the event has not ended or timing is not collected. Relative to the server start, not to the epoch, so cannot directly be converted to a timestamp.
TIMER_WAIT
Value in picoseconds of the event's duration or NULL if the event has not ended or timing is not collected.
LOCK_TIME
Time in picoseconds spent waiting for locks. The time is calculated in microseconds but stored in picoseconds for compatibility with other timings.
SQL_TEXT
The SQL statement, or NULL if the command is not associated with an SQL statement.
DIGEST
.
DIGEST_TEXT
text.
CURRENT_SCHEMA
Statement's default database for the statement, or NULL if there was none.
OBJECT_SCHEMA
Reserved, currently NULL
OBJECT_NAME
Reserved, currently NULL
OBJECT_TYPE
Reserved, currently NULL
OBJECT_INSTANCE_BEGIN
Address in memory of the statement object.
MYSQL_ERRNO
Error code. See for a full list.
RETURNED_SQLSTATE
The value.
MESSAGE_TEXT
Statement error message. See .
ERRORS
0 if SQLSTATE signifies completion (starting with 00) or warning (01), otherwise 1.
WARNINGS
Number of warnings from the diagnostics area.
ROWS_AFFECTED
Number of rows affected the statement affected.
ROWS_SENT
Number of rows returned.
ROWS_EXAMINED
Number of rows read during the statement's execution.
CREATED_TMP_DISK_TABLES
Number of on-disk temp tables created by the statement.
CREATED_TMP_TABLES
Number of temp tables created by the statement.
SELECT_FULL_JOIN
Number of joins performed by the statement which did not use an index.
SELECT_FULL_RANGE_JOIN
Number of joins performed by the statement which used a range search of the first table.
SELECT_RANGE
Number of joins performed by the statement which used a range of the first table.
SELECT_RANGE_CHECK
Number of joins without keys performed by the statement that check for key usage after each row.
SELECT_SCAN
Number of joins performed by the statement which used a full scan of the first table.
SORT_MERGE_PASSES
Number of merges passes by the sort algorithm performed by the statement. If too high, you may need to increase the .
SORT_RANGE
Number of sorts performed by the statement which used a range.
SORT_ROWS
Number of rows sorted by the statement.
SORT_SCAN
Number of sorts performed by the statement which used a full table scan.
NO_INDEX_USED
0 if the statement performed a table scan with an index, 1 if without an index.
NO_GOOD_INDEX_USED
0 if a good index was found for the statement, 1 if no good index was found. See the Range checked for each record description in the article.
NESTING_EVENT_ID
Reserved, currently NULL.
NESTING_EVENT_TYPE
Reserved, currently NULL.
It is possible to empty this table with a TRUNCATE TABLE statement.
The related tables, events_statements_history and events_statements_history_long derive their values from the current events table.
This page is licensed: CC BY-SA / Gnu FDL
THREAD_ID
Thread associated with the event. Together with EVENT_ID uniquely identifies the row.
EVENT_ID
Thread's current event number at the start of the event. Together with THREAD_ID uniquely identifies the row.
END_EVENT_ID
NULL when the event starts, set to the thread's current event number at the end of the event.
TYPE
FOREGROUND or BACKGROUND, depending on the thread type. User connection threads are FOREGROUND, internal server threads are BACKGROUND.
PROCESSLIST_ID
The PROCESSLIST.ID value for threads displayed in the INFORMATION_SCHEMA.PROCESSLIST table, or 0 for background threads. Also corresponds with the CONNECTION_ID() return value for the thread.
PROCESSLIST_USER
Foreground thread user, or NULL for a background thread.
PROCESSLIST_HOST
Foreground thread host, or NULL for a background thread.
PROCESSLIST_DB
Thread's default database, or NULL if none exists.
PROCESSLIST_COMMAND
Type of command executed by the thread. These correspond to the COM_xxx client/server protocol commands, and the Com_xxx status variables. See Thread Command Values.
PROCESSLIST_TIME
Time in seconds the thread has been in its current state.
PROCESSLIST_STATE
Action, event or state indicating what the thread is doing.
PROCESSLIST_INFO
Statement being executed by the thread, or NULL if a statement is not being executed. If a statement results in calling other statements, such as for a stored procedure, the innermost statement from the stored procedure is shown here.
PARENT_THREAD_ID
THREAD_ID of the parent thread, if any. Subthreads can for example be spawned as a result of INSERT DELAYED statements.
ROLE
Unused.
INSTRUMENTED
YES or NO for Whether the thread is instrumented or not. For foreground threads, the initial value is determined by whether there's a user/host match in the setup_actors table. Subthreads are again matched, while for background threads, this will be set to YES by default. To monitor events that the thread executes, INSTRUMENTED must be YES and the thread_instrumentation consumer in the setup_consumers table must also be YES.
HISTORY
YES or NO for Whether to log historical events for the thread. For foreground threads, the initial value is determined by whether there's a user/host match in the setup_actors table. Subthreads are again matched, while for background threads, this will be set to YES by default. To monitor events that the thread executes, INSTRUMENTED must be YES and the thread_instrumentation consumer in the setup_consumers table must also be YES. Added in .
CONNECTION_TYPE
The protocol used to establish the connection. One of TCP/IP, SSL/TLS, Socket, Named Pipe, Shared Memory, or NULL for background threads. Added in .
THREAD_OS_ID
The thread or task identifier as defined by the underlying operating system, if there is one. Added in
The mutex_instances table lists all active mutexes (mutual exclusions) instrumented by the Performance Schema, showing their locked state.
The mutex_instances table lists all mutexes that the Performance Schema seeing while the server is executing.
A mutex is a code mechanism for ensuring that threads can only access resources one at a time. A second thread attempting to access a resource will find it protected by a mutex, and will wait for it to be unlocked.
The performance_schema_max_mutex_instances system variable specifies the maximum number of instrumented mutex instances.
This page is licensed: CC BY-SA / Gnu FDL
The users table tracks connection statistics aggregated by user name, including current active connections and total historical connections.
Each user that connects to the server is stored as a row in the users table, along with current and total connections.
The table size is determined at startup by the value of the performance_schema_users_size system variable. If this is set to 0, user statistics will be disabled.
This page is licensed: CC BY-SA / Gnu FDL
This table aggregates table lock wait events, allowing administrators to identify tables experiencing high contention due to locking.
The table_lock_waits_summary_by_table table records table lock waits by table.
SELECT * FROM performance_schema.threads\G;
*************************** 1. row ***************************
THREAD_ID: 1
NAME: thread/sql/main
TYPE: BACKGROUND
PROCESSLIST_ID: NULL
PROCESSLIST_USER: NULL
PROCESSLIST_HOST: NULL
PROCESSLIST_DB: NULL
PROCESSLIST_COMMAND: NULL
PROCESSLIST_TIME: 215859
PROCESSLIST_STATE: Table lock
PROCESSLIST_INFO: INTERNAL DDL LOG RECOVER IN PROGRESS
PARENT_THREAD_ID: NULL
ROLE: NULL
INSTRUMENTED: YES
...
*************************** 21. row ***************************
THREAD_ID: 64
NAME: thread/sql/one_connection
TYPE: FOREGROUND
PROCESSLIST_ID: 44
PROCESSLIST_USER: root
PROCESSLIST_HOST: localhost
PROCESSLIST_DB: NULL
PROCESSLIST_COMMAND: Query
PROCESSLIST_TIME: 0
PROCESSLIST_STATE: Sending data
PROCESSLIST_INFO: SELECT * FROM performance_schema.threads
PARENT_THREAD_ID: NULL
ROLE: NULL
INSTRUMENTED: YESNAME
Instrument name associated with the mutex.
OBJECT_INSTANCE_BEGIN
Memory address of the instrumented mutex.
LOCKED_BY_THREAD_ID
The THREAD_ID of the locking thread if a thread has a mutex locked, otherwise NULL.
Number of summarized events and the sum of the x_READ and x_WRITE columns.
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.
COUNT_READ
Number of all read operations, and the sum of the equivalent x_READ_NORMAL, x_READ_WITH_SHARED_LOCKS, x_READ_HIGH_PRIORITY and x_READ_NO_INSERT columns.
SUM_TIMER_READ
Total wait time of all read operations that are timed.
MIN_TIMER_READ
Minimum wait time of all read operations that are timed.
AVG_TIMER_READ
Average wait time of all read operations that are timed.
MAX_TIMER_READ
Maximum wait time of all read operations that are timed.
COUNT_WRITE
Number of all write operations, and the sum of the equivalent x_WRITE_ALLOW_WRITE, x_WRITE_CONCURRENT_INSERT, x_WRITE_DELAYED, x_WRITE_LOW_PRIORITY and x_WRITE_NORMAL columns.
SUM_TIMER_WRITE
Total wait time of all write operations that are timed.
MIN_TIMER_WRITE
Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE
Average wait time of all write operations that are timed.
MAX_TIMER_WRITE
Maximum wait time of all write operations that are timed.
COUNT_READ_NORMAL
Number of all internal read normal locks.
SUM_TIMER_READ_NORMAL
Total wait time of all internal read normal locks that are timed.
MIN_TIMER_READ_NORMAL
Minimum wait time of all internal read normal locks that are timed.
AVG_TIMER_READ_NORMAL
Average wait time of all internal read normal locks that are timed.
MAX_TIMER_READ_NORMAL
Maximum wait time of all internal read normal locks that are timed.
COUNT_READ_WITH_SHARED_LOCKS
Number of all internal read with shared locks.
SUM_TIMER_READ_WITH_SHARED_LOCKS
Total wait time of all internal read with shared locks that are timed.
MIN_TIMER_READ_WITH_SHARED_LOCKS
Minimum wait time of all internal read with shared locks that are timed.
AVG_TIMER_READ_WITH_SHARED_LOCKS
Average wait time of all internal read with shared locks that are timed.
MAX_TIMER_READ_WITH_SHARED_LOCKS
Maximum wait time of all internal read with shared locks that are timed.
COUNT_READ_HIGH_PRIORITY
Number of all internal read high priority locks.
SUM_TIMER_READ_HIGH_PRIORITY
Total wait time of all internal read high priority locks that are timed.
MIN_TIMER_READ_HIGH_PRIORITY
Minimum wait time of all internal read high priority locks that are timed.
AVG_TIMER_READ_HIGH_PRIORITY
Average wait time of all internal read high priority locks that are timed.
MAX_TIMER_READ_HIGH_PRIORITY
Maximum wait time of all internal read high priority locks that are timed.
COUNT_READ_NO_INSERT
Number of all internal read no insert locks.
SUM_TIMER_READ_NO_INSERT
Total wait time of all internal read no insert locks that are timed.
MIN_TIMER_READ_NO_INSERT
Minimum wait time of all internal read no insert locks that are timed.
AVG_TIMER_READ_NO_INSERT
Average wait time of all internal read no insert locks that are timed.
MAX_TIMER_READ_NO_INSERT
Maximum wait time of all internal read no insert locks that are timed.
COUNT_READ_EXTERNAL
Number of all external read locks.
SUM_TIMER_READ_EXTERNAL
Total wait time of all external read locks that are timed.
MIN_TIMER_READ_EXTERNAL
Minimum wait time of all external read locks that are timed.
AVG_TIMER_READ_EXTERNAL
Average wait time of all external read locks that are timed.
MAX_TIMER_READ_EXTERNAL
Maximum wait time of all external read locks that are timed.
COUNT_WRITE_ALLOW_WRITE
Number of all internal read normal locks.
SUM_TIMER_WRITE_ALLOW_WRITE
Total wait time of all internal write allow write locks that are timed.
MIN_TIMER_WRITE_ALLOW_WRITE
Minimum wait time of all internal write allow write locks that are timed.
AVG_TIMER_WRITE_ALLOW_WRITE
Average wait time of all internal write allow write locks that are timed.
MAX_TIMER_WRITE_ALLOW_WRITE
Maximum wait time of all internal write allow write locks that are timed.
COUNT_WRITE_CONCURRENT_INSERT
Number of all internal concurrent insert write locks.
SUM_TIMER_WRITE_CONCURRENT_INSERT
Total wait time of all internal concurrent insert write locks that are timed.
MIN_TIMER_WRITE_CONCURRENT_INSERT
Minimum wait time of all internal concurrent insert write locks that are timed.
AVG_TIMER_WRITE_CONCURRENT_INSERT
Average wait time of all internal concurrent insert write locks that are timed.
MAX_TIMER_WRITE_CONCURRENT_INSERT
Maximum wait time of all internal concurrent insert write locks that are timed.
COUNT_WRITE_DELAYED
Number of all internal write delayed locks.
SUM_TIMER_WRITE_DELAYED
Total wait time of all internal write delayed locks that are timed.
MIN_TIMER_WRITE_DELAYED
Minimum wait time of all internal write delayed locks that are timed.
AVG_TIMER_WRITE_DELAYED
Average wait time of all internal write delayed locks that are timed.
MAX_TIMER_WRITE_DELAYED
Maximum wait time of all internal write delayed locks that are timed.
COUNT_WRITE_LOW_PRIORITY
Number of all internal write low priority locks.
SUM_TIMER_WRITE_LOW_PRIORITY
Total wait time of all internal write low priority locks that are timed.
MIN_TIMER_WRITE_LOW_PRIORITY
Minimum wait time of all internal write low priority locks that are timed.
AVG_TIMER_WRITE_LOW_PRIORITY
Average wait time of all internal write low priority locks that are timed.
MAX_TIMER_WRITE_LOW_PRIORITY
Maximum wait time of all internal write low priority locks that are timed.
COUNT_WRITE_NORMAL
Number of all internal write normal locks.
SUM_TIMER_WRITE_NORMAL
Total wait time of all internal write normal locks that are timed.
MIN_TIMER_WRITE_NORMAL
Minimum wait time of all internal write normal locks that are timed.
AVG_TIMER_WRITE_NORMAL
Average wait time of all internal write normal locks that are timed.
MAX_TIMER_WRITE_NORMAL
Maximum wait time of all internal write normal locks that are timed.
COUNT_WRITE_EXTERNAL
Number of all external write locks.
SUM_TIMER_WRITE_EXTERNAL
Total wait time of all external write locks that are timed.
MIN_TIMER_WRITE_EXTERNAL
Minimum wait time of all external write locks that are timed.
AVG_TIMER_WRITE_EXTERNAL
Average wait time of all external write locks that are timed.
MAX_TIMER_WRITE_EXTERNAL
Maximum wait time of all external write locks that are timed.
You can TRUNCATE the table, which will reset all counters to zero.
This page is licensed: CC BY-SA / Gnu FDL
OBJECT_TYPE
Since this table records waits by table, always set to TABLE.
OBJECT_SCHEMA
Schema name.
OBJECT_NAME
Table name.
COUNT_STAR
USER
The connection's client user name for the connection, or NULL if an internal thread.
CURRENT_CONNECTIONS
Current connections for the user.
TOTAL_CONNECTIONS
Total connections for the user.
SELECT * FROM performance_schema.users;
+------------------+---------------------+-------------------+
| USER | CURRENT_CONNECTIONS | TOTAL_CONNECTIONS |
+------------------+---------------------+-------------------+
| debian-sys-maint | 0 | 35 |
| NULL | 20 | 23 |
| root | 1 | 2 |
+------------------+---------------------+-------------------+This table summarizes socket I/O events per socket instance, allowing for traffic analysis and latency monitoring of individual connections.
It aggregates timer and byte count statistics for all socket I/O operations by socket instance.
EVENT_NAME
Socket instrument.
OBJECT_INSTANCE_BEGIN
Address in memory.
COUNT_STAR
Number of summarized events
SUM_TIMER_WAIT
The corresponding row in the table is deleted when a connection terminates.
You can the table, which will reset all counters to zero.
This page is licensed: CC BY-SA / Gnu FDL
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.
COUNT_READ
Number of all read operations, including RECV, RECVFROM, and RECVMSG.
SUM_TIMER_READ
Total wait time of all read operations that are timed.
MIN_TIMER_READ
Minimum wait time of all read operations that are timed.
AVG_TIMER_READ
Average wait time of all read operations that are timed.
MAX_TIMER_READ
Maximum wait time of all read operations that are timed.
SUM_NUMBER_OF_BYTES_READ
Bytes read by read operations.
COUNT_WRITE
Number of all write operations, including SEND, SENDTO, and SENDMSG.
SUM_TIMER_WRITE
Total wait time of all write operations that are timed.
MIN_TIMER_WRITE
Minimum wait time of all write operations that are timed.
AVG_TIMER_WRITE
Average wait time of all write operations that are timed.
MAX_TIMER_WRITE
Maximum wait time of all write operations that are timed.
SUM_NUMBER_OF_BYTES_WRITE
Bytes written by write operations.
COUNT_MISC
Number of all miscellaneous operations not counted above, including CONNECT, LISTEN, ACCEPT, CLOSE, and SHUTDOWN.
SUM_TIMER_MISC
Total wait time of all miscellaneous operations that are timed.
MIN_TIMER_MISC
Minimum wait time of all miscellaneous operations that are timed.
AVG_TIMER_MISC
Average wait time of all miscellaneous operations that are timed.
MAX_TIMER_MISC
Maximum wait time of all miscellaneous operations that are timed.
The setup_instruments table lists all supported instruments, allowing administrators to enable collection and configure timing for specific events.
The setup_instruments table contains a list of instrumented object classes for which it is possible to collect events. There is one row for each instrument in the source code. When an instrument is enabled and executed, instances are created which are then stored in the cond_instances, file_instances, mutex_instances, rwlock_instances or socket_instance tables.
It contains the following columns:
NAME
Instrument name
ENABLED
Default settings with the Performance Schema enabled:
This page is licensed: CC BY-SA / Gnu FDL
Whether or not the instrument is enabled. It can be disabled, and the instrument will produce no events.
TIMED
Whether or not the instrument is timed. It can be set, but if disabled, events produced by the instrument will have NULL values for the corresponding TIMER_START, TIMER_END, and TIMER_WAIT values.
SELECT * FROM setup_instruments ORDER BY name;
+--------------------------------------------------------------------------------+---------+-------+
| NAME | ENABLED | TIMED |
+--------------------------------------------------------------------------------+---------+-------+
| idle | YES | YES |
| memory/csv/blobroot | NO | NO |
| memory/csv/row | NO | NO |
| memory/csv/tina_set | NO | NO |
| memory/csv/TINA_SHARE | NO | NO |
| memory/csv/Transparent_file | NO | NO |
| memory/innodb/adaptive hash index | NO | NO |
| memory/innodb/btr0btr | NO | NO |
| memory/innodb/btr0buf | NO | NO |
| memory/innodb/btr0bulk | NO | NO |
| memory/innodb/btr0cur | NO | NO |
| memory/innodb/btr0pcur | NO | NO |
| memory/innodb/btr0sea | NO | NO |
| memory/innodb/buf0buf | NO | NO |
| memory/innodb/buf0dblwr | NO | NO |
| memory/innodb/buf0dump | NO | NO |
| memory/innodb/buf_buf_pool | NO | NO |
| memory/innodb/dict0dict | NO | NO |
| memory/innodb/dict0mem | NO | NO |
| memory/innodb/dict0stats | NO | NO |
| memory/innodb/dict_stats_bg_recalc_pool_t | NO | NO |
| memory/innodb/dict_stats_index_map_t | NO | NO |
| memory/innodb/dict_stats_n_diff_on_level | NO | NO |
| memory/innodb/eval0eval | NO | NO |
| memory/innodb/fil0crypt | NO | NO |
| memory/innodb/fil0fil | NO | NO |
| memory/innodb/fsp0file | NO | NO |
| memory/innodb/fts0ast | NO | NO |
| memory/innodb/fts0blex | NO | NO |
| memory/innodb/fts0config | NO | NO |
| memory/innodb/fts0file | NO | NO |
| memory/innodb/fts0fts | NO | NO |
| memory/innodb/fts0opt | NO | NO |
| memory/innodb/fts0pars | NO | NO |
| memory/innodb/fts0que | NO | NO |
| memory/innodb/fts0sql | NO | NO |
| memory/innodb/fts0tlex | NO | NO |
| memory/innodb/gis0sea | NO | NO |
| memory/innodb/handler0alter | NO | NO |
| memory/innodb/hash0hash | NO | NO |
| memory/innodb/ha_innodb | NO | NO |
| memory/innodb/i_s | NO | NO |
| memory/innodb/lexyy | NO | NO |
| memory/innodb/lock0lock | NO | NO |
| memory/innodb/mem0mem | NO | NO |
| memory/innodb/os0event | NO | NO |
| memory/innodb/os0file | NO | NO |
| memory/innodb/other | NO | NO |
| memory/innodb/pars0lex | NO | NO |
| memory/innodb/rem0rec | NO | NO |
| memory/innodb/row0ftsort | NO | NO |
| memory/innodb/row0import | NO | NO |
| memory/innodb/row0log | NO | NO |
| memory/innodb/row0merge | NO | NO |
| memory/innodb/row0mysql | NO | NO |
| memory/innodb/row0sel | NO | NO |
| memory/innodb/row_log_buf | NO | NO |
| memory/innodb/row_merge_sort | NO | NO |
| memory/innodb/srv0start | NO | NO |
| memory/innodb/std | NO | NO |
| memory/innodb/sync0arr | NO | NO |
| memory/innodb/sync0debug | NO | NO |
| memory/innodb/sync0rw | NO | NO |
| memory/innodb/sync0start | NO | NO |
| memory/innodb/sync0types | NO | NO |
| memory/innodb/trx0i_s | NO | NO |
| memory/innodb/trx0roll | NO | NO |
| memory/innodb/trx0rseg | NO | NO |
| memory/innodb/trx0seg | NO | NO |
| memory/innodb/trx0trx | NO | NO |
| memory/innodb/trx0undo | NO | NO |
| memory/innodb/ut0list | NO | NO |
| memory/innodb/ut0mem | NO | NO |
| memory/innodb/ut0new | NO | NO |
| memory/innodb/ut0pool | NO | NO |
| memory/innodb/ut0rbt | NO | NO |
| memory/innodb/ut0wqueue | NO | NO |
| memory/innodb/xtrabackup | NO | NO |
| memory/memory/HP_INFO | NO | NO |
| memory/memory/HP_KEYDEF | NO | NO |
| memory/memory/HP_PTRS | NO | NO |
| memory/memory/HP_SHARE | NO | NO |
| memory/myisam/filecopy | NO | NO |
| memory/myisam/FTB | NO | NO |
| memory/myisam/FTPARSER_PARAM | NO | NO |
| memory/myisam/FT_INFO | NO | NO |
| memory/myisam/ft_memroot | NO | NO |
| memory/myisam/ft_stopwords | NO | NO |
| memory/myisam/keycache_thread_var | NO | NO |
| memory/myisam/MI_DECODE_TREE | NO | NO |
| memory/myisam/MI_INFO | NO | NO |
| memory/myisam/MI_INFO::bulk_insert | NO | NO |
| memory/myisam/MI_INFO::ft1_to_ft2 | NO | NO |
| memory/myisam/MI_SORT_PARAM | NO | NO |
| memory/myisam/MI_SORT_PARAM::wordroot | NO | NO |
| memory/myisam/MYISAM_SHARE | NO | NO |
| memory/myisam/MYISAM_SHARE::decode_tables | NO | NO |
| memory/myisam/preload_buffer | NO | NO |
| memory/myisam/record_buffer | NO | NO |
| memory/myisam/SORT_FT_BUF | NO | NO |
| memory/myisam/SORT_INFO::buffer | NO | NO |
| memory/myisam/SORT_KEY_BLOCKS | NO | NO |
| memory/myisam/stPageList::pages | NO | NO |
| memory/myisammrg/children | NO | NO |
| memory/myisammrg/MYRG_INFO | NO | NO |
| memory/partition/ha_partition::file | NO | NO |
| memory/partition/ha_partition::part_ids | NO | NO |
| memory/partition/Partition_admin | NO | NO |
| memory/partition/Partition_share | NO | NO |
| memory/partition/partition_sort_buffer | NO | NO |
| memory/performance_schema/accounts | YES | NO |
| memory/performance_schema/cond_class | YES | NO |
| memory/performance_schema/cond_instances | YES | NO |
| memory/performance_schema/events_stages_history | YES | NO |
| memory/performance_schema/events_stages_history_long | YES | NO |
| memory/performance_schema/events_stages_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/events_stages_summary_global_by_event_name | YES | NO |
| memory/performance_schema/events_statements_current | YES | NO |
| memory/performance_schema/events_statements_current.sqltext | YES | NO |
| memory/performance_schema/events_statements_current.tokens | YES | NO |
| memory/performance_schema/events_statements_history | YES | NO |
| memory/performance_schema/events_statements_history.sqltext | YES | NO |
| memory/performance_schema/events_statements_history.tokens | YES | NO |
| memory/performance_schema/events_statements_history_long | YES | NO |
| memory/performance_schema/events_statements_history_long.sqltext | YES | NO |
| memory/performance_schema/events_statements_history_long.tokens | YES | NO |
| memory/performance_schema/events_statements_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_by_digest | YES | NO |
| memory/performance_schema/events_statements_summary_by_digest.tokens | YES | NO |
| memory/performance_schema/events_statements_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_by_program | YES | NO |
| memory/performance_schema/events_statements_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/events_statements_summary_global_by_event_name | YES | NO |
| memory/performance_schema/events_transactions_history | YES | NO |
| memory/performance_schema/events_transactions_history_long | YES | NO |
| memory/performance_schema/events_transactions_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/events_transactions_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/events_transactions_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/events_transactions_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/events_waits_history | YES | NO |
| memory/performance_schema/events_waits_history_long | YES | NO |
| memory/performance_schema/events_waits_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/events_waits_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/events_waits_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/events_waits_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/file_class | YES | NO |
| memory/performance_schema/file_handle | YES | NO |
| memory/performance_schema/file_instances | YES | NO |
| memory/performance_schema/hosts | YES | NO |
| memory/performance_schema/memory_class | YES | NO |
| memory/performance_schema/memory_summary_by_account_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_by_host_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_by_thread_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_by_user_by_event_name | YES | NO |
| memory/performance_schema/memory_summary_global_by_event_name | YES | NO |
| memory/performance_schema/metadata_locks | YES | NO |
| memory/performance_schema/mutex_class | YES | NO |
| memory/performance_schema/mutex_instances | YES | NO |
| memory/performance_schema/prepared_statements_instances | YES | NO |
| memory/performance_schema/rwlock_class | YES | NO |
| memory/performance_schema/rwlock_instances | YES | NO |
| memory/performance_schema/scalable_buffer | YES | NO |
| memory/performance_schema/session_connect_attrs | YES | NO |
| memory/performance_schema/setup_actors | YES | NO |
| memory/performance_schema/setup_objects | YES | NO |
| memory/performance_schema/socket_class | YES | NO |
| memory/performance_schema/socket_instances | YES | NO |
| memory/performance_schema/stage_class | YES | NO |
| memory/performance_schema/statement_class | YES | NO |
| memory/performance_schema/table_handles | YES | NO |
| memory/performance_schema/table_io_waits_summary_by_index_usage | YES | NO |
| memory/performance_schema/table_lock_waits_summary_by_table | YES | NO |
| memory/performance_schema/table_shares | YES | NO |
| memory/performance_schema/threads | YES | NO |
| memory/performance_schema/thread_class | YES | NO |
| memory/performance_schema/users | YES | NO |
| memory/sql/acl_cache | NO | NO |
| memory/sql/binlog_cache_mngr | NO | NO |
| memory/sql/binlog_pos | NO | NO |
| memory/sql/binlog_statement_buffer | NO | NO |
| memory/sql/binlog_ver_1_event | NO | NO |
| memory/sql/bison_stack | NO | NO |
| memory/sql/Blob_mem_storage::storage | NO | NO |
| memory/sql/DATE_TIME_FORMAT | NO | NO |
| memory/sql/dboptions_hash | NO | NO |
| memory/sql/DDL_LOG_MEMORY_ENTRY | NO | NO |
| memory/sql/display_table_locks | NO | NO |
| memory/sql/errmsgs | NO | NO |
| memory/sql/Event_basic::mem_root | NO | NO |
| memory/sql/Event_queue_element_for_exec::names | NO | NO |
| memory/sql/Event_scheduler::scheduler_param | NO | NO |
| memory/sql/Filesort_info::merge | NO | NO |
| memory/sql/Filesort_info::record_pointers | NO | NO |
| memory/sql/frm::string | NO | NO |
| memory/sql/gdl | NO | NO |
| memory/sql/Gis_read_stream::err_msg | NO | NO |
| memory/sql/global_system_variables | NO | NO |
| memory/sql/handler::errmsgs | NO | NO |
| memory/sql/handlerton | NO | NO |
| memory/sql/hash_index_key_buffer | NO | NO |
| memory/sql/host_cache::hostname | NO | NO |
| memory/sql/ignored_db | NO | NO |
| memory/sql/JOIN_CACHE | NO | NO |
| memory/sql/load_env_plugins | NO | NO |
| memory/sql/Locked_tables_list::m_locked_tables_root | NO | NO |
| memory/sql/MDL_context::acquire_locks | NO | NO |
| memory/sql/MPVIO_EXT::auth_info | NO | NO |
| memory/sql/MYSQL_BIN_LOG::basename | NO | NO |
| memory/sql/MYSQL_BIN_LOG::index | NO | NO |
| memory/sql/MYSQL_BIN_LOG::recover | NO | NO |
| memory/sql/MYSQL_LOCK | NO | NO |
| memory/sql/MYSQL_LOG::name | NO | NO |
| memory/sql/mysql_plugin | NO | NO |
| memory/sql/mysql_plugin_dl | NO | NO |
| memory/sql/MYSQL_RELAY_LOG::basename | NO | NO |
| memory/sql/MYSQL_RELAY_LOG::index | NO | NO |
| memory/sql/my_str_malloc | NO | NO |
| memory/sql/NAMED_ILINK::name | NO | NO |
| memory/sql/native_functions | NO | NO |
| memory/sql/plugin_bookmark | NO | NO |
| memory/sql/plugin_int_mem_root | NO | NO |
| memory/sql/plugin_mem_root | NO | NO |
| memory/sql/Prepared_statement::main_mem_root | NO | NO |
| memory/sql/Prepared_statement_map | NO | NO |
| memory/sql/PROFILE | NO | NO |
| memory/sql/Query_cache | NO | NO |
| memory/sql/Queue::queue_item | NO | NO |
| memory/sql/QUICK_RANGE_SELECT::alloc | NO | NO |
| memory/sql/QUICK_RANGE_SELECT::mrr_buf_desc | NO | NO |
| memory/sql/Relay_log_info::group_relay_log_name | NO | NO |
| memory/sql/root | NO | NO |
| memory/sql/Row_data_memory::memory | NO | NO |
| memory/sql/rpl_filter memory | NO | NO |
| memory/sql/Rpl_info_file::buffer | NO | NO |
| memory/sql/servers_cache | NO | NO |
| memory/sql/SLAVE_INFO | NO | NO |
| memory/sql/Sort_param::tmp_buffer | NO | NO |
| memory/sql/sp_head::call_mem_root | NO | NO |
| memory/sql/sp_head::execute_mem_root | NO | NO |
| memory/sql/sp_head::main_mem_root | NO | NO |
| memory/sql/sql_acl_mem | NO | NO |
| memory/sql/sql_acl_memex | NO | NO |
| memory/sql/String::value | NO | NO |
| memory/sql/ST_SCHEMA_TABLE | NO | NO |
| memory/sql/Sys_var_charptr::value | NO | NO |
| memory/sql/TABLE | NO | NO |
| memory/sql/table_mapping::m_mem_root | NO | NO |
| memory/sql/TABLE_RULE_ENT | NO | NO |
| memory/sql/TABLE_SHARE::mem_root | NO | NO |
| memory/sql/Table_triggers_list | NO | NO |
| memory/sql/Table_trigger_dispatcher::m_mem_root | NO | NO |
| memory/sql/TC_LOG_MMAP::pages | NO | NO |
| memory/sql/THD::db | NO | NO |
| memory/sql/THD::handler_tables_hash | NO | NO |
| memory/sql/thd::main_mem_root | NO | NO |
| memory/sql/THD::sp_cache | NO | NO |
| memory/sql/THD::transactions::mem_root | NO | NO |
| memory/sql/THD::variables | NO | NO |
| memory/sql/tz_storage | NO | NO |
| memory/sql/udf_mem | NO | NO |
| memory/sql/Unique::merge_buffer | NO | NO |
| memory/sql/Unique::sort_buffer | NO | NO |
| memory/sql/user_conn | NO | NO |
| memory/sql/User_level_lock | NO | NO |
| memory/sql/user_var_entry | NO | NO |
| memory/sql/user_var_entry::value | NO | NO |
| memory/sql/XID | NO | NO |
| stage/aria/Waiting for a resource | NO | NO |
| stage/innodb/alter table (end) | YES | YES |
| stage/innodb/alter table (insert) | YES | YES |
| stage/innodb/alter table (log apply index) | YES | YES |
| stage/innodb/alter table (log apply table) | YES | YES |
| stage/innodb/alter table (merge sort) | YES | YES |
| stage/innodb/alter table (read PK and internal sort) | YES | YES |
| stage/innodb/buffer pool load | YES | YES |
| stage/mysys/Waiting for table level lock | NO | NO |
| stage/sql/After apply log event | NO | NO |
| stage/sql/After create | NO | NO |
| stage/sql/After opening tables | NO | NO |
| stage/sql/After table lock | NO | NO |
| stage/sql/Allocating local table | NO | NO |
| stage/sql/altering table | NO | NO |
| stage/sql/Apply log event | NO | NO |
| stage/sql/Changing master | NO | NO |
| stage/sql/Checking master version | NO | NO |
| stage/sql/checking permissions | NO | NO |
| stage/sql/checking privileges on cached query | NO | NO |
| stage/sql/Checking query cache for query | NO | NO |
| stage/sql/closing tables | NO | NO |
| stage/sql/Commit | NO | NO |
| stage/sql/Commit implicit | NO | NO |
| stage/sql/Committing alter table to storage engine | NO | NO |
| stage/sql/Connecting to master | NO | NO |
| stage/sql/Converting HEAP to Aria | NO | NO |
| stage/sql/copy to tmp table | YES | YES |
| stage/sql/Copying to group table | NO | NO |
| stage/sql/Copying to tmp table | NO | NO |
| stage/sql/Creating delayed handler | NO | NO |
| stage/sql/Creating sort index | NO | NO |
| stage/sql/creating table | NO | NO |
| stage/sql/Creating tmp table | NO | NO |
| stage/sql/Deleting from main table | NO | NO |
| stage/sql/Deleting from reference tables | NO | NO |
| stage/sql/Discard_or_import_tablespace | NO | NO |
| stage/sql/Enabling keys | NO | NO |
| stage/sql/End of update loop | NO | NO |
| stage/sql/Executing | NO | NO |
| stage/sql/Execution of init_command | NO | NO |
| stage/sql/Explaining | NO | NO |
| stage/sql/Filling schema table | NO | NO |
| stage/sql/Finding key cache | NO | NO |
| stage/sql/Finished reading one binlog; switching to next binlog | NO | NO |
| stage/sql/Flushing relay log and master info repository. | NO | NO |
| stage/sql/Flushing relay-log info file. | NO | NO |
| stage/sql/Freeing items | NO | NO |
| stage/sql/Fulltext initialization | NO | NO |
| stage/sql/Got handler lock | NO | NO |
| stage/sql/Got old table | NO | NO |
| stage/sql/init | NO | NO |
| stage/sql/init for update | NO | NO |
| stage/sql/Insert | NO | NO |
| stage/sql/Invalidating query cache entries (table list) | NO | NO |
| stage/sql/Invalidating query cache entries (table) | NO | NO |
| stage/sql/Killing slave | NO | NO |
| stage/sql/Logging slow query | NO | NO |
| stage/sql/Making temporary file (append) before replaying LOAD DATA INFILE | NO | NO |
| stage/sql/Making temporary file (create) before replaying LOAD DATA INFILE | NO | NO |
| stage/sql/Manage keys | NO | NO |
| stage/sql/Master has sent all binlog to slave; waiting for more updates | NO | NO |
| stage/sql/Opening tables | NO | NO |
| stage/sql/Optimizing | NO | NO |
| stage/sql/Preparing | NO | NO |
| stage/sql/preparing for alter table | NO | NO |
| stage/sql/Processing binlog checkpoint notification | NO | NO |
| stage/sql/Processing requests | NO | NO |
| stage/sql/Purging old relay logs | NO | NO |
| stage/sql/Query end | NO | NO |
| stage/sql/Queueing master event to the relay log | NO | NO |
| stage/sql/Reading event from the relay log | NO | NO |
| stage/sql/Reading semi-sync ACK from slave | NO | NO |
| stage/sql/Recreating table | NO | NO |
| stage/sql/Registering slave on master | NO | NO |
| stage/sql/Removing duplicates | NO | NO |
| stage/sql/Removing tmp table | NO | NO |
| stage/sql/Rename | NO | NO |
| stage/sql/Rename result table | NO | NO |
| stage/sql/Requesting binlog dump | NO | NO |
| stage/sql/Reschedule | NO | NO |
| stage/sql/Reset for next command | NO | NO |
| stage/sql/Rollback | NO | NO |
| stage/sql/Rollback_implicit | NO | NO |
| stage/sql/Searching rows for update | NO | NO |
| stage/sql/Sending binlog event to slave | NO | NO |
| stage/sql/Sending cached result to client | NO | NO |
| stage/sql/Sending data | NO | NO |
| stage/sql/setup | NO | NO |
| stage/sql/Show explain | NO | NO |
| stage/sql/Slave has read all relay log; waiting for more updates | NO | NO |
| stage/sql/Sorting | NO | NO |
| stage/sql/Sorting for group | NO | NO |
| stage/sql/Sorting for order | NO | NO |
| stage/sql/Sorting result | NO | NO |
| stage/sql/starting | NO | NO |
| stage/sql/Starting cleanup | NO | NO |
| stage/sql/Statistics | NO | NO |
| stage/sql/Stopping binlog background thread | NO | NO |
| stage/sql/Storing result in query cache | NO | NO |
| stage/sql/Storing row into queue | NO | NO |
| stage/sql/System lock | NO | NO |
| stage/sql/table lock | NO | NO |
| stage/sql/Unlocking tables | NO | NO |
| stage/sql/Update | NO | NO |
| stage/sql/Updating | NO | NO |
| stage/sql/Updating main table | NO | NO |
| stage/sql/Updating reference tables | NO | NO |
| stage/sql/Upgrading lock | NO | NO |
| stage/sql/User lock | NO | NO |
| stage/sql/User sleep | NO | NO |
| stage/sql/Verifying table | NO | NO |
| stage/sql/Waiting for background binlog tasks | NO | NO |
| stage/sql/Waiting for backup lock | NO | NO |
| stage/sql/Waiting for delay_list | NO | NO |
| stage/sql/Waiting for event metadata lock | NO | NO |
| stage/sql/Waiting for GTID to be written to binary log | NO | NO |
| stage/sql/Waiting for handler insert | NO | NO |
| stage/sql/Waiting for handler lock | NO | NO |
| stage/sql/Waiting for handler open | NO | NO |
| stage/sql/Waiting for INSERT | NO | NO |
| stage/sql/Waiting for master to send event | NO | NO |
| stage/sql/Waiting for master update | NO | NO |
| stage/sql/Waiting for next activation | NO | NO |
| stage/sql/Waiting for other master connection to process the same GTID | NO | NO |
| stage/sql/Waiting for parallel replication deadlock handling to complete | NO | NO |
| stage/sql/Waiting for prior transaction to commit | NO | NO |
| stage/sql/Waiting for prior transaction to start commit | NO | NO |
| stage/sql/Waiting for query cache lock | NO | NO |
| stage/sql/Waiting for requests | NO | NO |
| stage/sql/Waiting for room in worker thread event queue | NO | NO |
| stage/sql/Waiting for schema metadata lock | NO | NO |
| stage/sql/Waiting for semi-sync ACK from slave | NO | NO |
| stage/sql/Waiting for semi-sync slave connection | NO | NO |
| stage/sql/Waiting for slave mutex on exit | NO | NO |
| stage/sql/Waiting for slave thread to start | NO | NO |
| stage/sql/Waiting for stored function metadata lock | NO | NO |
| stage/sql/Waiting for stored package body metadata lock | NO | NO |
| stage/sql/Waiting for stored procedure metadata lock | NO | NO |
| stage/sql/Waiting for table flush | NO | NO |
| stage/sql/Waiting for table metadata lock | NO | NO |
| stage/sql/Waiting for the next event in relay log | NO | NO |
| stage/sql/Waiting for the scheduler to stop | NO | NO |
| stage/sql/Waiting for the slave SQL thread to advance position | NO | NO |
| stage/sql/Waiting for the slave SQL thread to free enough relay log space | NO | NO |
| stage/sql/Waiting for trigger metadata lock | NO | NO |
| stage/sql/Waiting for work from SQL thread | NO | NO |
| stage/sql/Waiting in MASTER_GTID_WAIT() | NO | NO |
| stage/sql/Waiting in MASTER_GTID_WAIT() (primary waiter) | NO | NO |
| stage/sql/Waiting on empty queue | NO | NO |
| stage/sql/Waiting to finalize termination | NO | NO |
| stage/sql/Waiting until MASTER_DELAY seconds after master executed event | NO | NO |
| stage/sql/Writing to binlog | NO | NO |
| statement/abstract/new_packet | YES | YES |
| statement/abstract/Query | YES | YES |
| statement/abstract/relay_log | YES | YES |
| statement/com/Binlog Dump | YES | YES |
| statement/com/Bulk_execute | YES | YES |
| statement/com/Change user | YES | YES |
| statement/com/Close stmt | YES | YES |
| statement/com/Com_multi | YES | YES |
| statement/com/Connect | YES | YES |
| statement/com/Connect Out | YES | YES |
| statement/com/Create DB | YES | YES |
| statement/com/Daemon | YES | YES |
| statement/com/Debug | YES | YES |
| statement/com/Delayed insert | YES | YES |
| statement/com/Drop DB | YES | YES |
| statement/com/Error | YES | YES |
| statement/com/Execute | YES | YES |
| statement/com/Fetch | YES | YES |
| statement/com/Field List | YES | YES |
| statement/com/Init DB | YES | YES |
| statement/com/Kill | YES | YES |
| statement/com/Long Data | YES | YES |
| statement/com/Ping | YES | YES |
| statement/com/Prepare | YES | YES |
| statement/com/Processlist | YES | YES |
| statement/com/Quit | YES | YES |
| statement/com/Refresh | YES | YES |
| statement/com/Register Slave | YES | YES |
| statement/com/Reset connection | YES | YES |
| statement/com/Reset stmt | YES | YES |
| statement/com/Set option | YES | YES |
| statement/com/Shutdown | YES | YES |
| statement/com/Slave_IO | YES | YES |
| statement/com/Slave_SQL | YES | YES |
| statement/com/Slave_worker | YES | YES |
| statement/com/Sleep | YES | YES |
| statement/com/Statistics | YES | YES |
| statement/com/Table Dump | YES | YES |
| statement/com/Time | YES | YES |
| statement/com/Unimpl get tid | YES | YES |
| statement/scheduler/event | YES | YES |
| statement/sp/agg_cfetch | YES | YES |
| statement/sp/cclose | YES | YES |
| statement/sp/cfetch | YES | YES |
| statement/sp/copen | YES | YES |
| statement/sp/cpop | YES | YES |
| statement/sp/cpush | YES | YES |
| statement/sp/cursor_copy_struct | YES | YES |
| statement/sp/error | YES | YES |
| statement/sp/freturn | YES | YES |
| statement/sp/hpop | YES | YES |
| statement/sp/hpush_jump | YES | YES |
| statement/sp/hreturn | YES | YES |
| statement/sp/jump | YES | YES |
| statement/sp/jump_if_not | YES | YES |
| statement/sp/preturn | YES | YES |
| statement/sp/set | YES | YES |
| statement/sp/set_case_expr | YES | YES |
| statement/sp/set_trigger_field | YES | YES |
| statement/sp/stmt | YES | YES |
| statement/sql/ | YES | YES |
| statement/sql/alter_db | YES | YES |
| statement/sql/alter_db_upgrade | YES | YES |
| statement/sql/alter_event | YES | YES |
| statement/sql/alter_function | YES | YES |
| statement/sql/alter_procedure | YES | YES |
| statement/sql/alter_sequence | YES | YES |
| statement/sql/alter_server | YES | YES |
| statement/sql/alter_table | YES | YES |
| statement/sql/alter_tablespace | YES | YES |
| statement/sql/alter_user | YES | YES |
| statement/sql/analyze | YES | YES |
| statement/sql/assign_to_keycache | YES | YES |
| statement/sql/backup | YES | YES |
| statement/sql/backup_lock | YES | YES |
| statement/sql/begin | YES | YES |
| statement/sql/binlog | YES | YES |
| statement/sql/call_procedure | YES | YES |
| statement/sql/change_db | YES | YES |
| statement/sql/change_master | YES | YES |
| statement/sql/check | YES | YES |
| statement/sql/checksum | YES | YES |
| statement/sql/commit | YES | YES |
| statement/sql/compound_sql | YES | YES |
| statement/sql/create_db | YES | YES |
| statement/sql/create_event | YES | YES |
| statement/sql/create_function | YES | YES |
| statement/sql/create_index | YES | YES |
| statement/sql/create_package | YES | YES |
| statement/sql/create_package_body | YES | YES |
| statement/sql/create_procedure | YES | YES |
| statement/sql/create_role | YES | YES |
| statement/sql/create_sequence | YES | YES |
| statement/sql/create_server | YES | YES |
| statement/sql/create_table | YES | YES |
| statement/sql/create_trigger | YES | YES |
| statement/sql/create_udf | YES | YES |
| statement/sql/create_user | YES | YES |
| statement/sql/create_view | YES | YES |
| statement/sql/dealloc_sql | YES | YES |
| statement/sql/delete | YES | YES |
| statement/sql/delete_multi | YES | YES |
| statement/sql/do | YES | YES |
| statement/sql/drop_db | YES | YES |
| statement/sql/drop_event | YES | YES |
| statement/sql/drop_function | YES | YES |
| statement/sql/drop_index | YES | YES |
| statement/sql/drop_package | YES | YES |
| statement/sql/drop_package_body | YES | YES |
| statement/sql/drop_procedure | YES | YES |
| statement/sql/drop_role | YES | YES |
| statement/sql/drop_sequence | YES | YES |
| statement/sql/drop_server | YES | YES |
| statement/sql/drop_table | YES | YES |
| statement/sql/drop_trigger | YES | YES |
| statement/sql/drop_user | YES | YES |
| statement/sql/drop_view | YES | YES |
| statement/sql/empty_query | YES | YES |
| statement/sql/error | YES | YES |
| statement/sql/execute_immediate | YES | YES |
| statement/sql/execute_sql | YES | YES |
| statement/sql/flush | YES | YES |
| statement/sql/get_diagnostics | YES | YES |
| statement/sql/grant | YES | YES |
| statement/sql/grant_role | YES | YES |
| statement/sql/ha_close | YES | YES |
| statement/sql/ha_open | YES | YES |
| statement/sql/ha_read | YES | YES |
| statement/sql/help | YES | YES |
| statement/sql/insert | YES | YES |
| statement/sql/insert_select | YES | YES |
| statement/sql/install_plugin | YES | YES |
| statement/sql/kill | YES | YES |
| statement/sql/load | YES | YES |
| statement/sql/lock_tables | YES | YES |
| statement/sql/optimize | YES | YES |
| statement/sql/preload_keys | YES | YES |
| statement/sql/prepare_sql | YES | YES |
| statement/sql/purge | YES | YES |
| statement/sql/purge_before_date | YES | YES |
| statement/sql/release_savepoint | YES | YES |
| statement/sql/rename_table | YES | YES |
| statement/sql/rename_user | YES | YES |
| statement/sql/repair | YES | YES |
| statement/sql/replace | YES | YES |
| statement/sql/replace_select | YES | YES |
| statement/sql/reset | YES | YES |
| statement/sql/resignal | YES | YES |
| statement/sql/revoke | YES | YES |
| statement/sql/revoke_all | YES | YES |
| statement/sql/revoke_role | YES | YES |
| statement/sql/rollback | YES | YES |
| statement/sql/rollback_to_savepoint | YES | YES |
| statement/sql/savepoint | YES | YES |
| statement/sql/select | YES | YES |
| statement/sql/set_option | YES | YES |
| statement/sql/show_authors | YES | YES |
| statement/sql/show_binlogs | YES | YES |
| statement/sql/show_binlog_events | YES | YES |
| statement/sql/show_binlog_status | YES | YES |
| statement/sql/show_charsets | YES | YES |
| statement/sql/show_collations | YES | YES |
| statement/sql/show_contributors | YES | YES |
| statement/sql/show_create_db | YES | YES |
| statement/sql/show_create_event | YES | YES |
| statement/sql/show_create_func | YES | YES |
| statement/sql/show_create_package | YES | YES |
| statement/sql/show_create_package_body | YES | YES |
| statement/sql/show_create_proc | YES | YES |
| statement/sql/show_create_table | YES | YES |
| statement/sql/show_create_trigger | YES | YES |
| statement/sql/show_create_user | YES | YES |
| statement/sql/show_databases | YES | YES |
| statement/sql/show_engine_logs | YES | YES |
| statement/sql/show_engine_mutex | YES | YES |
| statement/sql/show_engine_status | YES | YES |
| statement/sql/show_errors | YES | YES |
| statement/sql/show_events | YES | YES |
| statement/sql/show_explain | YES | YES |
| statement/sql/show_fields | YES | YES |
| statement/sql/show_function_status | YES | YES |
| statement/sql/show_generic | YES | YES |
| statement/sql/show_grants | YES | YES |
| statement/sql/show_keys | YES | YES |
| statement/sql/show_open_tables | YES | YES |
| statement/sql/show_package_body_status | YES | YES |
| statement/sql/show_package_status | YES | YES |
| statement/sql/show_plugins | YES | YES |
| statement/sql/show_privileges | YES | YES |
| statement/sql/show_procedure_status | YES | YES |
| statement/sql/show_processlist | YES | YES |
| statement/sql/show_profile | YES | YES |
| statement/sql/show_profiles | YES | YES |
| statement/sql/show_relaylog_events | YES | YES |
| statement/sql/show_slave_hosts | YES | YES |
| statement/sql/show_slave_status | YES | YES |
| statement/sql/show_status | YES | YES |
| statement/sql/show_storage_engines | YES | YES |
| statement/sql/show_tables | YES | YES |
| statement/sql/show_table_status | YES | YES |
| statement/sql/show_triggers | YES | YES |
| statement/sql/show_variables | YES | YES |
| statement/sql/show_warnings | YES | YES |
| statement/sql/shutdown | YES | YES |
| statement/sql/signal | YES | YES |
| statement/sql/start_all_slaves | YES | YES |
| statement/sql/start_slave | YES | YES |
| statement/sql/stop_all_slaves | YES | YES |
| statement/sql/stop_slave | YES | YES |
| statement/sql/truncate | YES | YES |
| statement/sql/uninstall_plugin | YES | YES |
| statement/sql/unlock_tables | YES | YES |
| statement/sql/update | YES | YES |
| statement/sql/update_multi | YES | YES |
| statement/sql/xa_commit | YES | YES |
| statement/sql/xa_end | YES | YES |
| statement/sql/xa_prepare | YES | YES |
| statement/sql/xa_recover | YES | YES |
| statement/sql/xa_rollback | YES | YES |
| statement/sql/xa_start | YES | YES |
| transaction | NO | NO |
| wait/io/file/aria/control | YES | YES |
| wait/io/file/aria/MAD | YES | YES |
| wait/io/file/aria/MAI | YES | YES |
| wait/io/file/aria/translog | YES | YES |
| wait/io/file/csv/data | YES | YES |
| wait/io/file/csv/metadata | YES | YES |
| wait/io/file/csv/update | YES | YES |
| wait/io/file/innodb/innodb_data_file | YES | YES |
| wait/io/file/innodb/innodb_log_file | YES | YES |
| wait/io/file/innodb/innodb_temp_file | YES | YES |
| wait/io/file/myisam/data_tmp | YES | YES |
| wait/io/file/myisam/dfile | YES | YES |
| wait/io/file/myisam/kfile | YES | YES |
| wait/io/file/myisam/log | YES | YES |
| wait/io/file/myisammrg/MRG | YES | YES |
| wait/io/file/mysys/charset | YES | YES |
| wait/io/file/mysys/cnf | YES | YES |
| wait/io/file/partition/ha_partition::parfile | YES | YES |
| wait/io/file/sql/binlog | YES | YES |
| wait/io/file/sql/binlog_cache | YES | YES |
| wait/io/file/sql/binlog_index | YES | YES |
| wait/io/file/sql/binlog_index_cache | YES | YES |
| wait/io/file/sql/binlog_state | YES | YES |
| wait/io/file/sql/casetest | YES | YES |
| wait/io/file/sql/dbopt | YES | YES |
| wait/io/file/sql/des_key_file | YES | YES |
| wait/io/file/sql/ERRMSG | YES | YES |
| wait/io/file/sql/file_parser | YES | YES |
| wait/io/file/sql/FRM | YES | YES |
| wait/io/file/sql/global_ddl_log | YES | YES |
| wait/io/file/sql/init | YES | YES |
| wait/io/file/sql/io_cache | YES | YES |
| wait/io/file/sql/load | YES | YES |
| wait/io/file/sql/LOAD_FILE | YES | YES |
| wait/io/file/sql/log_event_data | YES | YES |
| wait/io/file/sql/log_event_info | YES | YES |
| wait/io/file/sql/map | YES | YES |
| wait/io/file/sql/master_info | YES | YES |
| wait/io/file/sql/misc | YES | YES |
| wait/io/file/sql/partition_ddl_log | YES | YES |
| wait/io/file/sql/pid | YES | YES |
| wait/io/file/sql/query_log | YES | YES |
| wait/io/file/sql/relaylog | YES | YES |
| wait/io/file/sql/relaylog_cache | YES | YES |
| wait/io/file/sql/relaylog_index | YES | YES |
| wait/io/file/sql/relaylog_index_cache | YES | YES |
| wait/io/file/sql/relay_log_info | YES | YES |
| wait/io/file/sql/select_to_file | YES | YES |
| wait/io/file/sql/send_file | YES | YES |
| wait/io/file/sql/slow_log | YES | YES |
| wait/io/file/sql/tclog | YES | YES |
| wait/io/file/sql/trigger | YES | YES |
| wait/io/file/sql/trigger_name | YES | YES |
| wait/io/file/sql/wsrep_gra_log | YES | YES |
| wait/io/socket/sql/client_connection | NO | NO |
| wait/io/socket/sql/server_tcpip_socket | NO | NO |
| wait/io/socket/sql/server_unix_socket | NO | NO |
| wait/io/table/sql/handler | YES | YES |
| wait/lock/metadata/sql/mdl | NO | NO |
| wait/lock/table/sql/handler | YES | YES |
| wait/synch/cond/aria/BITMAP::bitmap_cond | NO | NO |
| wait/synch/cond/aria/COND_soft_sync | NO | NO |
| wait/synch/cond/aria/SERVICE_THREAD_CONTROL::COND_control | NO | NO |
| wait/synch/cond/aria/SHARE::key_del_cond | NO | NO |
| wait/synch/cond/aria/SORT_INFO::cond | NO | NO |
| wait/synch/cond/aria/TRANSLOG_BUFFER::prev_sent_to_disk_cond | NO | NO |
| wait/synch/cond/aria/TRANSLOG_BUFFER::waiting_filling_buffer | NO | NO |
| wait/synch/cond/aria/TRANSLOG_DESCRIPTOR::log_flush_cond | NO | NO |
| wait/synch/cond/aria/TRANSLOG_DESCRIPTOR::new_goal_cond | NO | NO |
| wait/synch/cond/innodb/commit_cond | NO | NO |
| wait/synch/cond/myisam/MI_SORT_INFO::cond | NO | NO |
| wait/synch/cond/mysys/COND_alarm | NO | NO |
| wait/synch/cond/mysys/COND_timer | NO | NO |
| wait/synch/cond/mysys/IO_CACHE_SHARE::cond | NO | NO |
| wait/synch/cond/mysys/IO_CACHE_SHARE::cond_writer | NO | NO |
| wait/synch/cond/mysys/my_thread_var::suspend | NO | NO |
| wait/synch/cond/mysys/THR_COND_threads | NO | NO |
| wait/synch/cond/mysys/WT_RESOURCE::cond | NO | NO |
| wait/synch/cond/sql/Ack_receiver::cond | NO | NO |
| wait/synch/cond/sql/COND_binlog_send | NO | NO |
| wait/synch/cond/sql/COND_flush_thread_cache | NO | NO |
| wait/synch/cond/sql/COND_group_commit_orderer | NO | NO |
| wait/synch/cond/sql/COND_gtid_ignore_duplicates | NO | NO |
| wait/synch/cond/sql/COND_manager | NO | NO |
| wait/synch/cond/sql/COND_parallel_entry | NO | NO |
| wait/synch/cond/sql/COND_prepare_ordered | NO | NO |
| wait/synch/cond/sql/COND_queue_state | NO | NO |
| wait/synch/cond/sql/COND_rpl_thread | NO | NO |
| wait/synch/cond/sql/COND_rpl_thread_pool | NO | NO |
| wait/synch/cond/sql/COND_rpl_thread_queue | NO | NO |
| wait/synch/cond/sql/COND_rpl_thread_stop | NO | NO |
| wait/synch/cond/sql/COND_server_started | NO | NO |
| wait/synch/cond/sql/COND_slave_background | NO | NO |
| wait/synch/cond/sql/COND_start_thread | NO | NO |
| wait/synch/cond/sql/COND_thread_cache | NO | NO |
| wait/synch/cond/sql/COND_wait_gtid | NO | NO |
| wait/synch/cond/sql/COND_wsrep_donor_monitor | NO | NO |
| wait/synch/cond/sql/COND_wsrep_gtid_wait_upto | NO | NO |
| wait/synch/cond/sql/COND_wsrep_joiner_monitor | NO | NO |
| wait/synch/cond/sql/COND_wsrep_ready | NO | NO |
| wait/synch/cond/sql/COND_wsrep_replaying | NO | NO |
| wait/synch/cond/sql/COND_wsrep_sst | NO | NO |
| wait/synch/cond/sql/COND_wsrep_sst_init | NO | NO |
| wait/synch/cond/sql/COND_wsrep_wsrep_slave_threads | NO | NO |
| wait/synch/cond/sql/Delayed_insert::cond | NO | NO |
| wait/synch/cond/sql/Delayed_insert::cond_client | NO | NO |
| wait/synch/cond/sql/Event_scheduler::COND_state | NO | NO |
| wait/synch/cond/sql/Item_func_sleep::cond | NO | NO |
| wait/synch/cond/sql/Master_info::data_cond | NO | NO |
| wait/synch/cond/sql/Master_info::sleep_cond | NO | NO |
| wait/synch/cond/sql/Master_info::start_cond | NO | NO |
| wait/synch/cond/sql/Master_info::stop_cond | NO | NO |
| wait/synch/cond/sql/MDL_context::COND_wait_status | NO | NO |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_binlog_background_thread | NO | NO |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_binlog_background_thread_end | NO | NO |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_bin_log_updated | NO | NO |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_queue_busy | NO | NO |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_relay_log_updated | NO | NO |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_xid_list | NO | NO |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_bin_log_updated | NO | NO |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_queue_busy | NO | NO |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_relay_log_updated | NO | NO |
| wait/synch/cond/sql/PAGE::cond | NO | NO |
| wait/synch/cond/sql/Query_cache::COND_cache_status_changed | NO | NO |
| wait/synch/cond/sql/Relay_log_info::data_cond | NO | NO |
| wait/synch/cond/sql/Relay_log_info::log_space_cond | NO | NO |
| wait/synch/cond/sql/Relay_log_info::start_cond | NO | NO |
| wait/synch/cond/sql/Relay_log_info::stop_cond | NO | NO |
| wait/synch/cond/sql/Rpl_group_info::sleep_cond | NO | NO |
| wait/synch/cond/sql/show_explain | NO | NO |
| wait/synch/cond/sql/TABLE_SHARE::cond | NO | NO |
| wait/synch/cond/sql/TABLE_SHARE::COND_rotation | NO | NO |
| wait/synch/cond/sql/TABLE_SHARE::tdc.COND_release | NO | NO |
| wait/synch/cond/sql/TC_LOG_MMAP::COND_active | NO | NO |
| wait/synch/cond/sql/TC_LOG_MMAP::COND_pool | NO | NO |
| wait/synch/cond/sql/TC_LOG_MMAP::COND_queue_busy | NO | NO |
| wait/synch/cond/sql/THD::COND_wakeup_ready | NO | NO |
| wait/synch/cond/sql/THD::COND_wsrep_thd | NO | NO |
| wait/synch/cond/sql/User_level_lock::cond | NO | NO |
| wait/synch/cond/sql/wait_for_commit::COND_wait_commit | NO | NO |
| wait/synch/cond/sql/wsrep_sst_thread | NO | NO |
| wait/synch/mutex/aria/LOCK_soft_sync | NO | NO |
| wait/synch/mutex/aria/LOCK_trn_list | NO | NO |
| wait/synch/mutex/aria/PAGECACHE::cache_lock | NO | NO |
| wait/synch/mutex/aria/SERVICE_THREAD_CONTROL::LOCK_control | NO | NO |
| wait/synch/mutex/aria/SHARE::bitmap::bitmap_lock | NO | NO |
| wait/synch/mutex/aria/SHARE::close_lock | NO | NO |
| wait/synch/mutex/aria/SHARE::intern_lock | NO | NO |
| wait/synch/mutex/aria/SHARE::key_del_lock | NO | NO |
| wait/synch/mutex/aria/SORT_INFO::mutex | NO | NO |
| wait/synch/mutex/aria/THR_LOCK_maria | NO | NO |
| wait/synch/mutex/aria/TRANSLOG_BUFFER::mutex | NO | NO |
| wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::dirty_buffer_mask_lock | NO | NO |
| wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::file_header_lock | NO | NO |
| wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::log_flush_lock | NO | NO |
| wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::purger_lock | NO | NO |
| wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::sent_to_disk_lock | NO | NO |
| wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::unfinished_files_lock | NO | NO |
| wait/synch/mutex/aria/TRN::state_lock | NO | NO |
| wait/synch/mutex/csv/tina | NO | NO |
| wait/synch/mutex/csv/TINA_SHARE::mutex | NO | NO |
| wait/synch/mutex/innodb/buf_dblwr_mutex | NO | NO |
| wait/synch/mutex/innodb/buf_pool_mutex | NO | NO |
| wait/synch/mutex/innodb/commit_cond_mutex | NO | NO |
| wait/synch/mutex/innodb/dict_foreign_err_mutex | NO | NO |
| wait/synch/mutex/innodb/dict_sys_mutex | NO | NO |
| wait/synch/mutex/innodb/fil_system_mutex | NO | NO |
| wait/synch/mutex/innodb/flush_list_mutex | NO | NO |
| wait/synch/mutex/innodb/fts_delete_mutex | NO | NO |
| wait/synch/mutex/innodb/fts_doc_id_mutex | NO | NO |
| wait/synch/mutex/innodb/ibuf_bitmap_mutex | NO | NO |
| wait/synch/mutex/innodb/ibuf_mutex | NO | NO |
| wait/synch/mutex/innodb/ibuf_pessimistic_insert_mutex | NO | NO |
| wait/synch/mutex/innodb/lock_mutex | NO | NO |
| wait/synch/mutex/innodb/lock_wait_mutex | NO | NO |
| wait/synch/mutex/innodb/log_flush_order_mutex | NO | NO |
| wait/synch/mutex/innodb/log_sys_mutex | NO | NO |
| wait/synch/mutex/innodb/noredo_rseg_mutex | NO | NO |
| wait/synch/mutex/innodb/page_zip_stat_per_index_mutex | NO | NO |
| wait/synch/mutex/innodb/pending_checkpoint_mutex | NO | NO |
| wait/synch/mutex/innodb/purge_sys_pq_mutex | NO | NO |
| wait/synch/mutex/innodb/recalc_pool_mutex | NO | NO |
| wait/synch/mutex/innodb/recv_sys_mutex | NO | NO |
| wait/synch/mutex/innodb/redo_rseg_mutex | NO | NO |
| wait/synch/mutex/innodb/rtr_active_mutex | NO | NO |
| wait/synch/mutex/innodb/rtr_match_mutex | NO | NO |
| wait/synch/mutex/innodb/rtr_path_mutex | NO | NO |
| wait/synch/mutex/innodb/rw_lock_list_mutex | NO | NO |
| wait/synch/mutex/innodb/srv_innodb_monitor_mutex | NO | NO |
| wait/synch/mutex/innodb/srv_misc_tmpfile_mutex | NO | NO |
| wait/synch/mutex/innodb/srv_monitor_file_mutex | NO | NO |
| wait/synch/mutex/innodb/srv_threads_mutex | NO | NO |
| wait/synch/mutex/innodb/trx_mutex | NO | NO |
| wait/synch/mutex/innodb/trx_pool_manager_mutex | NO | NO |
| wait/synch/mutex/innodb/trx_pool_mutex | NO | NO |
| wait/synch/mutex/innodb/trx_sys_mutex | NO | NO |
| wait/synch/mutex/myisam/MI_CHECK::print_msg | NO | NO |
| wait/synch/mutex/myisam/MI_SORT_INFO::mutex | NO | NO |
| wait/synch/mutex/myisam/MYISAM_SHARE::intern_lock | NO | NO |
| wait/synch/mutex/myisammrg/MYRG_INFO::mutex | NO | NO |
| wait/synch/mutex/mysys/BITMAP::mutex | NO | NO |
| wait/synch/mutex/mysys/IO_CACHE::append_buffer_lock | NO | NO |
| wait/synch/mutex/mysys/IO_CACHE::SHARE_mutex | NO | NO |
| wait/synch/mutex/mysys/KEY_CACHE::cache_lock | NO | NO |
| wait/synch/mutex/mysys/LOCK_alarm | NO | NO |
| wait/synch/mutex/mysys/LOCK_timer | NO | NO |
| wait/synch/mutex/mysys/LOCK_uuid_generator | NO | NO |
| wait/synch/mutex/mysys/my_thread_var::mutex | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK::mutex | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_charset | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_heap | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_lock | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_malloc | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_myisam | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_myisam_mmap | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_net | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_open | NO | NO |
| wait/synch/mutex/mysys/THR_LOCK_threads | NO | NO |
| wait/synch/mutex/mysys/TMPDIR_mutex | NO | NO |
| wait/synch/mutex/partition/Partition_share::auto_inc_mutex | NO | NO |
| wait/synch/mutex/sql/Ack_receiver::mutex | NO | NO |
| wait/synch/mutex/sql/Cversion_lock | NO | NO |
| wait/synch/mutex/sql/Delayed_insert::mutex | NO | NO |
| wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state | NO | NO |
| wait/synch/mutex/sql/gtid_waiting::LOCK_gtid_waiting | NO | NO |
| wait/synch/mutex/sql/hash_filo::lock | NO | NO |
| wait/synch/mutex/sql/HA_DATA_PARTITION::LOCK_auto_inc | NO | NO |
| wait/synch/mutex/sql/LOCK_active_mi | NO | NO |
| wait/synch/mutex/sql/LOCK_after_binlog_sync | NO | NO |
| wait/synch/mutex/sql/LOCK_audit_mask | NO | NO |
| wait/synch/mutex/sql/LOCK_binlog | NO | NO |
| wait/synch/mutex/sql/LOCK_binlog_state | NO | NO |
| wait/synch/mutex/sql/LOCK_commit_ordered | NO | NO |
| wait/synch/mutex/sql/LOCK_crypt | NO | NO |
| wait/synch/mutex/sql/LOCK_delayed_create | NO | NO |
| wait/synch/mutex/sql/LOCK_delayed_insert | NO | NO |
| wait/synch/mutex/sql/LOCK_delayed_status | NO | NO |
| wait/synch/mutex/sql/LOCK_des_key_file | NO | NO |
| wait/synch/mutex/sql/LOCK_error_log | NO | NO |
| wait/synch/mutex/sql/LOCK_error_messages | NO | NO |
| wait/synch/mutex/sql/LOCK_event_queue | NO | NO |
| wait/synch/mutex/sql/LOCK_gdl | NO | NO |
| wait/synch/mutex/sql/LOCK_global_index_stats | NO | NO |
| wait/synch/mutex/sql/LOCK_global_system_variables | NO | NO |
| wait/synch/mutex/sql/LOCK_global_table_stats | NO | NO |
| wait/synch/mutex/sql/LOCK_global_user_client_stats | NO | NO |
| wait/synch/mutex/sql/LOCK_item_func_sleep | NO | NO |
| wait/synch/mutex/sql/LOCK_load_client_plugin | NO | NO |
| wait/synch/mutex/sql/LOCK_manager | NO | NO |
| wait/synch/mutex/sql/LOCK_parallel_entry | NO | NO |
| wait/synch/mutex/sql/LOCK_plugin | NO | NO |
| wait/synch/mutex/sql/LOCK_prepared_stmt_count | NO | NO |
| wait/synch/mutex/sql/LOCK_prepare_ordered | NO | NO |
| wait/synch/mutex/sql/LOCK_rpl_semi_sync_master_enabled | NO | NO |
| wait/synch/mutex/sql/LOCK_rpl_status | NO | NO |
| wait/synch/mutex/sql/LOCK_rpl_thread | NO | NO |
| wait/synch/mutex/sql/LOCK_rpl_thread_pool | NO | NO |
| wait/synch/mutex/sql/LOCK_server_started | NO | NO |
| wait/synch/mutex/sql/LOCK_slave_background | NO | NO |
| wait/synch/mutex/sql/LOCK_slave_state | NO | NO |
| wait/synch/mutex/sql/LOCK_start_thread | NO | NO |
| wait/synch/mutex/sql/LOCK_stats | NO | NO |
| wait/synch/mutex/sql/LOCK_status | NO | NO |
| wait/synch/mutex/sql/LOCK_system_variables_hash | NO | NO |
| wait/synch/mutex/sql/LOCK_table_cache | NO | NO |
| wait/synch/mutex/sql/LOCK_thread_cache | NO | NO |
| wait/synch/mutex/sql/LOCK_thread_id | NO | NO |
| wait/synch/mutex/sql/LOCK_unused_shares | NO | NO |
| wait/synch/mutex/sql/LOCK_user_conn | NO | NO |
| wait/synch/mutex/sql/LOCK_uuid_short_generator | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_cluster_config | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_config_state | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_desync | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_donor_monitor | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_group_commit | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_gtid_wait_upto | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_joiner_monitor | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_ready | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_replaying | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_slave_threads | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_SR_pool | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_SR_store | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_sst | NO | NO |
| wait/synch/mutex/sql/LOCK_wsrep_sst_init | NO | NO |
| wait/synch/mutex/sql/LOG::LOCK_log | NO | NO |
| wait/synch/mutex/sql/Master_info::data_lock | NO | NO |
| wait/synch/mutex/sql/Master_info::run_lock | NO | NO |
| wait/synch/mutex/sql/Master_info::sleep_lock | NO | NO |
| wait/synch/mutex/sql/Master_info::start_stop_lock | NO | NO |
| wait/synch/mutex/sql/MDL_wait::LOCK_wait_status | NO | NO |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_background_thread | NO | NO |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_end_pos | NO | NO |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_index | NO | NO |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_xid_list | NO | NO |
| wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_binlog_end_pos | NO | NO |
| wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index | NO | NO |
| wait/synch/mutex/sql/PAGE::lock | NO | NO |
| wait/synch/mutex/sql/Query_cache::structure_guard_mutex | NO | NO |
| wait/synch/mutex/sql/Relay_log_info::data_lock | NO | NO |
| wait/synch/mutex/sql/Relay_log_info::log_space_lock | NO | NO |
| wait/synch/mutex/sql/Relay_log_info::run_lock | NO | NO |
| wait/synch/mutex/sql/Rpl_group_info::sleep_lock | NO | NO |
| wait/synch/mutex/sql/Slave_reporting_capability::err_lock | NO | NO |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_ha_data | NO | NO |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_rotation | NO | NO |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_share | NO | NO |
| wait/synch/mutex/sql/TABLE_SHARE::tdc.LOCK_table_share | NO | NO |
| wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_active | NO | NO |
| wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_pending_checkpoint | NO | NO |
| wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_pool | NO | NO |
| wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_sync | NO | NO |
| wait/synch/mutex/sql/THD::LOCK_thd_data | NO | NO |
| wait/synch/mutex/sql/THD::LOCK_thd_kill | NO | NO |
| wait/synch/mutex/sql/THD::LOCK_wakeup_ready | NO | NO |
| wait/synch/mutex/sql/tz_LOCK | NO | NO |
| wait/synch/mutex/sql/wait_for_commit::LOCK_wait_commit | NO | NO |
| wait/synch/mutex/sql/wsrep_sst_thread | NO | NO |
| wait/synch/rwlock/aria/KEYINFO::root_lock | NO | NO |
| wait/synch/rwlock/aria/SHARE::mmap_lock | NO | NO |
| wait/synch/rwlock/aria/TRANSLOG_DESCRIPTOR::open_files_lock | NO | NO |
| wait/synch/rwlock/myisam/MYISAM_SHARE::key_root_lock | NO | NO |
| wait/synch/rwlock/myisam/MYISAM_SHARE::mmap_lock | NO | NO |
| wait/synch/rwlock/mysys/SAFE_HASH::mutex | NO | NO |
| wait/synch/rwlock/proxy_proto/rwlock | NO | NO |
| wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock | NO | NO |
| wait/synch/rwlock/sql/LOCK_all_status_vars | NO | NO |
| wait/synch/rwlock/sql/LOCK_dboptions | NO | NO |
| wait/synch/rwlock/sql/LOCK_grant | NO | NO |
| wait/synch/rwlock/sql/LOCK_SEQUENCE | NO | NO |
| wait/synch/rwlock/sql/LOCK_ssl_refresh | NO | NO |
| wait/synch/rwlock/sql/LOCK_system_variables_hash | NO | NO |
| wait/synch/rwlock/sql/LOCK_sys_init_connect | NO | NO |
| wait/synch/rwlock/sql/LOCK_sys_init_slave | NO | NO |
| wait/synch/rwlock/sql/LOGGER::LOCK_logger | NO | NO |
| wait/synch/rwlock/sql/MDL_context::LOCK_waiting_for | NO | NO |
| wait/synch/rwlock/sql/MDL_lock::rwlock | NO | NO |
| wait/synch/rwlock/sql/Query_cache_query::lock | NO | NO |
| wait/synch/rwlock/sql/TABLE_SHARE::LOCK_stat_serial | NO | NO |
| wait/synch/rwlock/sql/THD_list::lock | NO | NO |
| wait/synch/rwlock/sql/THR_LOCK_servers | NO | NO |
| wait/synch/rwlock/sql/THR_LOCK_udf | NO | NO |
| wait/synch/rwlock/sql/Vers_field_stats::lock | NO | NO |
| wait/synch/sxlock/innodb/btr_search_latch | NO | NO |
| wait/synch/sxlock/innodb/dict_operation_lock | NO | NO |
| wait/synch/sxlock/innodb/fil_space_latch | NO | NO |
| wait/synch/sxlock/innodb/fts_cache_init_rw_lock | NO | NO |
| wait/synch/sxlock/innodb/fts_cache_rw_lock | NO | NO |
| wait/synch/sxlock/innodb/index_online_log | NO | NO |
| wait/synch/sxlock/innodb/index_tree_rw_lock | NO | NO |
| wait/synch/sxlock/innodb/trx_i_s_cache_lock | NO | NO |
| wait/synch/sxlock/innodb/trx_purge_latch | NO | NO |
+--------------------------------------------------------------------------------+---------+-------+
996 rows in set (0.005 sec)