Query Caching with ProxySQL

  • I have a wordpress site running on an AWS instance with NGINX, in this instance i have installed the ProxySQL query cache to improve site performance.

    Now, ProxySQL gives you the complete list of quries you can put in cache. There are a lot of tables in these queries, like:
    wp_actionscheduler_actions
    wp_terms
    wp_postmeta
    wp_wc_admin_notes
    wp_posts
    And a lot more

    i have chosen the heaviest queries to put in cache. But the problem i have is that i don’t know which queries should i put in cache, because sometimes they give me problems (bugs) in the site.
    Some queries works fine and doesn’t cause any problems, but someothers causes a lot of bugs in site while they are in cache.

    Does someone knows which queries tables are correct to cache?

Viewing 1 replies (of 1 total)

  • This is a very dangerous approach to caching – there’s almost no way to know which queries will need to return updated results.

    If you want to make your site fast there are two techniques I’d use, instead.

    1. Use a premium cache like WP Rocket. It solves many problems instantly, automatically, and at install time (see below though).

    2. Tune your MySQL to have larger buffers, which will mean that it will hold much of the database in memory.

    And a free third tip:
    Move to Litespeed or Open Litespeed with Litespeed cache (and remove Rocket). This is probably faster than #1 above.

    Also make sure you’re using PHP 7, it’s much faster than 5.6.

    I know these recommendations are very specific; these are just what has worked for me very consistently over time.

    Oh – and delete that dangerous broken plugin!

    Cheers
    Brian

Viewing 1 replies (of 1 total)
  • The topic ‘Query Caching with ProxySQL’ is closed to new replies.