[wp-trac] [WordPress Trac] #37923: Introduce shared wp_blogmeta database table for multisite installations

[WordPress Trac]

#37923: Introduce shared wp_blogmeta database table for multisite installations
--------------------------------+------------------------------
 Reporter:  johnjamesjacoby     |       Owner:
     Type:  feature request     |      Status:  new
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Networks and Sites  |     Version:
 Severity:  normal              |  Resolution:
 Keywords:  2nd-opinion         |     Focuses:  multisite
--------------------------------+------------------------------

Comment (by iamfriendly):

 A list of all options created, by default, (4.7.1) when a new site is
 added to a network. Additionally, suggested candidates for what might move
 from `wp_#_options` to `wp_blogmeta` are indented and in bold.

 https://docs.google.com/document/d/1bMajucj7vVLP2xFIoTC5BdOTzF5jEfnYcrxrVEdVH5I/edit?usp=sharing

 Namely:

 `admin_email` - getting a list of all site's default admins seems useful
 (we do it regularly, for example)
 `blog_public` - finding out which sites are public more easily seems like
 something that would speed up other queries for the REST API for example
 `blogdescription` - seems to go in parallel with other info currently in
 my-sites
 `blogname` - used in my-sites
 `db_version` - I could be dissuaded on this, but seems useful to check if
 all sites on a network are up-to-date
 `finished_splitting_shared_terms` - same logic as above, can be dissuaded
 `home` - my-sites
 `siteurl` - my-sites

 Whilst I can think of ways in which many of the other options would be
 useful, I've taken a somewhat minimal approach here to try and prevent a
 huge amount of data being transferred during the initial migration as well
 as simply polluting this new table.

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