[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:  new
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:  3.6
 Severity:  normal              |  Resolution:
 Keywords:  has-patch           |     Focuses:  performance
--------------------------------+------------------------------

Comment (by JanR):

 I hope you don't mind me barging in here... A referrer from ticket #29637
 to my site brought me to this ticket, and apparently it has been submitted
 more than once (#14258). So there is some demand for this.

 In a live-situation, adding an index on the autoload column resulted in a
 drop of examined rows, from 33927 to 1508. I call that significant. The
 real performance gain depends on a lot of factors, I know, but I just
 wanted to share these numbers.

 PS: before one starts to install and test with MySQL 5.5 (or 5.6 for that
 matter), notice the `innodb_buffer_pool_instances` *and*
 `innodb_buffer_pool_size` settings. One can even increase InnoDB
 performance by adjusting `innodb_write_io_threads` and
 `innodb_read_io_threads`. As long as you have the RAM. Don't use MyISAM
 (IMO).

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