Oct 6

wordpress working slow? check generation times, optimize MySQL and server configs

Coding tricks, Web technologies cron, mysql, optimization, page generation, server, slow, stats, wordpress

Wordpress might be heavy for your web server as it works a lot with MySQL database and has tons of scripts and plugins that run along.
This as simple script, add it to the footer.php of your Wordpress theme and you will get a line in the bottom with your SQL queries and generation time.

You may start to think of next steps if this values are not acceptable. What you could do, to start with, is:

1) get rid of unused and unnecessary plugins
2) install WP Cache or WP Super Cache plugins
3) add automated MySQL tables optimize script to your cron jobs
4) check your server configuration (php.ini, mysqld.conf) to find if the memory allocation and other settings are optimal
5) upgrade your server

Number 3 stays without attention very often however this is important. MySQL doesn’t optimize itself unlike Oracle. In a while, your DB, depending on its size and usage characteristics, gets fragmented making mysqld process to eat all your server resources. As result, your Wordpress powered website starts working really slowly. At Injoit.com we resolve this by installing additional mysql optimize script to the websites of our customers. Added to cron this script launched daily or weekly and does the job perfectly.