Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #144502
    valis
    Guest

    I am considering using the database caching feature of W3 Total Cache PRO as I migrate my WordPress site from MySQL 5.7 to MySQL 8.0. Due to the large volume of data, we have benefited significantly from the query cache in MySQL 5.7, especially in the WordPress admin area (particularly the list views). However, after migrating to MySQL 8.0, we are experiencing significant performance degradation. While we can tolerate the slower initial load, subsequent loads are unacceptably slow, and the client has raised concerns about the overall performance.

    Given this situation, I would like to know if W3 Total Cache PRO can provide performance improvements comparable to the query cache in MySQL 5.7. Additionally, is it possible to use hooks, either from WordPress or from W3 Total Cache itself, to automatically purge the database cache when specific tables are updated?

    #144591

    Hello,

    Thank you for reaching out and I am happy to help!
    In W3 Total Cache, DB Caching is not a PRO feature and it can be used in the community version. Nothing in the Pro version does to help for DB Cachcing as, again, this is a free feature.
    Have you installed the W3TC and utilized the DB Caching? Also, please note that the best results would be to use memory-based caching like Redis or Memcached.
    You can also use Object Caching for faster performance.
    As for the hooks, I am not aware of any specific hooks for DB updates, however, you can call w3tc_dbcache_flush()

    I hope this helps!

    Thanks!

Viewing 2 posts - 1 through 2 (of 2 total)
  • The topic ‘Can W3 Total Cache PRO Replace MySQL 5.7 Query Cache in MySQL 8.0?’ is closed to new replies.