# Information Schema MyRocks Tables

- [Information Schema ROCKSDB\_CF\_OPTIONS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_cf_options-table.md): The Information Schema ROCKSDB\_CF\_OPTIONS table contains information about MyRocks column families, such as the column family name and option type.
- [Information Schema ROCKSDB\_CFSTATS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_cfstats-table.md): The Information Schema ROCKSDB\_CFSTATS table provides statistics for each column family in the MyRocks storage engine.
- [Information Schema ROCKSDB\_COMPACTION\_STATS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_compaction_stats-table.md): The Information Schema ROCKSDB\_COMPACTION\_STATS table contains statistics about compaction operations performed by the RocksDB engine.
- [Information Schema ROCKSDB\_DBSTATS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_dbstats-table.md): The Information Schema ROCKSDB\_DBSTATS table displays database-level statistics for the MyRocks storage engine.
- [Information Schema ROCKSDB\_DDL Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_ddl-table.md): The Information Schema ROCKSDB\_DDL table contains information about Data Definition Language (DDL) operations in MyRocks, including table and index names.
- [Information Schema ROCKSDB\_DEADLOCK Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_deadlock-table.md): The Information Schema ROCKSDB\_DEADLOCK table provides information about deadlocks that have occurred within the MyRocks storage engine.
- [Information Schema ROCKSDB\_GLOBAL\_INFO Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_global_info-table.md): The Information Schema ROCKSDB\_GLOBAL\_INFO table contains global configuration information for the MyRocks storage engine.
- [Information Schema ROCKSDB\_INDEX\_FILE\_MAP Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_index_file_map-table.md): The Information Schema ROCKSDB\_INDEX\_FILE\_MAP table maps MyRocks indexes to their corresponding SST files, useful for understanding data storage.
- [Information Schema ROCKSDB\_LOCKS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_locks-table.md): The Information Schema ROCKSDB\_LOCKS table displays information about locks currently held or requested by MyRocks transactions.
- [Information Schema ROCKSDB\_PERF\_CONTEXT Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_perf_context-table.md): The Information Schema ROCKSDB\_PERF\_CONTEXT table contains performance counters for the current session, providing granular metrics on RocksDB operations.
- [Information Schema ROCKSDB\_PERF\_CONTEXT\_GLOBAL Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_perf_context_global-table.md): The Information Schema ROCKSDB\_PERF\_CONTEXT\_GLOBAL table aggregates performance counters from all sessions, offering a global view of MyRocks performance.
- [Information Schema ROCKSDB\_SST\_PROPS Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_sst_props-table.md): The Information Schema ROCKSDB\_SST\_PROPS table displays properties of SST files, such as data size and compression ratios, for MyRocks tables.
- [Information Schema ROCKSDB\_TRX Table](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-myrocks-tables/information-schema-rocksdb_trx-table.md): The Information Schema ROCKSDB\_TRX table provides information about active transactions in MyRocks, including transaction IDs and states.


---

# 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/information-schema/information-schema-tables/information-schema-myrocks-tables.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.