slow query – Search for Media Gallery

• 

  maratovl · Member · Jan 4, 2017 at 11:02 am

  • Copy link
  • Add topic to favorites

  after update wordpress to 4.7 version Search in Media Gallery became very slowly performed. here is a log falls into the slow-queries.log:

  # Time: 2016-12-30T16:28:07.386551Z
  # User@Host: info_234[info_234] @ localhost [] Id: 6390731
  # Query_time: 4.187182 Lock_time: 1.953823 Rows_sent: 40 Rows_examined: 644073
  SET timestamp=1483115287;
  SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta AS sq1 ON ( wp_posts.ID = sq1.post_id AND sq1.meta_key = ‘_wp_attached_file’ ) WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%электр%’) OR (wp_posts.post_excerpt LIKE ‘%электр%’) OR (wp_posts.post_content LIKE ‘%электр%’) OR ( sq1.meta_value LIKE ‘%электр%’ ))) AND (wp_posts.post_mime_type LIKE ‘image/%’) AND wp_posts.post_type = ‘attachment’ AND ((wp_posts.post_status = ‘inherit’ OR wp_posts.post_status = ‘private’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 40;

  how to fix it?

  The blog I need help with is: (visible only to logged in users)

• 

  geoffreyshilling · Member · Jan 4, 2017 at 11:12 am

  • Copy link

  It looks like you are working with a self-hosted WordPress.org site instead of the WordPress.com-hosted version supported here.

  Learn more about the differences between WordPress.com and WordPress.org:
  https://en.support.wordpress.com/com-vs-org/

  I would recommend searching on the WordPress.org support forums for similar issues. If you cannot find anything that works, you can start your own thread. The forums are completely separate from each other, so you will need to register an account there if you haven’t done so already.

• 

  maratovl · Member · Jan 4, 2017 at 11:14 am

  • Copy link

  thanks