Using EXPLAIN to Write Better MySQL Queries

10 Apr, 2012 - By Shameer C
When you issue a query, the MySQL Query Optimizer tries to devise an optimal plan for query execution. You can see information about the plan by prefixing the query with EXPLAIN. EXPLAIN is one of the most powerful tools at your disposal for...
Read on »

MySql performance part-2 : Understanding the server

28 Nov, 2010 - By Shameer C
Server configuration and optimization is definitely not your job if you are not a DBA. You can’t just set the server parameters to some arbitrary values expecting a nice performance boost, because it depends on different factors. It needs good...
Read on »

MySQL Performance Part-1 : Schema design guidelines

07 Nov, 2010 - By Shameer C
Few days back I started writing my article series on mysql performance optimization. Unfortunatly I was unable to continue the stream. This is my second attempt to do the same and will my try level best not to discontinue. I will be trying to keep...
Read on »