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

more images

more images

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

• Here is a bonus tip for WordPress perfromance optimization (dated but still valid).
• Another bonus tip on MySQL performance optimization for newbies.