[wp-trac] [WordPress Trac] #31071: media / post_mime_type related queries are very slow on larger sites

[WordPress Trac]

#31071: media / post_mime_type related queries are very slow on larger sites
------------------------------------------+--------------------------
 Reporter:  archon810                     |       Owner:  jnylen0
     Type:  defect (bug)                  |      Status:  closed
 Priority:  normal                        |   Milestone:  4.7.4
Component:  Media                         |     Version:  4.1
 Severity:  normal                        |  Resolution:  fixed
 Keywords:  has-patch commit fixed-major  |     Focuses:  performance
------------------------------------------+--------------------------

Comment (by lubimow):

 I now have 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';
 }}}

 With what it can be connected? How can this problem be solved? I have a
 lot of photos.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/31071#comment:78>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform