W3cubDocs

/MariaDB

Performance Schema

MariaDB starting with 5.5

The Performance Schema was introduced in MariaDB 5.5.

The MariaDB Performance Schema is a feature for monitoring the performance of your MariaDB server.

Title Description
Performance Schema Overview Quick overview of the Performance Schema.
List of Performance Schema Tables List and short description of all performance_schema tables
PERFORMANCE_SCHEMA Storage Engine PERFORMANCE_SCHEMA storage engine, a mechanism for implementing the feature.
Performance Schema System Variables Performance Schema system variables.
Performance Schema Digests Normalized statements with data values removed
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 MariaDB starting with 10.0None Th...
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_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_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 host_cache Table Host_cache information
Performance Schema hosts Table Hosts used to connect to the server
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 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.

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