https://dev.mysql.com/doc/refman/8.0/en/handler.html talks about handler interface that can bypass overhead of SQL, such as parsing, query optimization etc. However, it is supported only for InnoDB and MyISAM tables.
Does Percona or anyone else have any plan to support it for RocksDB?
Since MyRocks (with single-column or multi-column primary key) is likely to be used for key value store applications, such a handler interface could help performance, esp in get_multi() apis that look for several keys (like hundreds), and there can be huge SQL overhead.
Thanks for your question. There are currently no plans to support this for MyRocks although it does sound like an interesting idea. I have honestly never even thought about it so I don’t have any idea how easy or difficult it would be.
George O. Lorch IIIDirector of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup