[wp-trac] [WordPress Trac] #32449: wp-admin/includes/template.php meta_form query is causing full table scans in wordpress 4.2

WordPress Trac noreply at wordpress.org
Wed Jun 17 15:03:22 UTC 2015


#32449: wp-admin/includes/template.php meta_form query is causing full table scans
in wordpress 4.2
--------------------------+------------------------------------------
 Reporter:  jeichorn      |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  4.2
 Severity:  major         |  Resolution:
 Keywords:                |     Focuses:  administration, performance
--------------------------+------------------------------------------
Changes (by jstensved):

 * focuses:  administration => administration, performance
 * severity:  normal => major


Comment:

 I don't get any improvement from the patch but the table scan on
 wp_postmeta blocks the database and making one of my clients sites
 inaccessible in seconds.

 I suggest this ticket should have higher severity. On larger sites with
 lots of traffic and big wp_postmeta this can kill the db in seconds.

 It should definitely be tagged with performance in any circumstance.

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


More information about the wp-trac mailing list