# 參數(shù)查詢
show global variables like 'var_name'; //查看全局系統(tǒng)變量的值，可使用%通配符
show session variables like 'var_name'; //查看會(huì)話系統(tǒng)變量的值
show  variables like 'var_name'; //優(yōu)先返回會(huì)話系統(tǒng)變量，若會(huì)話系統(tǒng)變量不存在，則返回全局系統(tǒng)變量。

# 也可用select查詢某個(gè)特定參數(shù)
select @@global.var_name; //全局系統(tǒng)變量
select @@session.var_name; //會(huì)話系統(tǒng)變量
select @@var_name; //優(yōu)先會(huì)話系統(tǒng)變量

# 查詢示例
mysql> show global variables like 'server_id';
+---------------+---------+
| Variable_name | Value |
+---------------+---------+
| server_id | 1003306 |
+---------------+---------+
1 row in set (0.00 sec)

mysql> show global variables like 'log_bin%';
+---------------------------------+-------------------------------+
| Variable_name   | Value    |
+---------------------------------+-------------------------------+
| log_bin    | ON    |
| log_bin_basename  | /data/mysql/logs/binlog |
| log_bin_index   | /data/mysql/logs/binlog.index |
| log_bin_trust_function_creators | ON    |
| log_bin_use_v1_row_events | OFF    |
+---------------------------------+-------------------------------+
5 rows in set (0.00 sec)

mysql> select @@server_id;
+-------------+
| @@server_id |
+-------------+
| 1003306 |
+-------------+
1 row in set (0.00 sec)

# 動(dòng)態(tài)修改參數(shù)
set global var_name = value;
set session var_name = value;
set var_name = value;

set @@global.var_name = value;
set @@session.var_name = value;
set @@var_name = value;

# 參數(shù)修改示例
mysql> set global sort_buffer_size = 2097152;
Query OK, 0 rows affected (0.00 sec)

mysql> set session sort_buffer_size = 4194304;
Query OK, 0 rows affected (0.00 sec)

mysql> select @@global.sort_buffer_size,@@session.sort_buffer_size;
+---------------------------+----------------------------+
| @@global.sort_buffer_size | @@session.sort_buffer_size |
+---------------------------+----------------------------+
|   2097152 |   4194304 |
+---------------------------+----------------------------+
1 row in set (0.00 sec)

vi /etc/my.cnf
# 簡(jiǎn)單模板如下：
[mysqld]
user = mysql 
datadir = /data/mysql/data  
socket = /data/mysql/tmp/mysql.sock
pid-file = /data/mysql/tmp/mysqld.pid 
skip_name_resolve = 1
max_connections = 2000
lower_case_table_names = 1
log_timestamps=SYSTEM
max_allowed_packet = 32M
...