[wp-trac] [WordPress Trac] #24044: Add index to wp_options to aid/improve performance

WordPress Trac noreply at wordpress.org
Tue Aug 20 00:50:30 UTC 2019


#24044: Add index to wp_options to aid/improve performance
--------------------------------+--------------------------
 Reporter:  DanBUK              |       Owner:  pento
     Type:  defect (bug)        |      Status:  closed
 Priority:  normal              |   Milestone:  5.3
Component:  Options, Meta APIs  |     Version:
 Severity:  normal              |  Resolution:  fixed
 Keywords:  has-patch commit    |     Focuses:  performance
--------------------------------+--------------------------

Comment (by pento):

 @robinwilson16: If they use the same index name, a warning will be
 generated when the DB upgrade happens (on single sites, when `wp-admin` is
 visited next, on multisites, when a network admin does the DB upgrade). If
 they have a different index name, MySQL will create the index, IIRC.
 Having a duplicate index is sub-optimal, but not a deal breaker.

 As a general rule, we don't try to handle compatibility with altered
 schemas during upgrades: if  you've changed the schema, you'll need to
 handle an incompatibilities caused.

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


More information about the wp-trac mailing list