MySQL : Why the database server consume huge amount of disk space on /tmp ?

By | April 7, 2011

MySQL start using temp directory when heavy database usage (very large query) are made, so it will start to create temporary tables on disk instead of memory when size will reach the smaller value of tmp_table_size or max_heap_table_size.