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/