We've 500K+ posts and database is around 3.x GB. (we allocated 5GB innodb buffer pool) We've been using caching plugin, but performance still sluggish on area where cache is not useful, e.g. wp-admin stuffs.

Are there any more optimisation tips?

  • Imposible to answer your question without knowing where your bottle neck is, what the features of your server are and so on. Vote to close as too board.
    – cybmeta
    Commented Nov 27, 2017 at 10:15

1 Answer 1


You could activate the Query Monitor plugin and then load the post(s) / page(s) that are giving you trouble. It will show you where the slowness is being caused, core, theme, plugin A or Plugin B.

It is often possible to speed up a slow query by adding the appropriate index. Try reading this article for tips on how to do this.

Anything more specific will require much more information from you on exactly what is wrong. Details, details.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.