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

[WordPress Trac]

#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-
 added.

 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.

 https://core.trac.wordpress.org/browser/tags/5.8.1/src/wp-
 admin/includes/upgrade.php

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