So I'm up just before 5:30am. Why? David Filo paged me because some database servers was pegged on CPU. I investigate. I find a couple of horribly un-optimized queries. They were doing full table scans due to lack of indexes. Even though the tables are essentially in RAM, that really CPU intensive, 'cause all the rows needed to examined.
The moral of the story: Optimize your SQL before running it on my servers and telling the whole world to look at it.
Grr. I guess I'm gonna be up for a while.
Posted by jzawodn at September 10, 2002 06:09 AM
The opinions expressed here are mine and
mine alone. My current
, or previous
employers are not responsible for what I
write here, the comments left by others, or the photos I may share. If
you have questions, please contact
. Also, I am not a journalist or reporter. Don't "pitch" me.
I do not share or publish the email addresses
or IP addresses of anyone posting a comment here without consent.
However, I do reserve the right to remove comments that are spammy,
off-topic, or otherwise unsuitable based on my comment
. In a few cases, I may leave spammy comments but remove any
URLs they contain.