Not the answer you need?
Register and ask your own question!

Handler interface for RocksDB?

VamsiVamsi Current User Role Contributor
Hi Folks,
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,
Vamsi

Answers

  • George LorchGeorge Lorch Percona Percona Moderator Role Patron
    Hello Vasmi,
    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 III
    Director of Server Engineering, Percona Server for MySQL, Percona XtraDB Cluster, and Percona XtraBackup
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.