List of Performance Schema Tables

Below is a list of all Performance Schema tables as well as a brief description of each of them.

TableDescription
accountsClient account connection statistics.
cond_instancesSynchronization object instances.
events_stages_currentCurrent stage events.
events_stages_historyTen most recent stage events per thread.
events_stages_history_longTen thousand most recent stage events.
events_stages_summary_by_account_by_event_nameSummarized stage events per account and event name.
events_stages_summary_by_host_by_event_nameSummarized stage events per host and event name.
events_stages_summary_by_thread_by_event_nameSummarized stage events per thread and event name.
events_stages_summary_by_user_by_event_nameSummarized stage events per user name and event name.
events_stages_summary_global_by_event_nameSummarized stage events per event name.
events_statements_currentCurrent statement events.
events_statements_historyTen most recent events per thread.
events_statements_history_longTen thousand most recent stage events.
events_statements_summary_by_account_by_event_nameSummarized statement events per account and event name.
events_statements_summary_by_digestSummarized statement events by scheme and digest.
events_statements_summary_by_host_by_event_nameSummarized statement events by host and event name.
events_statements_summary_by_programEvents for a particular stored program.
events_statements_summary_by_thread_by_event_nameSummarized statement events by thread and event name.
events_statements_summary_by_user_by_event_nameSummarized statement events by user and event name.
events_statements_summary_global_by_event_nameSummarized statement events by event name.
events_transactions_currentCurrent transaction events for each thread.
events_transactions_historyMost recent completed transaction events for each thread.
events_transactions_history_longMost recent completed transaction events that have ended globally.
events_transactions_summary_by_account_by_event_nameTransaction events aggregated by account and event.
events_transactions_summary_by_host_by_event_nameTransaction events aggregated by host and event..
events_transactions_summary_by_thread_by_event_nameTransaction events aggregated by thread and event..
events_transactions_summary_by_user_by_event_nameTransaction events aggregated by user and event..
events_transactions_summary_global_by_event_nameTransaction events aggregated by event name.
events_waits_currentCurrent wait events.
events_waits_historyTen most recent wait events per thread.
events_waits_history_longTen thousand most recent wait events per thread.
events_waits_summary_by_account_by_event_nameSummarized wait events by account and event name.
events_waits_summary_by_host_by_event_nameSummarized wait events by host and event name.
events_waits_summary_by_instanceSummarized wait events by instance.
events_waits_summary_by_thread_by_event_nameSummarized wait events by thread and event name.
events_waits_summary_by_user_by_event_nameSummarized wait events by user and event name.
events_waits_summary_global_by_event_nameSummarized wait events by event name.
file_instancesSeen files.
file_summary_by_event_nameFile events summarized by event name.
file_summary_by_instanceFile events summarized by instance.
global_statusGlobal status variables and values.
host_cacheHost and IP information.
hostsConnections by host.
memory_summary_by_account_by_event_nameMemory usage statistics aggregated by account and event.
memory_summary_by_host_by_event_nameMemory usage statistics aggregated by host. and event.
memory_summary_by_thread_by_event_nameMemory usage statistics aggregated by thread and event..
memory_summary_by_user_by_event_nameMemory usage statistics aggregated by user and event..
memory_summary_global_by_event_nameMemory usage statistics aggregated by event.
metadata_locksMetadata locks.
mutex_instancesSeen mutexes.
objects_summary_global_by_typeObject wait events.
performance_timersAvailable event timers.
prepared_statements_instancesAggregate statistics of prepared statements.
replication_applier_configurationConfiguration settings affecting replica transactions.
replication_applier_statusGeneral transaction execution status on the replica.
replication_applier_status_by_coordinatorCoordinator thread specific information.
replication_applier_status_by_workerReplica worker thread specific information.
replication_connection_configurationRreplica's configuration settings used for connecting to the primary.
rwlock_instancesSeen read-write locks.
session_account_connect_attrsCurrent session connection attributes.
session_connect_attrsAll session connection attributes.
session_statusSession status variables and values.
setup_actorsDetails on foreground thread monitoring.
setup_consumersConsumers for which event information is stored.
setup_instrumentsInstrumented objects for which events are collected.
setup_objectsObjects to be monitored.
setup_timersCurrently selected event timers.
socket_instancesActive connections.
socket_summary_by_event_nameTimer and byte count statistics by socket instrument.
socket_summary_by_instanceTimer and byte count statistics by socket instance.
status_by_accountStatus variable info by host/user account.
status_by_hostStatus variable info by host.
status_by_threadStatus variable info about active foreground threads.
status_by_userStatus variable info by user.
table_handlesTable lock information.
table_io_waits_summary_by_index_usageAggregate table I/O wait events by index.
table_io_waits_summary_by_tableAggregate table I/O wait events by table.
table_lock_waits_summary_by_tableAggregate table lock wait events by table.
threadsServer thread information.
user_variables_by_threadUser-defined variables by thread.
usersConnection statistics by user.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.