[wp-trac] [WordPress Trac] #55402: Check for and retain custom indexes on version upgrades

WordPress Trac noreply at wordpress.org
Wed Mar 16 16:23:30 UTC 2022

#55402: Check for and retain custom indexes on version upgrades
 Reporter:  amykamala    |      Owner:  (none)
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Database     |    Version:
 Severity:  normal       |   Keywords:
  Focuses:               |
 Currently Core database schema provides proper indexes for most tables and
 columns, however some core tables have columns that are not natively
 indexed, such as the _usermeta meta_value column. For larger enterprise
 sites that store a significant amount of user data, this becomes a
 potential performance bottleneck at-scale. As a solution, developers may
 add their own custom indexes to accommodate more efficient queries. Upon a
 core database upgrade, these custom indexes get removed and need to be re-

 To better support developers, WP may want to add a check for custom
 indexes prior to core DB updates, as well as retain or translate the
 schema customizations post-upgrade.


Ticket URL: <https://core.trac.wordpress.org/ticket/55402>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform

More information about the wp-trac mailing list