Server Optimization

MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distributed throughout a large code base. This article will demonstrate some useful query profiling techniques using tools that are built into MySQL server.