The MyRocks storage engine lacks the following features compared to InnoDB:
You should also consider the following:
latin1_bin) or binary collation should be used on
VARCHARindexed columns. By default, MyRocks prevents creating indexes with non-binary collations (including
latin1). You can optionally use it by setting
t1(table names with regex format), but non-binary covering indexes other than
german1) still require a primary key lookup to return the
ORDER BY DESCor
ORDER BY ASCis slow. This is because of “Prefix Key Encoding” feature in RocksDB. See http://www.slideshare.net/matsunobu/myrocks-deep-dive/58 for details. By default, ascending scan is faster and descending scan is slower. If the “reverse column family” is configured, then descending scan will be faster and ascending scan will be slower. Note that InnoDB also imposes a cost when the index is scanned in the opposite order.
For general inquiries, please send us your question and someone will contact you.