[wp-trac] [WordPress Trac] #24044: Add index to wp_options to aid/improve performance

[WordPress Trac]

#24044: Add index to wp_options to aid/improve performance
--------------------------------+--------------------------
 Reporter:  DanBUK              |       Owner:
     Type:  enhancement         |      Status:  reopened
 Priority:  normal              |   Milestone:
Component:  Options, Meta APIs  |     Version:
 Severity:  major               |  Resolution:
 Keywords:  has-patch           |     Focuses:  performance
--------------------------------+--------------------------

Comment (by KalenJohnson):

 From my understanding, MySQL 5.5 by default uses InnoDB. Looks like
 [https://wordpress.org/about/stats/ statistics] have most likely gone up
 since this ticket was created. About 70% are on MySQL 5.5+, and 2% are on
 MariaDB :joy:

 So unless there are hosts that are switching from InnoDB to MyISAM by
 default, seems like the vast majority are now on InnoDB.

 And judging from the results people have been posting in the past 4
 months, seems like there are huge advantages to adding the index. Time to
 revisit?

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