> 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

Reply via email to