WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 6 of Ticket #32449


Ignore:
Timestamp:
06/17/2015 05:39:02 AM (10 years ago)
Author:
dd32
Comment:

Replying to dd32:

I have verified that the updated query in #24498 does not improve performance in 4.2.

I'm seeing the opposite, it appears to restore the index usage, and is faster.

I take that back, while it does restore the usage of the index for me, it's not significantly faster.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #32449

    • Property Focuses administration added
    • Property Component changed from General to Database
    • Property Version changed from 4.2.2 to 4.2

  • Ticket #32449 – Description

    initial v6  
    11It looks like the changes to indexes for utf8_mb4 is breaking this query.
    22
     3{{{
    34SELECT meta_key
    4                 FROM $wpdb->postmeta
     5                FROM wp_postmeta
    56                GROUP BY meta_key
    6                 HAVING meta_key NOT LIKE %s
     7                HAVING meta_key NOT LIKE '\\_%'
    78                ORDER BY meta_key
    8                 LIMIT %d";
     9                LIMIT 30
     10}}}
    911
    1012Its always doing a full table scan now.  On a site with 7 million rows in postmeta this takes a long time.