> I'm new to MySQL, and I hope somebody can help me. > I have a 3.7G database and a 10G tmpdir. > Sometimes the tmpdir runs out of space, and I get the following message on > the logs: > [ERROR] /usr/libexec/mysqld: Incorrect key file for table > '/tmp/tmpdir/#sql_22f_33.MYI'; try to repair it > Server load increases a lot, and MySQL eventually crashes. > My question is: how can I find out what query is using so much tmpdir > space? > How much space should I allocate to this disk?
Hi Santiago, Ensure the /tmp directory on large MySQL servers is greater than the value of myisam_max_sort_file_size. re: http://itsecureadmin.com/2010/02/mysql-tmp-usage-with-optimize-table-command/ Thanks, Josh Miller, RHCE/VCP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org