Mysql8 시스템 변수

시스템 변수 속성
cmd-line	command-line options
option-file	options valid in configuration files
System Var	server system variables
Status Var	status variables
Var Scope	Global / Session / Both
Dynamic	Dynamic / Static

 

 

SELECT          VI.VARIABLE_NAME, GV.VARIABLE_VALUE,          VI.MIN_VALUE,VI.MAX_VALUE, VI.set_time, VI.SET_USER, VI.SET_HOST        FROM performance_schema.variables_info AS VI          INNER JOIN performance_schema.global_variables AS GV          USING(VARIABLE_NAME)        WHERE VI.VARIABLE_NAME like 'max_conn%'        ORDER BY VARIABLE_NAME;

 

https://dev.mysql.com/doc/refman/8.0/en/server-system-variable-reference.html

MySQL :: MySQL 8.0 Reference Manual :: 5.1.5 Server System Variable Reference

 

 

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

MySQL :: MySQL 8.0 Reference Manual :: 5.1.8 Server System Variables

 

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html

MySQL :: MySQL 8.0 Reference Manual :: 27.12.14.2 Performance Schema variables_info Table