Hi! Yesterday mysql created 5 big temp files. This resulted in a full /tmp directory. In normal condition, it is nothing in the /tmp directory. Do someone knows what files these are, and how to prevent mysql to create big tmp-files? -rw-rw---- 1 mysql mysql 697434112 Jun 30 20:03 #sql343_2ed58a_0.MYD -rw-rw---- 1 mysql mysql 1024 Jun 30 18:53 #sql343_2ed58a_0.MYI -rw-rw---- 1 mysql mysql 569638912 Jun 30 20:05 #sql343_2ed59d_0.MYD -rw-rw---- 1 mysql mysql 1024 Jun 30 18:53 #sql343_2ed59d_0.MYI -rw-rw---- 1 mysql mysql 484048896 Jun 30 20:06 #sql343_2ed5c4_0.MYD -rw-rw---- 1 mysql mysql 1024 Jun 30 18:54 #sql343_2ed5c4_0.MYI -rw-rw---- 1 mysql mysql 403308544 Jun 30 20:07 #sql343_2ed5f6_0.MYD -rw-rw---- 1 mysql mysql 1024 Jun 30 18:55 #sql343_2ed5f6_0.MYI -rw-rw---- 1 mysql mysql 308109312 Jun 30 20:08 #sql343_2ed63d_0.MYD -rw-rw---- 1 mysql mysql 1024 Jun 30 18:56 #sql343_2ed63d_0.MYI (RedHat 7.3 with rpm mysql 3.23.56-1.72) --- Lars Andre
