wp_postmeta always peak in the morning after update some plugins

  • Hi, I see my database always peak in the morning after I upgrade some plugins including Yoast SEO. when I see through Newrelic the running query is ‘wp_postmeta select’, this happens every day and makes my website performance go down, is there any solution for this problem?

    Thank you.

    • This topic was modified 2 years, 11 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    The schema for post meta makes for relatively inefficient queries. Anything that makes the desired data more accessible would help. Such as an object cache where pertinent data could be loaded into memory for rapid access. The issue is knowing what data would be needed and getting the code using such data to get it from cache instead of the DB.

    Searching the plugin repository for “object cache” yields many results, but I’m skeptical of how many are really object caches and if they’d really help in your situation. Might be worth trying out a few likely sounding candidates.

Viewing 1 replies (of 1 total)
  • The topic ‘wp_postmeta always peak in the morning after update some plugins’ is closed to new replies.