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 |