Changeset 57155 for trunk/src/wp-admin/includes/upgrade.php

Timestamp:

12/04/2023 07:49:18 PM (16 months ago)

Author:

flixos90

Message:

Themes: Clean up inactive themes' theme mods from being autoloaded as part of upcoming 6.5 upgrade routine.

Alongside [57153], this reduces unnecessarily autoloaded data from inactive themes, which can contribute to slow database performance as part of excessive autoloading. This changeset specifically resolves the issue for existing sites.

Props mukesh27, joemcgill, swissspidy, westonruter, flixos90.
Fixes #59975.
See #39537.

File:

• trunk/src/wp-admin/includes/upgrade.php (modified) (2 diffs)

trunk/src/wp-admin/includes/upgrade.php

@@ -844 +844 @@
     }
 
+    if ( $wp_current_db_version < 57155 ) {
+        upgrade_650();
+    }
+
     maybe_disable_link_manager();
 
@@ -2351 +2355 @@
 
 /**
+ * Executes changes made in WordPress 6.5.0.
+ *
+ * @ignore
+ * @since 6.5.0
+ *
+ * @global int  $wp_current_db_version The old (current) database version.
+ * @global wpdb $wpdb                  WordPress database abstraction object.
+ */
+function upgrade_650() {
+    global $wp_current_db_version, $wpdb;
+
+    if ( $wp_current_db_version < 57155 ) {
+        $stylesheet = get_stylesheet();
+
+        // Set autoload=no for all themes except the current one.
+        $theme_mods_options = $wpdb->get_col(
+            $wpdb->prepare(
+                "SELECT option_name FROM $wpdb->options WHERE autoload = 'yes' AND option_name != %s AND option_name LIKE %s",
+                "theme_mods_$stylesheet",
+                $wpdb->esc_like( 'theme_mods_' ) . '%'
+            )
+        );
+
+        $autoload = array_fill_keys( $theme_mods_options, 'no' );
+        wp_set_option_autoload_values( $autoload );
+    }
+}
+
+/**
  * Executes network-level upgrade routines.
  *