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 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?
Santiago Soares Fone: (41) 8488-0537
