Скачать или смотреть Unlocking MySQL Global Variables: Using SELECT to Access SSL Status

Learn how to query MySQL global status variables using a `SELECT` statement, with a focus on SSL server status. Discover the method of accessing these vital server properties efficiently!
---
This video is based on the question https://stackoverflow.com/q/68184627/ asked by the user 'farhany' ( https://stackoverflow.com/u/90506/ ) and on the answer https://stackoverflow.com/a/68185047/ provided by the user 'Akina' ( https://stackoverflow.com/u/10138734/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Query MySQL global variables with a SELECT

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Unlocking MySQL Global Variables: Using SELECT to Access SSL Status

MySQL is a powerful database management system, and it provides users with various methods to manage and query system variables and status. However, many users are often puzzled about how to effectively query global status variables using a SELECT statement rather than the common SHOW commands. One common point of confusion revolves around status variables, particularly when looking for SSL server details, like Ssl_server_not_after. This guide will clearly explain how to access and query these global status variables in MySQL.

Understanding MySQL Global Status Variables

Before diving into the solution, let's clarify what global status variables are. These are metrics or statistics that give insights into the overall performance and state of the MySQL server at a given time. Unlike system variables, status variables don’t impact server behavior directly; they merely reflect the server's status.

The Challenge

A user asked if it was possible to access the global status variable Ssl_server_not_after using a typical SELECT statement. When attempting to access this variable using the command SELECT @ @ GLOBAL.Ssl_server_not_after, MySQL returns an error stating "Unknown variable." This is because status variables are treated differently compared to standard system variables.

The Solution: Querying Global Status Variables

To successfully query global status variables like Ssl_server_not_after, you need to tap into the performance_schema database, which contains detailed information about the performance of your MySQL server.

Steps to Query Global Status Variables

Accessing the performance_schema: Begin by ensuring that the Performance Schema is enabled on your MySQL server. This schema provides various tables to look up performance-related data.

Using the Correct Query:
Instead of using SELECT @ @ GLOBAL.variable_name, you should query the global_status table within the performance_schema as follows:

[[See Video to Reveal this Text or Code Snippet]]

Explanation of the Query:

The SELECT * statement retrieves all columns from the global_status table.

The WHERE clause filters the results, allowing you to search for specific SSL-related statuses.

Using LIKE 'Ssl_server_not%' helps to find all variables that start with Ssl_server_not, which includes Ssl_server_not_after among others.

Conclusion

Querying global status variables in MySQL is straightforward when you know where to look. By utilizing the Performance Schema, you can efficiently access a wealth of information about your server's performance status, including critical SSL parameters. This method empowers database administrators to closely monitor the status of their MySQL server and respond accordingly to maintain optimal performance.

If you’re looking to delve deeper into MySQL and enhance your database skills, this technique is a fantastic starting point. Don’t hesitate to experiment with various queries to uncover additional valuable status variables that can aid in your server management efforts. Happy querying!