Skip to content
Do you have adblock enabled?
If you can read this, either the style sheet didn't load or you have an older browser that doesn't support style sheets. Try clearing your browser cache and refreshing the page.
Latest on db issues
Posted by Mike at 2007-12-12 1:27:01 AM (1 comment) | Permalink
More: FarkBlog

•       •       •

4 clicks; posted to Main » on 12 Dec 2007 at 1:27 AM (15 years ago)   |   Favorite    |   share:  Share on Twitter share via Email Share on Facebook

I did some emergency unannounced database maintenance just now to have another go at fixing some random table corruption that's been causing MySQL to crash randomly.

It's strange because the actual table files aren't getting corrupted (they're read-only tables and md5's of the files aren't changing!) so barring hardware problems, which I've mostly ruled out, it's gotta be the main innodb files getting hosed -- so I converted all tables to MyISAM, blew out the innodb files, and converted them back. To do that means running without transactions, which means weird things can happen (like comments getting the wrong person's name stuck on them) so I shut the site down as a precaution.

If this doesn't fix it then I may have to have another look at hardware, however, I've checked it out pretty thoroughly (no ECC problems with the memory, CPU temperature's fine, power supply seems OK, no apparent problems with the RAID controller or disks...) and after that it's looking for bugs in the OS I guess.

New comment counters being wrong are an unrelated problem; I'm working on that as a separate issue. But the red line should always appear in the correct place and clicking the (sometimes wrong) number will always jump to the correct new comment anyway.
· · ·

1 Comment     (+0 »)
2007-12-13 3:50:06 PM  
How long should "alter table" on a 1.5 GB table with no indexes other than a 2-field primary key take?

a) under 5 minutes
b) 4 hours and makes the table grow to 4 GB
c) crashes the server 3.5 hours into it

If you expected a) and found the answer was really c), congrats, that was me last night.

Yeah. I'm gonna be looking at different database software after the holidays.

Meanwhile, I think I've got things back to normal here.
Displayed 1 of 1 comments

This thread is closed to new comments.

Continue Farking

On Twitter

  1. Links are submitted by members of the Fark community.

  2. When community members submit a link, they also write a custom headline for the story.

  3. Other Farkers comment on the links. This is the number of comments. Click here to read them.

  4. Click here to submit a link.