3 Effective MySQL Performance Optimization Tips for MyISAM Storage Engine (Optimizes WordPress performance too)

By angsuman, Gaea News Network
Sunday, May 30, 2010

The first two tips should be used for heavily loaded MySQL databases using MyISAM storage engine. They are simple configuration options which can relieve your system to a significant extent. The third can be used for MyISAM or InnoDB but is likely to benefit MyISAM data storage more than InnoDB as per reports on InnoDB so far. There are couple of bonus performance optimization tips at the end.

1. Reduce Maximum Write Lock Count for MyISAM

Add the following line in /etc/my.cnf:

max_write_lock_count = 1

For detailed explanation read: MySQL tip to dramatically improve performance

2. Add the following line in /etc/my.cnf:

low_priority_updates = 1

It gives select queries more priority over insert / updates. This is very useful when your database is read-heavy (much more select than insert / update statements) and rarely you don’t mind slightly stale results. This is very applicable for blogs (like WordPress blogs for example), forums, news sites etc.

3.Use SSD to dramatically speed up MySQL using MyISAM storage engine (works for InnoDB too)

More performance optimization tips for MySQL and WordPress

Discussion

Corporate photographer London
August 18, 2010: 1:51 pm

I have had a wordpress blog for 4 months now and only just starting to get into it. This is a simple question - but I have yet to get an answer from anyone on twitter or find it in google. How do I make my email address active? I can insert links but cant code it in or find an option to add it - I am using Theme SWIFT by Satish Gandham, a product of SwiftThemes.Com
Thanks Grant

May 31, 2010: 3:13 am

Hi all,
This is wonderful tutorial about PHP-MySQL connectivity . thanks guys keep it up…

YOUR VIEW POINT
NAME : (REQUIRED)
MAIL : (REQUIRED)
will not be displayed
WEBSITE : (OPTIONAL)
YOUR
COMMENT :