Hello, i have a question, i’m using W3 Total Cache with few sites (with page cache) and every time i have a query’s like this (which i assume is non cached), mysql usage jumps to 100% sometimes 200%.
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘dt_views_count’ AND wp_postmeta.meta_value >= ‘1579165442’ )
) AND wp_posts.post_type IN (‘funny’, ‘wtf’) AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 20
I found W3 Total Cache had a option to Cache DATABASE but this option have a default “ignore caching query” list
^\sinsert\b
^\sdelete\b
^\supdate\b
^\sreplace\b
^\screate\b
^\salter\b
^\sshow\b
^\sset\b
\bsql_calc_found_rows\b
\bfound_rows()
\bautoload\s+=\s+‘yes’
my question is if i can safely delete
\bsql_calc_found_rows\b
\bfound_rows()
and start caching querys without issues or this can broke my site on any way?
i watched for mysql query on realtime for a while and all querys running starts with “SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON” this is why i assume this is the query causing high usage (on the cached websites).