Tuning MySQL for eZ Publish
Friday 11 August 2006 2:33:00 pm
As this article has shown, there are numerous MySQL parameters that affect performance. Tuning the database for maximum performance is a matter of ensuring you have sufficient hardware resources, deciding which kind of operations you wish to optimize, and then testing various settings to see which yield the best results.
While this article has described the most common settings that affect performance and provided suggestions based on our testing and benchmarking, other systems might respond well to different values or the modification of other settings, due to variations in the database, the hardware and the environment.
Please add your own experiences and comments to this article. We will update the article in the future as new optimization technicques are discovered and tested.