Comments | lj_dev: Power-loss post-mortem

bradfitz in lj_dev

Power-loss post-mortem

Jan 20, 2005 02:48

The post you've all been waiting for! Why we lost all our power, and why it took us so long to come back up afterwards....

(Warning: it's late and I'm tired/rambly, so this post might be incoherent... go ahead and ask questions...)

Why we lost all our power...Another customer in the facility accidentally pressed the EPO button, then depressed ( Read more... )

Comments 430

swerved January 20 2005, 02:49:59 UTC

Thanks for the info.

cool zennywitch January 20 2005, 03:43:33 UTC

dude, you've got my icon.

Re: cool swerved January 26 2005, 03:31:39 UTC

Hah, I totally do. I can't even remember where I got it from, ages ago.

garrik January 21 2005, 03:19:54 UTC

Thread 6

(The comment has been removed)

zianchoy January 20 2005, 11:20:45 UTC

Me too! :)

penguin2 January 20 2005, 16:03:51 UTC

Seconded and carried! Well done the lads and lasses.

kuroshii January 21 2005, 08:34:17 UTC

I just want to completely "ditto" this sentiment. You folks just plain rock.

chemicalbeats January 20 2005, 02:59:17 UTC

Cheers :)

claypot January 20 2005, 02:59:21 UTC

Good to know what happened. Thank you.

kloostec January 20 2005, 03:01:21 UTC

Thanks for the analysis.

Is there any good reason to run MyISAM tables over InnoDB tables any more (MySQL 4)? It seems that they cause nothing but problems ;)

bradfitz January 20 2005, 03:12:51 UTC

They're good for logging... very small and compact on-disk.

Yes, MyISAM has uses jamesd January 20 2005, 04:45:22 UTC

While Wikipedia uses InnoDB for almost everything, MyISAM is perhaps 60-70% of the size on disk, can be faster for some queries, supports fulltext search and locks the whole table at once, which is faster than InnoDB when large numbers of records must be locked.

In general, I much prefer, and strongly recommend, InnoDB wherever it is suitable. It makes for more relaxed sleep when you're responsible for a lot of data and a site which people expect to have available.

Re: Yes, MyISAM has uses kloostec January 21 2005, 02:17:37 UTC

Hey, are you a sysadmin for Wikipedia? Cool, I've got LJ and Wikipedia gurus replying now ;)