Performance Schema Tables

Tables that are part of the MariaDB Performance Schema, a feature for monitoring the performance of your MariaDB server.

Title	Description
List of Performance Schema Tables	List and short description of all performance_schema tables
Performance Schema accounts Table	Account connection information.
Performance Schema cond_instances Table	List of instrumented condition objects.
Performance Schema events_stages_current Table	Current stage events.
Performance Schema events_stages_history Table	Most recent stage events per thread.
Performance Schema events_stages_history_long Table	Most recent completed stage events.
Performance Schema events_stages_summary_by_account_by_event_name Table	Stage events, summarized by account and event name.
Performance Schema events_stages_summary_by_host_by_event_name Table	Stage events summarized by host and event name.
Performance Schema events_stages_summary_by_thread_by_event_name Table	Stage events summarized by thread and event name.
Performance Schema events_stages_summary_by_user_by_event_name Table	Stage events summarized by user and event name.
Performance Schema events_stages_summary_global_by_event_name Table	Event summaries.
Performance Schema events_statements_current Table	Current statement events.
Performance Schema events_statements_history Table	Most recent statement events per thread
Performance Schema events_statements_history_long Table	Most recent statement events.
Performance Schema events_statements_summary_by_account_by_event_name Table	Statement events summarized by account and event name.
Performance Schema events_statements_summary_by_digest Table	Statement events summarized by schema and digest.
Performance Schema events_statements_summary_by_host_by_event_name Table	Statement events summarized by host and event name.
Performance Schema events_statements_summary_by_program Table	MariaDB starting with 10.5.2
Performance Schema events_statements_summary_by_thread_by_event_name Table	Statement events summarized by thread and event name.
Performance Schema events_statements_summary_by_user_by_event_name Table	Statement events summarized by user and event name.
Performance Schema events_statements_summary_global_by_event_name Table	Statement events summarized by event name.
Performance Schema events_transactions_current Table	Current transaction events for each thread.
Performance Schema events_transactions_history Table	Most recent completed transaction events for each thread.
Performance Schema events_transactions_history_long Table	Most recent completed transaction events that have ended globally.
Performance Schema events_transactions_summary_by_account_by_event_name Table	Transaction events aggregated by account and event name.
Performance Schema events_transactions_summary_by_host_by_event_name Table	Transaction events aggregated by host and event name.
Performance Schema events_transactions_summary_by_thread_by_event_name Table	Transaction events aggregated by thread and event name.
Performance Schema events_transactions_summary_by_user_by_event_name Table	Transaction events aggregated by user and event name.
Performance Schema events_transactions_summary_global_by_event_name Table	Transaction events aggregated by event name.
Performance Schema events_waits_current Table	Current wait events
Performance Schema events_waits_history Table	Most recent wait events per thread
Performance Schema events_waits_history_long Table	Most recent completed wait events
Performance Schema events_waits_summary_by_account_by_event_name Table	Wait events summarized by account and event name.
Performance Schema events_waits_summary_by_host_by_event_name Table	Wait events summarized by host and event name.
Performance Schema events_waits_summary_by_instance Table	Wait events summarized by instance
Performance Schema events_waits_summary_by_thread_by_event_name Table	Wait events summarized by thread and event name.
Performance Schema events_waits_summary_by_user_by_event_name Table	Wait events summarized by user and event name.
Performance Schema events_waits_summary_global_by_event_name Table	Wait events summarized by event name.
Performance Schema file_instances Table	List of file instruments
Performance Schema file_summary_by_event_name Table	File events summarized by event name
Performance Schema file_summary_by_instance Table	File events summarized by instance
Performance Schema hosts Table	Hosts used to connect to the server.
Performance Schema host_cache Table	Host_cache information.
Performance Schema memory_global_by_event_name Table	Memory usage statistics aggregated by event and event.
Performance Schema memory_summary_by_account_by_event_name Table	Memory usage statistics aggregated by account and event.
Performance Schema memory_summary_by_host_by_event_name Table	Memory usage statistics aggregated by host and event.
Performance Schema memory_summary_by_thread_by_event_name Table	Memory usage statistics aggregated by thread and event.
Performance Schema memory_summary_by_user_by_event_name Table	Memory usage statistics aggregated by user and event.
Performance Schema metadata_locks Table	Metadata lock information.
Performance Schema mutex_instances Table	Seen mutexes
Performance Schema objects_summary_global_by_type Table	Aggregates object wait events.
Performance Schema performance_timers Table	Available event timers
Performance Schema prepared_statements_instances Table	Aggregated statistics of prepared statements.
Performance Schema replication_applier_configuration Table	Configuration settings affecting slave transactions.
Performance Schema replication_applier_status Table	Information about the general transaction execution status on the slave.
Performance Schema replication_applier_status_by_worker Table	Slave worker thread specific information.
Performance Schema rwlock_instances Table	Seen read-write locks
Performance Schema session_account_connect_attrs Table	Connection attributes for the current session.
Performance Schema session_connect_attrs Table	Connection attributes for all sessions.
Performance Schema setup_actors Table	Determines whether monitoring is enabled for host/user combinations.
Performance Schema setup_consumers Table	Lists the types of consumers for which event information is available
Performance Schema setup_instruments Table	List of instrumented object classes
Performance Schema setup_objects Table	Which objects are monitored.
Performance Schema setup_timers Table	Currently selected event timers
Performance Schema socket_instances Table	Active server connections.
Performance Schema socket_summary_by_event_name Table	Aggregates timer and byte count statistics for all socket I/O operations by socket instrument.
Performance Schema socket_summary_by_instance Table	Aggregates timer and byte count statistics for all socket I/O operations by socket instance.
Performance Schema table_io_waits_summary_by_index_usage Table	Table I/O waits by index.
Performance Schema table_io_waits_summary_by_table Table	Table I/O waits by table.
Performance Schema table_lock_waits_summary_by_table Table	Table lock waits by table.
Performance Schema threads Table	Each server thread is represented as a row in the threads table. The thread...
Performance Schema users Table	User connection information.

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.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-tables/