Initial D World - Discussion Board / Forums [Powered by Invision Power Board]

Printable Version of Topic
Click here to view this topic in its original format

Initial D World - Discussion Board / Forums > Announcement Board > MySQL Database Error (2008-07-30)

Posted by: Perry Jul 30 2008, 09:38 PM

As some of you know, the forums were inaccessible for roughly 6 hours from 4:00 PM to 10:00 PM (Pacific Standard Time) I was nowhere near a computer when it happens, thus I could not fix it right away. I first got to know the problem at 9:25 PM. My gut feeling thought it was a MySQL version compatibility issue. After a little research on the MySQL error message, it turned out to be a typical out-of-space error.

What happened was, the /tmp/ partition was full. Why does it matter if it's full you ask ? Because that's where the MySQL database uses as a temporary "workbench." When it's full, the MySQL database can not operate properly. The main page of the forums happen to be have a MySQL SELECT statement that is barred by this impairment.

I had a talk with thewird and make sure this problem won't happen again by increasing the size of the /tmp/ partition. Hopefully this problem won't come back again. And no, this had nothing to do with the forums getting near the 1,000,000th post mark. The IPB 1.3.x software is capable of having over 100 million posts.

Thanks for your patience and sorry for the inconvenience.

Posted by: Möbius Jul 31 2008, 03:02 PM

I was only kidding with the 1000K post being the problem.