[wp-trac] [WordPress Trac] #41223: wp_posts are very slow on larger sites

[WordPress Trac]

#41223: wp_posts  are very slow on larger sites
--------------------------+-----------------------------
 Reporter:  lubimow       |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:  4.8
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 I have Wordpress version 4.8 installed. But in a log of slow queries, I
 constantly have similar messages.


 {{{
 # Time: 2017-07-02T10:04:13.180832Z
 # User at Host: site_234[site_234] @ localhost []  Id: 1226011
 # Query_time: 2.109665  Lock_time: 0.000051 Rows_sent: 3  Rows_examined:
 183299
 SET timestamp=1498989853;
 SELECT ID FROM wp_posts where guid = 'https://example.org/uploads/500.jpg'
 AND post_type = 'attachment';
 }}}

 When I search for a photo by title in the media library, each found photo
 is displayed here with this code in the slow query log

--
Ticket URL: <https://core.trac.wordpress.org/ticket/41223>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform