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?
--