[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 and Meta  |     Version:  3.6
 Severity:  normal            |  Resolution:
 Keywords:  has-patch         |     Focuses:  performance
------------------------------+------------------------------

Comment (by DanBUK):

 Replying to [comment:29 pento]:

 How do you have your MySQL instance configured? (I'm really surprised your
 getting such slow results.)

 I have the following:-

 thread_cache_size = 8
 innodb_buffer_pool_size = 1G
 key_buffer_size = 128M
 table_cache = 1024

 (Running on a 2CPU / 2GB KVM Centos 6 VM, gah I just noticed it's only
 MySQL 5.1, will install 5.5 and re-test.)
 I added my MyISAM results as an attachment earlier.

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