W3TC db spikes on some publish post

Hello @noticiassin

Thank you for reaching out and I am happy to assist you with this.

Can you please share which caching method you are using for DB caching and Object Caching? Is it set to Disk or you are using some memory bae caching?

Thanks!

Hi Marko, thanks for your quickly response sorry por my english is very basic.

I am using memcached for db and object cache and Redis for page cache.

regards

Hello @noticiassin

Thank you for your feedback.
Does this happen every time or any specific posts? Can you please clarify what the “sometimes” means?

At the moment I am not seeing any problems on the website and it loads very fast.

Thanks!

Hi Marko.

not on every publish, in some publishing, i am using google cloud i can share you a pic.

Hi Marko.

Everytime this statement run is when the db get 99.99%

SELECT

  p . ID,

  p . post_author,

  p . post_status,

  p . post_name,

  p . post_parent,

  p . post_type,

  p . post_date,

  p . post_date_gmt,

  p . post_modified,

  p . post_modified_gmt,

  p . comment_count

FROM

  mv_posts p

WHERE

  p . post_password = ?

  AND p . post_type = ?

  AND p . post_status = ?

  AND YEAR ( p . post_date_gmt ) = ?

  AND SQL_TSI_MONTH ( p . post_date_gmt ) = ?

ORDER BY

  p . post_date_gmt DESC

LIMIT

  ?

take about avg 13-32 seconds and block the db for that time, and show about 1200 rows.

I don’t know if this help but i am a w3tc pro user.

thanks

Hey @noticiassin

Thank you for your feedback.

This seems very random indeed. And this is a public form so all the support is free of course!

Can you please share how often this happens at least and can you please share how much memory is allocated to Redis?

Thanks!

Hi, i have 40GB for redis, memcached and the system indeed.

i figure it out that this select statement if from preload post cache and i disabled it, not happend for now.

thanks