Create information_schema.rocksdb_datadic to print data dictionary

[hermanlee]

Issue by yoshinorim
Monday Jun 15, 2015 at 17:37 GMT
Originally opened as MySQLOnRocksDB#83

---

This is rather for debugging purposes, but printing data dictionary via information_schema is often very useful.

[hermanlee]

Comment by hermanlee
Monday Jun 15, 2015 at 17:45 GMT

---

We have support for printing out the index numbers and tables/databases they belong to in information_schema.rocksdb_ddl, but other parts of the data dictionary need to be added (such as binlog numbers, column family indexes, etc.).

[hermanlee]

Comment by yhchiang
Thursday Jul 23, 2015 at 08:25 GMT

---

In case this is not something urgent, I would like to try this out :)

First of all, can I know whether storage/rocksdb/rdb_i_s.cc is the right file to begin with? I'm not familiar with the mysql code base.

[hermanlee]

Comment by hermanlee
Thursday Jul 23, 2015 at 17:14 GMT

---

Yes, rdb_i_s.cc is the right place to start. It has the basic structure for creating information schema tables. The table would need to retrieve the contents of the data dictionary and convert them into the appropriate table format and return it.

[hermanlee]

information_schema.global_info supports printing out the binlog information, etc.