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