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

Reader Comments
# john said:

Jeremy, have you been able to come up for air yet?

on September 10, 2002 10:35 PM
# Dan de Isaacs said:

John, you have the most difficult blog to read. I'm loving your talk about 10.2, since I recently upgraded myself and have been out of the MacBigot loop for a few years. So your info is something I'm very interested in. But I can't stop looking at those women!

I'm not complaining, BTW. Just sharing. :D

on September 11, 2002 07:06 AM
# john said:

that is sort of the idea Dan. thanks for the compliment... look for something a little less flashy from me in the coming month... i'll post about it on inluminent/weblog when we're ready to take it public.

on September 14, 2002 07:24 PM
# Grand Blanc Michigan said:

How does SQL Server stack up against MySQL. I know I like the graphical tools for Microsoft products, but how is performance (speed) on the MySQL platform? Comparable?

on July 10, 2003 07:12 AM
Disclaimer: The opinions expressed here are mine and mine alone. My current, past, 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 me. Also, I am not a journalist or reporter. Don't "pitch" me.

 

Privacy: 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 policy. In a few cases, I may leave spammy comments but remove any URLs they contain.