List of Performance Schema Tables

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

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_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.
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.
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 slave transactions.
replication_applier_statusGeneral transaction execution status on the slave.
rwlock_instancesSeen read-write locks.
session_account_connect_attrsCurrent session connection attributes.
session_connect_attrsAll session connection attributes.
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.
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.
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.