Performance Schema Tables
Tables that are part of the MariaDB Performance Schema, a feature for monitoring the performance of MariaDB server.
-
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
Summarizes events for a particular stored program. -
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 global_status Table
Status variables and their global values. -
Performance Schema hosts Table
Hosts used to connect to the server. -
Performance Schema host_cache Table
Host_cache information. -
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 memory_summary_global_by_event_name Table
Memory usage statistics aggregated by event 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 replica transactions. -
Performance Schema replication_applier_status Table
Information about the general transaction execution status on the slave. -
Performance Schema replication_applier_status_by_coordinator Table
Coordinator thread status used in multi-threaded replicas to manage multiple workers. -
Performance Schema replication_applier_status_by_worker Table
Slave worker thread specific information. -
Performance Schema replication_connection_configuration Table
Replica configuration settings used for connecting to the primary. -
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 session_status Table
Status variables and their session values. -
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 status_by_account Table
Status variable information by user/host account. -
Performance Schema status_by_host Table
Status variable information by host. -
Performance Schema status_by_thread Table
Status variable information about active foreground threads. -
Performance Schema status_by_user Table
Status variable information by user. -
Performance Schema table_handles Table
Table lock information. -
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. -
Performance Schema users Table
User connection information. -
Performance Schema user_variables_by_thread Table
User-defined variables and the threads that defined them.
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.
