# Information Schema ROCKSDB\_TRX Table

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `ROCKSDB_TRX` table is included as part of the [MyRocks](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks) storage engine.

The `PROCESS` [privilege](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant) is required to view the table.

It contains the following columns:

| Column                      | Description |
| --------------------------- | ----------- |
| TRANSACTION\_ID             |             |
| STATE                       |             |
| NAME                        |             |
| WRITE\_COUNT                |             |
| LOCK\_COUNT                 |             |
| TIMEOUT\_SEC                |             |
| WAITING\_KEY                |             |
| WAITING\_COLUMN\_FAMILY\_ID |             |
| IS\_REPLICATION             |             |
| SKIP\_TRX\_API              |             |
| READ\_ONLY                  |             |
| HAS\_DEADLOCK\_DETECTION    |             |
| NUM\_ONGOING\_BULKLOAD      |             |
| THREAD\_ID                  |             |
| QUERY                       |             |

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

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