MyRocks stores data in column families. These are similar to tablespaces. By default, the data is stored in the
default column family.
One can specify which column family the data goes to by using index comments:
INDEX index_name(col1, col2, ...) COMMENT 'column_family_name'
If the column name starts with
rev:, the column family is reverse-ordered.
Storage parameters like
are specified on a per-column family basis.
When creating a table or index, you can specify the name of the column family for it. If the column family doesn't exist, it will be automatically created.
There is currently no way to drop a column family. RocksDB supports this internally but MyRocks doesn't provide any way to do it.
Use these variables:
This parameter allows one to override column family options for specific column families. Here is an example of how to set option1=value1 and option2=value for column family cf1, and option3=value3 for column family cf3:
One can check the contents of
INFORMATION_SCHEMA.ROCKSDB_CF_OPTIONS to see what options are available.
Options that are frequently configured are:
See the INFORMATION_SCHEMA.ROCKSDB_CF_OPTIONS table.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.