# List of Performance Schema Tables Below is a list of all [Performance Schema](https://mariadb.com/docs/server/reference/system-tables/performance-schema) tables as well as a brief description of each of them. | Table | Description | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------ | | [accounts](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-accounts-table) | Client account connection statistics. | | [cond\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-cond_instances-table) | Synchronization object instances. | | [events\_stages\_current](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_current-table) | Current stage events. | | [events\_stages\_history](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_history-table) | Ten most recent stage events per thread. | | [events\_stages\_history\_long](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_history_long-table) | Ten thousand most recent stage events. | | [events\_stages\_summary\_by\_account\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_summary_by_account_by_event_name-table) | Summarized stage events per account and event name. | | [events\_stages\_summary\_by\_host\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_summary_by_host_by_event_name-table) | Summarized stage events per host and event name. | | [events\_stages\_summary\_by\_thread\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_summary_by_thread_by_event_name-table) | Summarized stage events per thread and event name. | | [events\_stages\_summary\_by\_user\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_summary_by_user_by_event_name-table) | Summarized stage events per user name and event name. | | [events\_stages\_summary\_global\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_stages_summary_global_by_event_name-table) | Summarized stage events per event name. | | [events\_statements\_current](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_current-table) | Current statement events. | | [events\_statements\_history](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_history-table) | Ten most recent events per thread. | | [events\_statements\_history\_long](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_history_long-table) | Ten thousand most recent stage events. | | [events\_statements\_summary\_by\_account\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_summary_by_account_by_event_name-table) | Summarized statement events per account and event name. | | [events\_statements\_summary\_by\_digest](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_summary_by_digest-table) | Summarized statement events by scheme and digest. | | [events\_statements\_summary\_by\_host\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_summary_by_host_by_event_name-table) | Summarized statement events by host and event name. | | [events\_statements\_summary\_by\_program](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_summary_by_program-table) | Events for a particular stored program. | | [events\_statements\_summary\_by\_thread\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_summary_by_thread_by_event_name-table) | Summarized statement events by thread and event name. | | [events\_statements\_summary\_by\_user\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_summary_by_user_by_event_name-table) | Summarized statement events by user and event name. | | [events\_statements\_summary\_global\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_statements_summary_global_by_event_name-table) | Summarized statement events by event name. | | [events\_transactions\_current](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_transactions_current-table) | Current transaction events for each thread. | | [events\_transactions\_history](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_transactions_history-table) | Most recent completed transaction events for each thread. | | [events\_transactions\_history\_long](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_transactions_history_long-table) | Most recent completed transaction events that have ended globally. | | [events\_transactions\_summary\_by\_account\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_transactions_current-table) | Transaction events aggregated by account and event. | | [events\_transactions\_summary\_by\_host\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_transactions_summary_by_host_by_event_name-table) | Transaction events aggregated by host and event.. | | [events\_transactions\_summary\_by\_thread\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_transactions_summary_by_thread_by_event_name-tabl) | Transaction events aggregated by thread and event.. | | [events\_transactions\_summary\_by\_user\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_transactions_summary_by_user_by_event_name-table) | Transaction events aggregated by user and event.. | | [events\_transactions\_summary\_global\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_transactions_summary_global_by_event_name-table) | Transaction events aggregated by event name. | | [events\_waits\_current](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_current-table) | Current wait events. | | [events\_waits\_history](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_history-table) | Ten most recent wait events per thread. | | [events\_waits\_history\_long](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_history_long-table) | Ten thousand most recent wait events per thread. | | [events\_waits\_summary\_by\_account\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_summary_by_account_by_event_name-table) | Summarized wait events by account and event name. | | [events\_waits\_summary\_by\_host\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_summary_by_host_by_event_name-table) | Summarized wait events by host and event name. | | [events\_waits\_summary\_by\_instance](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_summary_by_instance-table) | Summarized wait events by instance. | | [events\_waits\_summary\_by\_thread\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_summary_by_thread_by_event_name-table) | Summarized wait events by thread and event name. | | [events\_waits\_summary\_by\_user\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_summary_by_user_by_event_name-table) | Summarized wait events by user and event name. | | [events\_waits\_summary\_global\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-events_waits_summary_global_by_event_name-table) | Summarized wait events by event name. | | [file\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-file_instances-table) | Seen files. | | [file\_summary\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-file_summary_by_event_name-table) | File events summarized by event name. | | [file\_summary\_by\_instance](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-file_summary_by_instance-table) | File events summarized by instance. | | [global\_status](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-global_status-table) | Global status variables and values. | | [host\_cache](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-host_cache-table) | Host and IP information. | | [hosts](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-hosts-table) | Connections by host. | | [memory\_summary\_by\_account\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-memory_summary_by_account_by_event_name-table) | Memory usage statistics aggregated by account and event. | | [memory\_summary\_by\_host\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-memory_summary_by_host_by_event_name-table) | Memory usage statistics aggregated by host. and event. | | [memory\_summary\_by\_thread\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-memory_summary_by_thread_by_event_name-table) | Memory usage statistics aggregated by thread and event.. | | [memory\_summary\_by\_user\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-memory_summary_by_user_by_event_name-table) | Memory usage statistics aggregated by user and event.. | | [memory\_summary\_global\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-memory_summary_global_by_event_name-table) | Memory usage statistics aggregated by event. | | [metadata\_locks](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-metadata_locks-table) | [Metadata locks](https://mariadb.com/docs/server/reference/sql-statements/transactions/metadata-locking). | | [mutex\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-mutex_instances-table) | Seen mutexes. | | [objects\_summary\_global\_by\_type](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-objects_summary_global_by_type-table) | Object wait events. | | [performance\_timers](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-performance_timers-table) | Available event timers. | | [prepared\_statements\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-prepared_statements_instances-table) | Aggregate statistics of prepared statements. | | [replication\_applier\_configuration](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-replication_applier_configuration-table) | Configuration settings affecting replica transactions. | | [replication\_applier\_status](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-replication_applier_status-table) | General transaction execution status on the replica. | | [replication\_applier\_status\_by\_coordinator](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-replication_applier_status_by_coordinator-table) | Coordinator thread specific information. | | [replication\_applier\_status\_by\_worker](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-replication_applier_status_by_worker-table) | Replica worker thread specific information. | | [replication\_connection\_configuration](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-replication_connection_configuration-table) | Rreplica's configuration settings used for connecting to the primary. | | [rwlock\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-rwlock_instances-table) | Seen read-write locks. | | [session\_account\_connect\_attrs](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-session_account_connect_attrs-table) | Current session connection attributes. | | [session\_connect\_attrs](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-session_connect_attrs-table) | All session connection attributes. | | [session\_status](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-session_status-table) | Session status variables and values. | | [setup\_actors](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-setup_actors-table) | Details on foreground thread monitoring. | | [setup\_consumers](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-setup_consumers-table) | Consumers for which event information is stored. | | [setup\_instruments](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-setup_instruments-table) | Instrumented objects for which events are collected. | | [setup\_objects](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-setup_objects-table) | Objects to be monitored. | | [setup\_timers](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-setup_timers-table) | Currently selected event timers. | | [socket\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-socket_instances-table) | Active connections. | | [socket\_summary\_by\_event\_name](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-socket_summary_by_event_name-table) | Timer and byte count statistics by socket instrument. | | [socket\_summary\_by\_instance](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-socket_summary_by_instance-table) | Timer and byte count statistics by socket instance. | | [status\_by\_account](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-status_by_account-table) | Status variable info by host/user account. | | [status\_by\_host](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-status_by_host-table) | Status variable info by host. | | [status\_by\_thread](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-status_by_thread-table) | Status variable info about active foreground threads. | | [status\_by\_user](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-status_by_user-table) | Status variable info by user. | | [table\_handles](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-table_handles-table) | Table lock information. | | [table\_io\_waits\_summary\_by\_index\_usage](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-table_io_waits_summary_by_index_usage-table) | Aggregate table I/O wait events by index. | | [table\_io\_waits\_summary\_by\_table](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-table_io_waits_summary_by_table-table) | Aggregate table I/O wait events by table. | | [table\_lock\_waits\_summary\_by\_table](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-table_lock_waits_summary_by_table-table) | Aggregate table lock wait events by table. | | [threads](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-threads-table) | Server thread information. | | [user\_variables\_by\_thread](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-user_variables_by_thread-table) | [User-defined variables](https://mariadb.com/docs/server/reference/sql-structure/sql-language-structure/user-defined-variables) by thread. | | [users](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-users-table) | Connection statistics by user. | *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}