« Previous: El poder del Dark Side… I mean, RSS. Friday animation fun :Next »

August 31st, 2006
by NathanMan vs. MySQL, the Road to Victory!

Steps:

  1. Notice that site has become really slow the last few days.
  2. Stumble upon a fantastic resource by Ian Gilfillan for people with limited MySQL experience.
  3. Slap forehead and finally turn on slow query logging to find queries that take more than one second.
  4. Realize that, oh crap, we’re reading every row in the session id table constantly.
  5. Add an index to the session id table to fix that.
  6. Try to fix other expensive queries that use sorting.
  7. Fix those by upping the startup variables that effect sorting cache.
  8. Forgive self for rookie mistakes because I’m a CSS jockey not a DBA.

This entry was posted by Nathan on Thursday, August 31st, 2006 at 5:02 pm and is filed under Development. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

7 Responses to “Man vs. MySQL, the Road to Victory!”

  1. Nogg3r5 Says:
    August 31st, 2006 at 11:58 pm

    Seriously, All is forgiven! The speed is incredible, I didn’t think things could actually get faster!!!!!

  2. Chrono Cr@cker Says:
    September 1st, 2006 at 12:20 am

    Great service you ppl have here, a couple of my suggestions.

    1) Give the user some font size control
    2) Most ppl on the fly like to view all their feeds at one go… would be nice.

  3. pqs Says:
    September 1st, 2006 at 1:33 am

    Yes, all is forgiven. Newshutch just rocks. The best newsreader I’ve ever seen. I was moving from G.Reader to Rojo back and forward and I was never happy. I think now I’ll settle here.

  4. Laurent B. Says:
    September 1st, 2006 at 5:21 am

    Great news!
    Victory is near! :-)

  5. Nathan Says:
    September 1st, 2006 at 10:35 am

    Chrono, with every browser in the universe (except IE natch) you can resize fonts. Newshutch’s design can usually tolerate 2 bumps up in font size without getting all wonky.

    We’d like to do a river of news, but we have to implement some elegant solution for pagination first. We can’t just spit everything out at once or we’ll catch fire.

  6. Scott Says:
    September 1st, 2006 at 8:35 pm

    Keep up the great work guys. I remember back in the days when I was a MySQL rookie, so I know the pain you are enduring. :-) Even through all that, you guys are doing quite well. Just ensure you have built in scalability in to Newshutch so that when it does get more popular, you wont be killing the site.

    Anyhow, thanks for a wonderful service!

  7. Ben Eastaugh Says:
    September 18th, 2006 at 3:09 pm

    I’ve found the site an awful lot faster in the last day or so, so many thanks for all the tweaks you’ve obviously been doing.