MySQL Performance Tuning tips and techniques

Posted on in Categories MySQL, Tips, Tuning last updated August 23, 2006

I am aware of few tips but this article summaries few more good tips and techniques that will optimize MySQL Server performance.

Although this article explains how to tune a MySQL database for use with eZ publish system. But most of things mentioned here will apply to other MySQL based software (such as WordPress or phpbb).

This article has suggestions for optimizing for either read or write operations, and also discusses some other optimization techniques such as DNS and filesystem configuration.

Try out these tips and let me know your experience. If you are aware of any other tuning factors please let me know 😀

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin and a trainer for the Linux operating system/Unix shell scripting. He has worked with global clients and in various industries, including IT, education, defense and space research, and the nonprofit sector. Follow him on Twitter, Facebook, Google+.

1 comment

Leave a Comment