List of Performance Schema Tables

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_program`	Events for a particular stored program.
`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_transactions_current`	Current transaction events for each thread.
`events_transactions_history`	Most recent completed transaction events for each thread.
`events_transactions_history_long`	Most recent completed transaction events that have ended globally.
`events_transactions_summary_by_account_by_event_name`	Transaction events aggregated by account and event.
`events_transactions_summary_by_host_by_event_name`	Transaction events aggregated by host and event..
`events_transactions_summary_by_thread_by_event_name`	Transaction events aggregated by thread and event..
`events_transactions_summary_by_user_by_event_name`	Transaction events aggregated by user and event..
`events_transactions_summary_global_by_event_name`	Transaction events aggregated 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.
`global_status`	Global status variables and values.
`host_cache`	Host and IP information.
`hosts`	Connections by host.
`memory_summary_by_account_by_event_name`	Memory usage statistics aggregated by account and event.
`memory_summary_by_host_by_event_name`	Memory usage statistics aggregated by host. and event.
`memory_summary_by_thread_by_event_name`	Memory usage statistics aggregated by thread and event..
`memory_summary_by_user_by_event_name`	Memory usage statistics aggregated by user and event..
`memory_summary_global_by_event_name`	Memory usage statistics aggregated by event.
`metadata_locks`	Metadata locks.
`mutex_instances`	Seen mutexes.
`objects_summary_global_by_type`	Object wait events.
`performance_timers`	Available event timers.
`prepared_statements_instances`	Aggregate statistics of prepared statements.
`replication_applier_configuration`	Configuration settings affecting replica transactions.
`replication_applier_status`	General transaction execution status on the replica.
`replication_applier_status_by_coordinator`	Coordinator thread specific information.
`replication_applier_status_by_worker`	Replica worker thread specific information.
`replication_connection_configuration`	Rreplica's configuration settings used for connecting to the primary.
`rwlock_instances`	Seen read-write locks.
`session_account_connect_attrs`	Current session connection attributes.
`session_connect_attrs`	All session connection attributes.
`session_status`	Session status variables and values.
`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.
`status_by_account`	Status variable info by host/user account.
`status_by_host`	Status variable info by host.
`status_by_thread`	Status variable info about active foreground threads.
`status_by_user`	Status variable info by user.
`table_handles`	Table lock information.
`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.
`user_variables_by_thread`	User-defined variables by thread.
`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.

List of Performance Schema Tables

Products

Services

Pricing

Resources

About Us

Download MariaDB