W3cubDocs

List of Performance Schema Tables

MariaDB starting with 5.5

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.

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/list-of-performance-schema-tables/