WordPress database optimization

bikegremlin

I've played a bit with the Index WP MySQL For Speed plugin (WP.org link).

Apparently, WordPress does not really shine when it comes to optimizing its DB table searches. This plugin supposedly helps add some keys to make the indexing of the often-used stuff faster.

Looks good for now (tested on staging and one website).

Of course, I wrote an article about WordPress database optimization, with a bit more details and a brief tutorial on how the above-noted plugin is used, in addition to LiteSpeed Cache and Advanced Database Cleaner Pro plugin for cleaning and improving the DP performance.

Encoders

looks great, I'm interested seeing anyone trying this method in large wordpress site with woocommerce loaded (seen many wordpress+woocommerce) instance slowed down after having plenty of product entries

_abhishek

@Encoders said:
looks great, I'm interested seeing anyone trying this method in large wordpress site with woocommerce loaded (seen many wordpress+woocommerce) instance slowed down after having plenty of product entries

I have tried it but didn't see any noticeable difference.

Ympker

Looking great! Thanks for sharing @bikegremlin

MikeDVB

@_abhishek said:

@Encoders said:
looks great, I'm interested seeing anyone trying this method in large wordpress site with woocommerce loaded (seen many wordpress+woocommerce) instance slowed down after having plenty of product entries

I have tried it but didn't see any noticeable difference.

I only saw differences on very large sites and the gains varied from site to site.

As it basically just changes the indexes/keys and can roll them back to stock there's not really any harm in it. If it were to somehow slow things down you can just roll back to stock.

Everything the plugin does could be done manually but the plugin is convenient.

legendary

Does your WP blog worth to optimize? It is already in a not bad shape as a wordpress site:

https://gtmetrix.com/reports/io.bikegremlin.com/td57S7P1/

Expires headers and gzip would be a nice addition. OLS in your case is a useless waste of time/money (if paid version). Apache2 || Nginx would suffice. Golden rule for WP: the less plugins you have - the faster site you have.

As for database -- percona all the way, as the WP is heavy on innodb. Few days with MySQL tunner should do the trick. Indexes? Worth time to invest if >10000 records per table, else gains are negligible.

P.S. I like your website! It looks old school, a lot of words. True geeky experience