# Performance Schema Status Variables

This page documents status variables related to the [Performance Schema](/docs/server/reference/system-tables/performance-schema.md). See [Server Status Variables](/docs/server/server-management/variables-and-modes/server-status-variables.md) for a complete list of status variables that can be viewed with [SHOW STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status.md).

See also the [Full list of MariaDB options, system and status variables](/docs/server/server-management/variables-and-modes/full-list-of-mariadb-options-system-and-status-variables.md).

#### `Performance_schema_accounts_lost`

* Description: Number of times a row could not be added to the performance schema accounts table due to it being full. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_cond_classes_lost`

* Description: Number of condition instruments that could not be loaded.
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_cond_instances_lost`

* Description: Number of instances a condition object could not be created. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_digest_lost`

* Description: The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_file_classes_lost`

* Description: Number of file instruments that could not be loaded.
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_file_handles_lost`

* Description: Number of instances a file object could not be opened. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_file_instances_lost`

* Description: Number of instances a file object could not be created. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_hosts_lost`

* Description: Number of times a row could not be added to the performance schema hosts table due to it being full. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_index_stat_lost`

* Description:
* Scope: Global, Session
* Data Type: `numeric`
* Introduced: MariaDB 10.5.2

#### `Performance_schema_locker_lost`

* Description: Number of events not recorded, due to either being recursive, or having a deeper nested events stack than the implementation limit. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_memory_classes_lost`

* Description:
* Scope: Global, Session
* Data Type: `numeric`
* Introduced: MariaDB 10.5.2

#### `Performance_schema_metadata_lock_lost`

* Description:
* Scope: Global, Session
* Data Type: `numeric`
* Introduced: MariaDB 10.5.2

#### `Performance_schema_mutex_classes_lost`

* Description: Number of mutual exclusion instruments that could not be loaded.
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_mutex_instances_lost`

* Description: Number of instances a mutual exclusion object could not be created. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_nested_statement_lost`

* Description:
* Scope: Global, Session
* Data Type: `numeric`
* Introduced: MariaDB 10.5.2

#### `Performance_schema_prepared_statements_lost`

* Description:
* Scope: Global, Session
* Data Type: `numeric`
* Introduced: MariaDB 10.5.2

#### `Performance_schema_program_lost`

* Description:
* Scope: Global, Session
* Data Type: `numeric`
* Introduced: MariaDB 10.5.2

#### `Performance_schema_rwlock_classes_lost`

* Description: Number of read/write lock instruments that could not be loaded.
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_rwlock_instances_lost`

* Description: Number of instances a read/write lock object could not be created. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_session_connect_attrs_lost`

* Description: Number of connections for which connection attribute truncation has occurred. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_socket_classes_lost`

* Description:
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_socket_instances_lost`

* Description: Number of instances a socket object could not be created. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_stage_classes_lost`

* Description: Number of stage event instruments that could not be loaded. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_statement_classes_lost`

* Description: Number of statement instruments that could not be loaded. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_table_handles_lost`

* Description: Number of instances a table object could not be opened. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_table_instances_lost`

* Description: Number of instances a table object could not be created. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_table_lock_stat_lost`

* Description:
* Scope: Global, Session
* Data Type: `numeric`
* Introduced: MariaDB 10.5.2

#### `Performance_schema_thread_classes_lost`

* Description: Number of thread instruments that could not be loaded.
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_thread_instances_lost`

* Description: Number of instances thread object could not be created. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

#### `Performance_schema_users_lost`

* Description: Number of times a row could not be added to the performance schema users table due to it being full. The global value can be flushed by [FLUSH STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md).
* Scope: Global, Session
* Data Type: `numeric`

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @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-status-variables.md?ask=<question>
```

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.