There have been a lot of systems I have looked at where the
Created_tmp_disk_tables was very high. MySQL has good documentation on how it uses memory, specifically temp tables,
here.
I would like to talk about not "why" MySQL does this but how to speed up the performance when MySQL internally or users create temporary tables to disk. A great solution is TMPFS, a quick how to is…
Continue