I think the fact that you're running out of space in /tmp is, if not all of your load problem, then a large part of it.

When you run a query against mysql and the result set is too large to sort in memory it does it on disc. And where do you suppose it does that? If you guessed /tmp you win.

If you're running out of space in /tmp what do you think happens if two people try to search at the same time?

See where I'm going?

You need to find out why you're running out of space in /tmp. /tmp by the way, is not some place for you to put things temporarily. That's where the computer puts things temporarily.

This thread for sale. Click here! [Linked Image from navaho.infopop.cc]