# Handler interface for RocksDB?

**URL:** <https://forums.percona.com/t/handler-interface-for-rocksdb/7686>\
**Category:** Percona Server for MySQL\
**Created:** [June 16, 2020, 1:01pm UTC](https://forums.percona.com/t/handler-interface-for-rocksdb/7686 "2020-06-16T13:01:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vamsi\_P](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vamsi_p/32/2549_2.png) [@Vamsi\_P](https://forums.percona.com/u/Vamsi_P)\
**Post date:** [June 16, 2020, 1:01pm UTC](https://forums.percona.com/t/handler-interface-for-rocksdb/7686/1 "2020-06-16T13:01:29Z")

</div>

Hi Folks,  
[MySQL :: MySQL 8.0 Reference Manual :: 13.2.4 HANDLER Statement](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&nbsp;InnoDB&nbsp;and&nbsp;MyISAM&nbsp;tables.  
Does&nbsp;Percona or anyone else have any plan to support it for RocksDB?  
Since MyRocks&nbsp;(with single-column or multi-column primary key)&nbsp;is&nbsp;likely to be used for key value store applications, &nbsp;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

---

<div class="post-metadata">

**Author:** ![George\_Lorch](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/george_lorch/32/1108_2.png) [@George\_Lorch](https://forums.percona.com/u/George_Lorch)\
**Post date:** [June 16, 2020, 1:17pm UTC](https://forums.percona.com/t/handler-interface-for-rocksdb/7686/2 "2020-06-16T13:17:36Z")

</div>

Hello Vasmi,  
Thanks for your question.&nbsp; There are currently no plans to support this for MyRocks although it does sound like an interesting idea.&nbsp; 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
