Today, July 9, 2011, YWS underwent an unscheduled maintenance operation. This was a result of the database failing twice in two days.
What I've done is to convert the database from primarily MyISAM to primarily InnoDB. For most of you, that will mean nothing. So what you should take away is this:
First, the site will be slightly slower overall. I'm not sure by how much, and I haven't noticed it being slower quite yet. However, it should be slightly slower.
But secondly, the database will no longer lock up and crash. The way the database works is that there's 160 different tables in it. However, under MyISAM only one person may use a table at a time (usually, they do so for only a split second). That can lead to backups as I'm sure you can imagine. Under InnoDB, though, multiple people can use a table at the same time. So, no backups.
Hopefully, this will be the end of our latest string of database crashes.
Gender:
Points: 11417
Reviews: 425