[wp-trac] [WordPress Trac] #2699: Make option_name index unique

[WordPress Trac]

#2699: Make option_name index unique
------------------------------+---------------------------------------------
 Reporter:  johnjosephbachir  |        Owner:  ryan    
     Type:  task (blessed)    |       Status:  reopened
 Priority:  high              |    Milestone:  2.9     
Component:  Optimization      |      Version:  2.8     
 Severity:  normal            |   Resolution:          
 Keywords:  tested            |  
------------------------------+---------------------------------------------

Comment(by Denis-de-Bernardy):

 Replying to [comment:41 johnjosephbachir]:
 > At any rate-- as I noted in a comment above, I've never seen a slow
 query log entry based on a select on autoload, so for whatever reason
 MySQL doesn't end up needing it. Although, jdub above notes an instance
 where adding an index on it solved a problem for a particular
 installation. jdub, do you have any more info for us?

 NDB clusters like it when there are plenty of indexes.

 @Barry: thanks!

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/2699#comment:44>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software