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.
First benefits from performance optimization: I have discovered “the mother of all queries” in phpBB.
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.