noticiassin

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

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.

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