[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        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by lubimow):

 Replying to [comment:2 jrchamp]:
 > Hi @lubimow! The slow query you mentioned does not appear to be coming
 from WordPress core (the lowercase 'where' is very suspicious). It is
 likely coming from a plugin or your theme. For your site, you may want to
 consider adding an index to the guid column in the wp_posts table if the
 plugin/theme author is unable to provide fix.

 Thanks for the advice, and what should I do if I use innodb
 I was told that your advice would not work on innodb

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