indexing - Is there a way to directly access a MariaDB or MySQL table index? -

i've read somewhere in recent months there project(s) integrates mysql or mariadb allowed direct index access performance optimization.

specifically, kind of interface allow directly things like:

• "give me id of record indexed column matches blah" or
• "does id of value exist in specific index"

...and allows bypassing sql query parsing, planning, etc. steps, , gain higher throughput speed-sensitive operations.

i can't seem find googling around it. familiar projects doing this? looking links open source sort of thing. (am dealing mysql [or 1 of it's derivatives], other open source projects might relevant well.)

background info:

i've ready on highscalability.com , other places of shops moving traditional rdbms nosql-style solution (or deciding go nosql @ start of new project) later regret , find advantages of nosql not outweigh drawbacks of having build around storage platform doesn't support flexibility of sql (basically: it's pain in neck writing joins hand in code, rather being able query stuff). have sworn i'd read things people using "traditional" rdbmses , exposing raw indexes directly specific cases high performance needed, potential solution. don't see on when searching around. question.

you're thinking of handlersocket in mariadb or handlersocket in percona server or innodb memcached api in mysql 5.6. realistically, though, should not take using 1 of these solutions lightly. useful, perhaps, select number of applications , uses difference both noticeable , beneficial , of entire world you're making life more difficult , asking strange bugs using them. tread carefully.