This repository has been archived by the owner on Jul 26, 2022. It is now read-only.
forked from facebook/mysql-5.6
-
Notifications
You must be signed in to change notification settings - Fork 13
INFORMATION_SCHEMA tables
Sergei Petrunia edited this page Nov 7, 2015
·
3 revisions
MySQL [information_schema]> select * from ROCKSDB_INDEX_FILE_MAP;
+---------------+--------------+------------+----------+-----------+
| COLUMN_FAMILY | INDEX_NUMBER | SST_NAME | NUM_ROWS | DATA_SIZE |
+---------------+--------------+------------+----------+-----------+
| 0 | 269 | 000030.sst | 47605 | 1428150 |
| 0 | 268 | 000029.sst | 30365 | 910950 |
| 0 | 269 | 000029.sst | 52395 | 1571850 |
| 0 | 267 | 000027.sst | 36 | 756 |
It looks like (COLUMN_FAMILY, INDEX_NUMBER, SST_NAME) combination is unique.
Shows Column Family options being used.
MySQL [information_schema]> select * from ROCKSDB_DBSTATS;
+-------------------------+--------+
| STAT_TYPE | VALUE |
+-------------------------+--------+
| DB_BACKGROUND_ERRORS | 0 |
| DB_NUM_SNAPSHOTS | 0 |
| DB_OLDEST_SNAPSHOT_TIME | 0 |
| DB_BLOCK_CACHE_USAGE | 341993 |
+-------------------------+--------+
Allows to map dbname.tablename.index_name to (column_family, index_number). The latter are necessary for interpreting the logs and ROCKSDB_INDEX_FILE_MAP.
+--------------+------------+----------------+------------+---------------+--------------+------------+-------------------+---------+
| TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | INDEX_NAME | COLUMN_FAMILY | INDEX_NUMBER | INDEX_TYPE | KV_FORMAT_VERSION | CF |
+--------------+------------+----------------+------------+---------------+--------------+------------+-------------------+---------+
| test | tbl1 | NULL | PRIMARY | 0 | 259 | 1 | 10 | default |
| test | tbl1 | NULL | col1 | 0 | 260 | 2 | 10 | default |
+--------------+------------+----------------+------------+---------------+--------------+------------+-------------------+---------+