Support » Plugin: Redis Object Cache » caching of options tables on multisite network

  • I’m not entirely sure how redis works alongside the built in wordpress caching, but I do know that in general this plugin has sped up my site.

    On a multisite network, I get a lot of slow queries like,

    SELECT option_name, option_value
    FROM xxxxxx_2788_options
    WHERE autoload = ‘yes’

    on a page refresh they load quickly, but then 10 minutes later I’m getting the same slow queries.

    I have 2gb defined for redis, and I’ve never seen it use over 1gb

    Is it possible to use wp-config defines to make sure these types of queries are cached?

    P.S. Sent you a thank you via paypal

Viewing 1 replies (of 1 total)
  • Plugin Author Till Krüss


    Thanks for your support!

    Sadly it’s up to WP itself to cache those queries. You can theoretically write your own caching for them using filter, but that’s more of a Redis Cache Pro endeavor.

    For now, I’d suggest installing the Debug Bar plugin as well as Query Monitor. Then go to a slow loading page and see how many SQL queries are fired and how many cache hits/missing you have with the object cache.

    If you want to post screenshots or videos, that would be helpful.

Viewing 1 replies (of 1 total)
  • The topic ‘caching of options tables on multisite network’ is closed to new replies.