← Back to team overview

maria-developers team mailing list archive

Re: storage engine index usage

 

Hi, Andras!

On Feb 06, Andras Szabo wrote:

> SELECT name, fsize FROM etc WHERE path = “init.d”;
> 
> However we’re in a bit of trouble how we could improve the storage
> engine to be able to handle this.
> 
> Of course we would not like to do a "deep enumeration" of the root
> directory (full table scan) . So somehow we would like to access/use
> the information from the where clause.
> 
> Can anybody recommend a way to solve that?

Supporting indexes would be a natural way to do it.
That's not very difficult. See any existing engine, a simple one,
preferrably. Or check my book
https://www.packtpub.com/big-data-and-business-intelligence/mysql-51-plugin-development
the last chapter is about exactly that.

Regards,
Sergei



References