MySQL view global variables and set values for global variables

1. View the values of all global variables for MySQL

SHOW GLOBAL VARIABLES

Or

SHOW VARIABLES

MySQL has a lot of global variables, including some basic information about the system, and some basic configuration of MySQL can be found in the global variables.

2. View the value of a single global variable for MySQL

' Wait_timeout '

The above query can also use fuzzy query, the same as the above results of the fuzzy query statement

' wait_time% '  '%wait%'

Note: It is also possible to view the global variables of MySQL without adding the global keyword, for example

SHOW variablesshow   ' %wait% ' SHOW   ' Wait_timeout ' SHOW   ' %wait% '

3. Setting the value of a global variable

SET GLOBAL  604800604800

SET GLOBAL Event_scheduler ==11

MySQL view global variables and set values for global variables