Optimize(d) WordPress hosting – 10 practical tips to optimize your WordPress hosting

Isn’t it true that, when you (start to) develop WordPress websites for clients, and you host them yourself, you find yourself in a situation where you need to know a lot about “stuff” other than WordPress development? In this optimize your WordPress hosting post, I provide 10 practical tips for you, to improve WordPress hosting performance. Especially useful for when you plan to host WordPress websites yourself. Read on to learn how I optimize my WordPress hosting, and how you can do the same.

Continue reading “Optimize(d) WordPress hosting – 10 practical tips to optimize your WordPress hosting”

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

Your MySQL Database at Warp Speed - img. credits: Christian Daryanto Limas @ flickr
Your MySQL Database at Warp Speed

Are you running into MySQL load problems? Learn how how I tuned my MySQL servers for a heavy InnoDB workload, by configuring innodb_buffer_pool_instances. Dividing the InnoDB Buffer Pool into multiple instances improves Disk I/O. By doing so, you run your website more efficiently and fast. Here is a little help for you.

Continue reading “MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!”

PHP, MySQL and IPv6: still slow

Years ago, I noticed that PHP connections to MySQL were significantly slower over IPV6 (where a hostname has an IPv6 address or AAAA record), when no MySQL service is listening on that address. The connection is refused, and PHP has to fallback to IPv4. The fallback takes a significant amount of time. Too much time if you’d asked me. Unfortunately this fallback to IPv4 is still slow today…

Continue reading “PHP, MySQL and IPv6: still slow”

Disable WordPress comments (how-to)

The WordPress comment system can be a bless for your blog, because of the user interaction. However, when the WordPress comment option is abused by spammers, it becomes a real pain in the “@ss”. With tens- or hundreds of thousands spam reactions, disabling WordPress comments – and removing – is the only way to go. Here is how to disable WordPress comments in both the WordPress Dashboard interface and in your MySQL database.

Continue reading “Disable WordPress comments (how-to)”

Convert MySQL MyISAM tables to InnoDB

In the earlier days of MySQL, the default storage engine for your database was MyISAM. This is also why you still encounter a lot of examples with engine=MyISAM online. Nowadays, the default storage engine is InnoDB, and MyISAM is no longer actively developed. Therefore, all MySQL performance optimizations are for InnoDB, and it’s recommended to switch to this as your table storage engine.

Continue reading “Convert MySQL MyISAM tables to InnoDB”