1

I am doing a sitewide - query across a large wordpress MU installation. I am getting this error:

Incorrect key file for table '#sql_24b3_61.MYI'; try to repair it

The table signified, sql_24b3_61 is not part of my db. Also, the query is very large as it queries across many tables.

It seems to be some configuration setting? because when I shorten the query by almost half it works. I have set open-files-limit to 10000, but that did not change anything.

Sahil Mittal
  • 20,697
  • 12
  • 65
  • 90
user373396
  • 100
  • 1
  • 1
  • 6
  • The table signified is a temporary table MySQL creates to serve your query. Is your query / the temporary table perhaps to large for the tmpdir? If so, what happens if you set it to a disk/path with a lot more room? – Wrikken Jul 13 '10 at 21:47
  • Thank you this was in deed the case! thanks so much – user373396 Jul 13 '10 at 23:22
  • the tmp folder has a limit usually 2GB, try df -h to see it – Elzo Valugi Jan 18 '12 at 12:12

0 Answers0