[wp-trac] [WordPress Trac] #36762: Slow queries

[WordPress Trac]

#36762: Slow queries
--------------------------+-----------------------------
 Reporter:  patzo         |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Query         |    Version:  4.5.1
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 hi guys,

 since our update, our website has been running very slow, so we disabled
 all the plugins and activated the twenty fifteen theme.

 we checked through query mentor and notched we have a very slow query in
 the includes/template.php 613  file

 the slow query is as follows;

 SELECT DISTINCT meta_key
 FROM wphq_postmeta
 WHERE meta_key NOT BETWEEN '_'
 AND '_z'
 HAVING meta_key NOT LIKE '\\_%'
 ORDER BY meta_key
 LIMIT 30

 our site was running fine and we only updated the wordpress core and we
 had issues. your advice would be great.

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