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

[WordPress Trac]

#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