mysql的参数文件是什么_MySQL 参数文件及参数

查看参数

可以使用show variables like "variables_name" select @@session.variables_name select @@global.variables_name

如查看read_buffer_size

mysql> set read_buffer_size=524288;

Query OK, 0 rows affected (0.07 sec)

mysql> select @@session.read_buffer_size;

+----------------------------+

| @@session.read_buffer_size |

+----------------------------+

|                     524288 |

+----------------------------+

1 row in set (0.00 sec)

mysql> select @@global.read_buffer_size;

+---------------------------+

| @@global.read_buffer_size |

+---------------------------+

|                    131072 |

+---------------------------+

1 row in set (0.00 sec)

mysql> show variables like "read_buffer_size%";

+------------------+--------+

| Variable_name    | Value  |

+------------------+--------+

| read_buffer_size | 524288 |

+------------------+--------+

1 row in set (0.00 sec)

可以看到同样设置了read_buffer_size但是session和global却不一样 因为我设置的时候没有加global