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.
More performance optimization tips for MySQL and WordPress
Tags: MySQL Performance, WordPress Performance