maria-developers team mailing list archive

[Zardosht Kasheff <zardosht@xxxxxxxxx>]

Hello all,

After talking with Colin Charles last night, I have been encouraged to
send more patches for MariaDB. Here is a hopefully simple one that
benefits all storage engines.

Attached is a proposed patch of new handler APIs. The purpose of this
patch is to give storage engines more information about impending
range queries. The idea is if MySQL is about to perform a range query
from a to b, then the handler is informed that a range query is about
to happen.

It extends functionality like handler::prepare_index_scan to other
scenarios. We use it to know how much data to prefetch and prelock
before doing a range query.

Any storage engine can use this as a heuristic for optimizing range
query performance.

I would love to hear feedback
-Zardosht

Attachment: handler_range_query_info.diff
Description: Binary data