查看变量方法查看全局级别的系统变量
show global variables \G;
#查看所有跟"版本”相关的属性值
show global variables like '%version%'\G;
#查看字符集相关的全局设置
show global variables where variable_name like 'character%';
#查看某些日志是否开启或关闭
show global variables where variable_name like '%log%' and vale='off'; 查看会话级别的参数值
show session variables \G;
show variables; 其他语法
select @@[global.|session.]system_var_name
select @@global.pid_files;
select @@session.warning_count; 修改变量值/设定变量值 SET GLOBAL var_name = value;
SET @@GLOBAL.var_name = value;
SET SESSION var_name = value;
SET @@SESSION.var_name = value;
|
