≡ Menu

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…..

{ 5 comments… add one }

  • Ranjan February 5, 2008, 11:08 am

    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!

  • amit February 5, 2008, 12:10 pm

    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..

  • Pratham February 6, 2008, 12:24 pm

    Amit,
    Have you considered simpleDB for your database needs ?

  • amit February 7, 2008, 4:08 am

    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….

  • Ravish Kumar February 23, 2008, 7:39 am

    This is a beautiful tutorials.

    I found couple of point that i need to rework on my database for sure.

    Thanks for sharing.

Leave a Comment