Re: tmpdir running out of space

> 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 > Se

tmpdir running out of space

Hello, everybody! 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