[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 JanR):

 Replying to [comment:45 KalenJohnson]:
 > [...]
 > So unless there are hosts that are switching from InnoDB to MyISAM by
 default, seems like the vast majority are now on InnoDB.
 >

 Unfortunately, upgrading your MySQL version to 5.5+ doesn't convert your
 existing MyISAM tables automagically... You'll need to do that yourself,
 either through MySQL/phpMyAdmin or using a plugin.

 > 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?

 Agreed! :) There is a number of plugins to convert MyISAM tables to
 InnoDB, and it's up to "us" (I work for a hosting company) to inform
 clients and customers about such important changes, and to recommend them
 to convert their existing database tables.

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