[wp-trac] [WordPress Trac] #53958: Database: wp_postmeta - meta_key index

WordPress Trac noreply at wordpress.org
Thu Aug 19 10:15:55 UTC 2021

#53958: Database: wp_postmeta - meta_key index
 Reporter:  wishe         |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  5.8
 Severity:  major         |  Resolution:
 Keywords:                |     Focuses:

Comment (by rafalsokolowski):

 Confirmed. Removing the index prefix length speeds up queries on
 wp_postmeta table.

 Is it safe to remove it if the longest meta_key record in the table is
 shorter than 191?
 Also, is it related to database encoding (utf8mb4)?

Ticket URL: <https://core.trac.wordpress.org/ticket/53958#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform

More information about the wp-trac mailing list