• Resolved qlexio

    (@qlexio)


    Hello,
    I installed the last version of W3 Total Cache. Everything seems to work fine except the database cache.
    1/ The folders (/db/*) in wp-content/cache were not created. I did it myself. The last time I install W3 Total Cache, these folders in wp-content/cache/db/ were automatically deleted.
    2/ I get no cached queries showed in the db cache debug info even when I refresh the website.
    3/ In dbcache.log, I see “flush group (folder in /db/) everytime a request is done.

    Thanks for helping me to resolve this and make it work.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @qlexio

    I am sorry about the issue you are experiencing and I am happy to assist you with this.
    First, I can confirm that this was thoroughly tested and it is working as expected.
    Is Database cache enabled in Performance>General settings and which caching method are you using?
    Are you using any other plugin for DB caching or handling the DB?
    Is there a db.php drop-in in your wp-content folder?
    Thank you!

    Thread Starter qlexio

    (@qlexio)

    My database is enabled in General Setting and I am using Disk method.
    Object cache is also enabled with Disk method but I am not sure what to do with this to have a better experience.
    There is a db.php in my wp-content folder.

    When I check compatibility, “open basedir” is off and Memcache and Redis extensions are not installed. Memcache and Redis seem to be related to DB cache but I am not using it so I didn’t worry about it until now.

    WP-Optimize is installed but I disabled it before installing W3 Total Cache.
    I use Woocommerce plugins, Mailchimp for Woocommerce (enabled but not used), Advanced Dynamic Pricing for WooCommerce to manage discounts and Updraftplus to save my website.

    Hope this will help you.

    Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @qlexio

    there is a possibility that db.php is a drop in leftover from the previous plugin. YOu should manually delete it and let W3 Total Cache drop in the file.
    This being said, it is not recommended to use both DB cache and Object cache at the same time.
    If you are on shared hosting, then RAM-based caching is likely to be unavailable for you. And disk-based caching is not that efficient. In other words, if you are on shared hosting, it’s recommended not to use database caching.
    Moreover, using disk-database caching (on shared hosting) can make your site slower. This is so because getting data from the database can be faster than getting cached data from the disk.
    Object Cache allows getting data from the database more efficiently. Its purpose is similar to what Database Cache does. But compared to Database Cache, Object cache is more efficient as it allows you to process fewer requests.
    It can be beneficial to use if you are on VPS or dedicated server, get a lot of traffic, have a lot of comments. Also, if you know that database is the bottleneck of your website performance, then Object Cache (like Database Cache) is beneficial to use. But in this case, it’s recommended to use Memcached or Redis options.
    I hope this helps!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘W3 Total Cache Database Cache not working’ is closed to new replies.