downtime march 13

Announcements and for questions/problems..
Post Reply
User avatar
bad_brain
Site Owner
Site Owner
Posts: 11636
Joined: 06 Apr 2005, 16:00
19
Location: In your eye floaters.
Contact:

downtime march 13

Post by bad_brain »

phew, that was a nice adrenaline rush.

reason of the downtime was the HDD running out of space, so mysql was not able to create temporary tables anymore. a clean shutdown failed because the .lock file was still there so I had to kill -9 mysql.....which corrupted some open tables.
usually no big deal because you can repair tables marked as crashed with mysqlcheck, but it failed this time, so I tried myisamchk which was able to restore the indexes of the 2 tables marked as corrupted. afterwards the site loaded fine but all content was missing....the posts showed up in the database in list view, but when trying to view the content it returned an empty result.
so I repaired the wp_posts table (it was a Wordpress site), which has a size of almost 4 GB, with myisamchk too, even if it wasn't marked as corrupted or crashed....which worked! \:D/
Image

User avatar
ph0bYx
Staff Member
Staff Member
Posts: 2039
Joined: 22 Sep 2008, 16:00
15
Contact:

Re: downtime march 13

Post by ph0bYx »

Good job! *thumb*

User avatar
maboroshi
Dr. Mab
Dr. Mab
Posts: 1624
Joined: 28 Aug 2005, 16:00
18

Re: downtime march 13

Post by maboroshi »

How does a WP posts table get 4 gb of data ... Is media being stored as Blob? Regardless that is good work, I don't think I would want to handle 4gb of customer (I assume) data.

User avatar
bad_brain
Site Owner
Site Owner
Posts: 11636
Joined: 06 Apr 2005, 16:00
19
Location: In your eye floaters.
Contact:

Re: downtime march 13

Post by bad_brain »

yes, the wp_posts table contains the actual post content (too) which is BLOB... :wink:
Image

User avatar
ayu
Staff
Staff
Posts: 8109
Joined: 27 Aug 2005, 16:00
18
Contact:

Re: downtime march 13

Post by ayu »

gj : D
"The best place to hide a tree, is in a forest"

Post Reply