Archive for October, 2008

MySQL Parameters: Performance Optimization

Sunday, October 19th, 2008

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.

(more…)