Changeset 51522

Timestamp:

08/01/2021 02:00:17 PM (5 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.
          *