Wednesday, July 28, 2010

Re: MySQL error -1

Well, I think I've got a culprit on this one. I was seeing occasional
"/tmp is out of space" messages from the server lately as well, and
wondered whether these two things might be connected. It's a VPS and
the /tmp partition is locked at 100MBs - can't be made larger. So I
reconfigured mysql to use a separate directory for temp space, in /
home. The errors stopped happening immediately (knock wood).

It begs the question as to why this fairly low-traffic Django site
wanted so much /tmp space - there are dozens of WP sites on the same
server with more traffic, and it's never been an issue for them. So
I'm not sure about the cause, but I do seem to have found a fix.

Not sure it's still relevant but here's the output of "SHOW ENGINE
INNODB STATUS":

http://dpaste.com/223011/

Thanks guys.

./s

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment