nixCraft Poll

Topics

MySQL Performance Tuning tips and techniques

Posted by Vivek Gite [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 :D

Want to stay up to date with the latest Linux tips, news and announcements? Subscribe to our free e-mail newsletter or RSS feed to get all updates. You can Email this page to a friend.

You may also be interested in other helpful articles:

Leave a Reply

We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Copyright © 2004-2008 nixCraft. All rights reserved - TOS/Disclaimer - Privacy policy - Sitemap - Powered by Open source software.