WordPress wp_options table autoload micro-optimization
Learn how to add an index and optimize WordPress' wp_options table for faster database results. This probably isn't a big issue, but today I noticed a slow MySQL query coming from a WordPress database (WordPress wp_options table). This made me investigate and to optimize the WordPress wp_options table "autoload" feature. The autoload feature loads and caches all autoloaded options, if available, or all options. The default option is to autoload, and over time when the wp_options
table grows, this degrades performance.
Check, repair and optimize MySQL tables with mysqlcheck
MySQL's mysqlcheck is a command line table maintenance program for MySQL. It checks, repairs, optimizes, or analyzes MySQL tables. Very handy for automated performance optimizations of MySQL databases and tables. In this post I'll show you how to use mysqlcheck
to optimize all MySQL tables using a cronjob.
Optimize WP StatPress plugin database performance
The WordPress plugin StatPress (no longer available in the Plugin Directory) is still widely used and still is very slow. Here are some MySQL statements you can use to optimize its performance, as a WordPress optimization tip...