# MyRocks Information Schema tables

When you install the MyRocks plugin for *MySQL*, the
Information Schema is extended to include the following tables:

## ROCKSDB_GLOBAL_INFO

### Columns

| Column Name | Type         |
|-------------|--------------|
| TYPE        | varchar(513) |
| NAME        | varchar(513) |
| VALUE       | varchar(513) |

## ROCKSDB_CFSTATS

### Columns

| Column Name | Type         |
|-------------|--------------|
| CF_NAME     | varchar(193) |
| STAT_TYPE   | varchar(193) |
| VALUE       | bigint(8)    |

## ROCKSDB_TRX

This table stores mappings of RocksDB transaction identifiers to *MySQL*
client identifiers to enable associating a RocksDB transaction with a *MySQL*
client operation.

### Columns

| Column Name              | Type         |
|--------------------------|--------------|
| TRANSACTION_ID           | bigint    |
| STATE                    | varchar(193) |
| NAME                     | varchar(193) |
| WRITE_COUNT              | bigint    |
| LOCK_COUNT               | bigint    |
| TIMEOUT_SEC              | int       |
| WAITING_KEY              | varchar(513) |
| WAITING_COLUMN_FAMILY_ID | int       |
| IS_REPLICATION           | int       |
| SKIP_TRX_API             | int       |
| READ_ONLY                | int       |
| HAS_DEADLOCK_DETECTION   | int       |
| NUM_ONGOING_BULKLOAD     | int      |
| THREAD_ID                | int       |
| QUERY                    | varchar(193) |

## ROCKSDB_CF_OPTIONS

### Columns

| Column Name | Type         |
|-------------|--------------|
| CF_NAME     | varchar(193) |
| OPTION_TYPE | varchar(193) |
| VALUE       | varchar(193) |

## ROCKSDB_ACTIVE_COMPACTION_STATS

### Columns

| Column Name | Type         |
|-------------|--------------|
| THREAD_ID   | bigint       |
| CF_NAME     | varchar(193) |
| INPUT_FILES | varchar(513) |
| OUTPUT_FILES| varchar(513) |
| COMPACTION_REASON | varchar(513) |

## ROCKSDB_COMPACTION_HISTORY

### Columns

| Column Name | Type         |
|-------------|--------------|
| THREAD_ID   | bigint       |
| CF_NAME     | varchar(513) |
| INPUT_LEVEL | integer      |
| OUTPUT_LEVEL| integer      |
| INPUT_FILES | varchar(513) |
| OUTPUT_FILES| varchar(513) |
| COMPACTION_REASON| varchar(513)|
| START_TIMESTAMP| bigint|
| END_TIMESTAMP| bigint|

## ROCKSDB_COMPACTION_STATS

### Columns

| Column Name | Type         |
|-------------|--------------|
| CF_NAME     | varchar(193) |
| LEVEL       | varchar(513) |
| TYPE        | varchar(513) |
| VALUE       | double       |

## ROCKSDB_DBSTATS

### Columns

| Column Name | Type         |
|-------------|--------------|
| STAT_TYPE   | varchar(193) |
| VALUE       | bigint(8)    |

## ROCKSDB_DDL

### Columns

| Column Name       | Type               |
|-------------------|--------------------|
| TABLE_SCHEMA      | varchar(193)       |
| TABLE_NAME        | varchar(193)       |
| PARTITION_NAME    | varchar(193)       |
| INDEX_NAME        | varchar(193)       |
| COLUMN_FAMILY     | int(4)             |
| INDEX_NUMBER      | int(4)             |
| INDEX_TYPE        | smallint(2)        |
| KV_FORMAT_VERSION | smallint(2)        |
| TTL_DURATION      | bigint(8)          |
| INDEX_FLAGS       | bigint(8)          |
| CF                | varchar(193)       |
| AUTO_INCREMENT    | bigint(8) unsigned |

## ROCKSDB_INDEX_FILE_MAP

### Columns

| Column Name          | Type         |
|----------------------|--------------|
| COLUMN_FAMILY        | int(4)       |
| INDEX_NUMBER         | int(4)       |
| SST_NAME             | varchar(193) |
| NUM_ROWS             | bigint(8)    |
| DATA_SIZE            | bigint(8)    |
| ENTRY_DELETES        | bigint(8)    |
| ENTRY_SINGLEDELETES  | bigint(8)    |
| ENTRY_MERGES         | bigint(8)    |
| ENTRY_OTHERS         | bigint(8)    |
| DISTINCT_KEYS_PREFIX | varchar(400) |

## ROCKSDB_LIVE_FILES_METADATA

| Column Name              | Type         |
|--------------------------|--------------|
| CF_NAME                  | varchar(193) |
| LEVEL                    | varchar(513) |
| NAME                     | varchar(513) |
| DB_PATH                  | varchar(513) |
| FILE_NUMBER              | bigint       |
| FILE_TYPE                | varchar(193) | 
| SIZE                     | bigint       |
| RELATIVE_FILENAME        | varchar(193) | 
| DIRECTORY                | varchar(513) | 
| TEMPERATURE              | varchar(193) |  
| FILE_CHECKSUM            | varchar(513) | 
| FILE_CHECKSUM_FUNC_NAME  | varchar(193) |  
| SMALLEST_SEQNO           | bigint       | 
| LARGEST_SEQNO            | bigint       | 
| SMALLEST_KEY             | varchar(513) |  
| LARGEST_KEY              | varchar(513) |  
| NUM_READS_SAMPLED        | bigint       | 
| BEING_COMPACTED          | tinyint      | 
| NUM_ENTRIES              | bigint       | 
| NUM_DELETIONS            | bigint       | 
| OLDEST_BLOB_FILE_NUMBER  | bigint       | 
| OLDEST_ANCESTER_TIME     | bigint       | 
| FILE_CREATION_TIME       | bigint       |

## ROCKSDB_LOCKS

This table contains the set of locks granted to MyRocks transactions.

### Columns

| Column Name      | Type         |
|------------------|--------------|
| COLUMN_FAMILY_ID | int(4)       |
| TRANSACTION_ID   | bigint      |
| KEY              | varchar(513) |
| MODE             | varchar(32)  |

## ROCKSDB_PERF_CONTEXT

### Columns

| Column Name    | Type         |
|----------------|--------------|
| TABLE_SCHEMA   | varchar(193) |
| TABLE_NAME     | varchar(193) |
| PARTITION_NAME | varchar(193) |
| STAT_TYPE      | varchar(193) |
| VALUE          | bigint(8)    |

## ROCKSDB_PERF_CONTEXT_GLOBAL

### Columns

| Column Name | Type         |
|-------------|--------------|
| STAT_TYPE   | varchar(193) |
| VALUE       | bigint(8)    |

## ROCKSDB_DEADLOCK

This table records information about deadlocks.

### Columns

| Column Name    | Type         |
|----------------|--------------|
| DEADLOCK_ID    | bigint(8)    |
| TRANSACTION_ID | bigint(8)    |
| CF_NAME        | varchar(193) |
| WAITING_KEY    | varchar(513) |
| LOCK_TYPE      | varchar(193) |
| INDEX_NAME     | varchar(193) |
| TABLE_NAME     | varchar(193) |
| ROLLED_BACK    | bigint(8)    |