The Performance Schema was introduced in MariaDB 5.5.
Below is a list of all performance_schema
tables as well as a brief description of each of them.
Table | Description |
---|---|
accounts |
Client account connection statistics. |
cond_instances |
Synchronization object instances. |
events_stages_current |
Current stage events. |
events_stages_history |
Ten most recent stage events per thread. |
events_stages_history_long |
Ten thousand most recent stage events. |
events_stages_summary_by_account_by_event_name |
Summarized stage events per account and event name. |
events_stages_summary_by_host_by_event_name |
Summarized stage events per host and event name. |
events_stages_summary_by_thread_by_event_name |
Summarized stage events per thread and event name. |
events_stages_summary_by_user_by_event_name |
Summarized stage events per user name and event name. |
events_stages_summary_global_by_event_name |
Summarized stage events per event name. |
events_statements_current |
Current statement events. |
events_statements_history |
Ten most recent events per thread. |
events_statements_history_long |
Ten thousand most recent stage events. |
events_statements_summary_by_account_by_event_name |
Summarized statement events per account and event name. |
events_statements_summary_by_digest |
Summarized statement events by scheme and digest. |
events_statements_summary_by_host_by_event_name |
Summarized statement events by host and event name. |
events_statements_summary_by_thread_by_event_name |
Summarized statement events by thread and event name. |
events_statements_summary_by_user_by_event_name |
Summarized statement events by user and event name. |
events_statements_summary_global_by_event_name |
Summarized statement events by event name. |
events_waits_current |
Current wait events. |
events_waits_history |
Ten most recent wait events per thread. |
events_waits_history_long |
Ten thousand most recent wait events per thread. |
events_waits_summary_by_account_by_event_name |
Summarized wait events by account and event name. |
events_waits_summary_by_host_by_event_name |
Summarized wait events by host and event name. |
events_waits_summary_by_instance |
Summarized wait events by instance. |
events_waits_summary_by_thread_by_event_name |
Summarized wait events by thread and event name. |
events_waits_summary_by_user_by_event_name |
Summarized wait events by user and event name. |
events_waits_summary_global_by_event_name |
Summarized wait events by event name. |
file_instances |
Seen files. |
file_summary_by_event_name |
File events summarized by event name. |
file_summary_by_instance |
File events summarized by instance. |
host_cache |
Host and IP information. |
hosts |
Connections by host. |
mutex_instances |
Seen mutexes. |
objects_summary_global_by_type |
Object wait events. |
performance_timers |
Available event timers. |
rwlock_instances |
Seen read-write locks. |
session_account_connect_attrs |
Current session connection attributes. |
session_connect_attrs |
All session connection attributes. |
setup_actors |
Details on foreground thread monitoring. |
setup_consumers |
Consumers for which event information is stored. |
setup_instruments |
Instrumented objects for which events are collected. |
setup_objects |
Objects to be monitored. |
setup_timers |
Currently selected event timers. |
socket_instances |
Active connections. |
socket_summary_by_event_name |
Timer and byte count statistics by socket instrument. |
socket_summary_by_instance |
Timer and byte count statistics by socket instance. |
table_io_waits_summary_by_index_usage |
Aggregate table I/O wait events by index. |
table_io_waits_summary_by_table |
Aggregate table I/O wait events by table. |
table_lock_waits_summary_by_table |
Aggregate table lock wait events by table. |
threads |
Server thread information. |
users |
Connection statistics by user. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/list-of-performance-schema-tables/