Recently I have revisited the performance issue on my largest project - Diorama.Ru. 4000 users with 60.000 page views hitting the server every day. I am proud to have such a “playground” for performance optimization.
We’ve started with the MySQL tuning several months ago, then I have introduced the application level caching using Smarty template engine and finally pushed the last button - Apache gzip compression via mod_deflate.
On the first pages of ABAP Performance Tuning I’ve already learned something new. One of the most powerful methods of the performance tuning is the Kiwi Approach.
Kiwi = Kill It With Iron.
The first part of this post was devoted to the tools for SQL optimization in MySQL. Here I would like to stop at several database parameters which are relevant for MySQL performance.
There are at least three areas to take a look at: Thread Cache, Table Cache and Query Cache.
From the first month of my employment at SAP I was really impressed how the guys in support become crazy on SQL optimization. Deeply impressed on variety of tools for doing this on Oracle and DB2 I decided to carry out the same analysis on my own projects. The first question I’ve asked myself: “Do we have any native MySQL tools for sql optimization?”.
Yes, we do.