WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #33885, comment 42


Ignore:
Timestamp:
03/24/2017 05:00:06 PM (5 years ago)
Author:
matt_fw
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #33885, comment 42

    initial v1  
    55This is not a bug, it's well documented and expected behaviour ([https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html].
    66
    7 The query is slow because MySQL can't use partial index on `meta_key` to optimize `ORDER BY` clause (at least for now). There is a workaround ( `innodb_large_prefix` ) mentioned in the documentation I linked to but it requires configuration changes to MySQL so it's not general solution.
     7The query is slow because MySQL can't use partial index on `meta_key` to optimize `ORDER BY` clause (at least for now). There is a workaround ( `innodb_large_prefix` ) mentioned in the documentation I linked to but it requires configuration changes to MySQL so it's not a general solution.