Since there seems to be a lot of confusion around transactions in MyRocks: https://github.com/facebook/mysql-5.6/wiki/Transaction-Isolation https://github.com/

Since there seems to be a lot of confusion around transactions in MyRocks: https://github.com/facebook/mysql-5.6/wiki/Transaction-Isolation https://github.com/facebook/mysql-5.6/wiki/Transaction-Isola... > MyRocks supports two of the four transaction isolation levels: Read committed and Repeatable reads Repeatable Reads in the default isolation level you get with InnoDB as well (though you can also use "serializable", which MyRocks does not support): https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-i... MySQL does not support transactions that span multiple storage engines (to the best of my knowledge), so you should try to avoid tables with different storage engines within the same database. At least if you need transactions.