Changeset 51522 for trunk/src/wp-admin/includes/class-wp-debug-data.php

Timestamp:

08/01/2021 02:00:17 PM (3 years ago)

Author:

SergeyBiryukov

Message:

Site Health: Add some more MySQL information to the Site Health Info screen.

This adds three values to the debug info in the Database section:

• Max allowed packet size
• Max connections number
• Query cache size

Props zodiac1978, donmhico, mukesh27, SergeyBiryukov.
Fixes #53845.

File:

• trunk/src/wp-admin/includes/class-wp-debug-data.php (modified) (2 diffs)

trunk/src/wp-admin/includes/class-wp-debug-data.php

@@ -924 +924 @@
             'value'   => $wpdb->collate,
             'private' => true,
+        );
+
+        $info['wp-database']['fields']['max_allowed_packet'] = array(
+            'label' => __( 'Max allowed packet size' ),
+            'value' => self::get_mysql_var( 'max_allowed_packet' ),
+        );
+
+        $info['wp-database']['fields']['max_connections'] = array(
+            'label' => __( 'Max connections number' ),
+            'value' => self::get_mysql_var( 'max_connections' ),
+        );
+
+        $info['wp-database']['fields']['query_cache_size'] = array(
+            'label' => __( 'Query cache size' ),
+            'value' => self::get_mysql_var( 'query_cache_size' ),
         );
 
@@ -1446 +1461 @@
 
     /**
+     * Returns the value of a MySQL variable.
+     *
+     * @since 5.9.0
+     *
+     * @param string $var Name of the MySQL variable.
+     * @return string|null The variable value on success. Null if the variable does not exist.
+     */
+    public static function get_mysql_var( $var ) {
+        global $wpdb;
+
+        $result = $wpdb->get_row(
+            $wpdb->prepare( 'SHOW VARIABLES LIKE %s', $var ),
+            ARRAY_A
+        );
+
+        if ( ! empty( $result ) && array_key_exists( 'Value', $result ) ) {
+            return $result['Value'];
+        }
+
+        return null;
+    }
+
+    /**
      * Format the information gathered for debugging, in a manner suitable for copying to a forum or support ticket.
      *