[wp-trac] [WordPress Trac] #15004: Missing index on signups table

[WordPress Trac]

#15004: Missing index on signups table
------------------------------+------------------
 Reporter:  barry             |       Owner:
     Type:  defect (bug)      |      Status:  new
 Priority:  normal            |   Milestone:  3.5
Component:  Database          |     Version:
 Severity:  normal            |  Resolution:
 Keywords:  has-patch commit  |
------------------------------+------------------
Changes (by nacin):

 * keywords:  commit => has-patch commit


Comment:

 Before:

 || id || select_type || table || type || possible_keys || key || key_len
 || ref || rows || Extra ||
 || 1 || SIMPLE || wp31beta_signups || ALL ||  ||  ||  ||  || 30 || Using
 where ||

 After:

 || id || select_type || table || type || possible_keys || key || key_len
 || ref || rows || Extra ||
 || 1 || SIMPLE || wp31beta_signups || ref || user_email || user_email ||
 302 || const || 1 || Using where ||

 (Separately, you know what's fun? No primary key on the signups table.)

 New patch properly names the key and refreshes it against trunk.

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