> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/storage-engines/performance_schema-storage-engine.md).

# PERFORMANCE\_SCHEMA

If you run [SHOW ENGINES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engines.md), you'll see the following storage engine listed.

```sql
SHOW ENGINES\G
...
      Engine: PERFORMANCE_SCHEMA
     Support: YES
     Comment: Performance Schema
Transactions: NO
          XA: NO
  Savepoints: NO
...
```

The PERFORMANCE\_SCHEMA is not a regular storage engine for storing data, it's a mechanism for implementing the [Performance Schema](/docs/server/reference/system-tables/performance-schema.md) feature.

The [SHOW ENGINE PERFORMANCE\_SCHEMA STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine.md#show-engine-performance_schema-status) statement is also available, which shows how much memory is used by the tables and internal buffers.

See [Performance Schema](/docs/server/reference/system-tables/performance-schema.md) for more details.

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

{% @marketo/form formId="4316" %}