maria-developers team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

Hi guys
I have some server running with bcache and some in test running flash cache
and others linux ssd cache solution

I was thinking about how to optimize the temporary tables of
mysql/mariadb...

could we implement something like:

Temporary Slow/Big Path = /tmp/hdd
Temporary Fast/Small Path = /tmp/ssd
Temporary Fast Max Size = 10MB

When we start using temporary tables (file sort for example) instead of
write to a hdd temporary disk, use a ssd temporary disk, if table get
bigger than 10MB, copy the file to hdd drive, and remove from ssd drive,
and continue writing to hdd

I think with this i could optimize the temporary table use

Any other idea about this kind of optimization?

-- 
Roberto Spadim