Tag Archives: MYSQL

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