[wp-trac] [WordPress Trac] #34870: dbDelta Not Specifying Key Length Duplicate Indexes

WordPress Trac noreply at wordpress.org
Tue Apr 4 20:38:04 UTC 2017

#34870: dbDelta Not Specifying Key Length Duplicate Indexes
 Reporter:  charlestonsw  |       Owner:  pento
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  4.8
Component:  Database      |     Version:  2.8.1
 Severity:  normal        |  Resolution:  fixed
 Keywords:  has-patch     |     Focuses:  performance

Comment (by mnelson4):

 > We could try to calculate the number of affected rows inside of
 dbDelta() and set a reasonable default threshold where these kinds of
 alter's are allowed to run automatically.


 Or network admins could decide (there could be a constant which could
 control whether we want to automatically modify DB key lengths). They will
 probably know best if they want automatic key length modifications (and if
 they aren't going to do it automatically, they need to figure out some
 other system to do it manually).

Ticket URL: <https://core.trac.wordpress.org/ticket/34870#comment:23>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform

More information about the wp-trac mailing list