Webapp Scalability woes…getting your MYSQL database to run fast & clean

This post is for the techies & geeks.

Just sharing this wonderful resource, that’s currently one of the most popular slide decks on slideshare. This is a presentation on MySQL tuning, from somebody who works at MYSQL. Titled “15 Ways to Kill your MYSQL peformance“, it’s a straight-from-the-pits, hands on presentation on how to get the best from your MYSQL databse.

If you work at a web startup, there’s a 95% chances that you are using MYSQL as your database. Its also likely that you still haven’t got to the stage, where a database administrator has become a necessity; this job is being done by your coders. This presentation could come in handy. From my experience of running a large, fast growing consumer internet website, getting your database to run fast, clean & efficient is a serious bottleneck to scalability of your website and hence your business. The good news is that scalability problems afflict you only when you get to a threshold; the bad news is that scalability (unlike the act of building your webapp) is largely experiential in nature, and there is little substitute to having somebody on your team who has done this before. Or you might need to learn from scratch.

My tech team found this presentation very useful, so thought of sharing it here for the benefit of others. Do let me know what you thought of this…..

8 thoughts on “Webapp Scalability woes…getting your MYSQL database to run fast & clean

  1. Ranjan

    Welcome back.

    My wish list: A Database tutorial for a newbie where he can build small apps like search, view and compare products from a database!

    Reply
  2. amit Post author

    Ranjan,

    That would be interesting…what kind of database is this…in MS excel, MS access or standard d/b like mysql, sqlserver, orace etc..

    Reply
  3. amit Post author

    Pratham,

    No we havent tried simpledb out…in any case I was not suggesting a different DB; scalability would be an issue with whichever you choose….

    Reply
  4. Pingback: www.webyantra.net»Blog Archive » Treasure trove of scalability stories - Flickr, Digg, FeedBurner, LiveJournal, SixApart, Last.fm, Twitter, Wordpress

  5. Pingback: Webapp Scalability woes…getting your MYSQL database to run fast … - Affordable Web Developer - Just another WordPress weblog on Affordable open source web development.

  6. Pingback: Webapp Scalability woes…getting your MYSQL database to run fast … - Affordable Web Developer - Just another WordPress weblog on Affordable open source web development.

Leave a Reply

Your email address will not be published. Required fields are marked *