New parameters take effect. changes to these parameters will be restored when the MYSQL service is restarted. If you want to load the changes during the restart, You need to modify the configuration file. Modify the global variable mysqlshowvariableslike % sort_buffer_size %; ------------------------------------- | Variable_name | Value |-
New parameters take effect. changes to these parameters will be restored when the MYSQL service is restarted. If you want to load the changes during the restart, You need to modify the configuration file. Modify the global variable mysql show variables like '% sort_buffer_size %'; ------------------------------------- | Variable_name | Value |-
New parameter values take effect. changes to these parameters will be restored when the MYSQL service is restarted. If you want to load the changes during the restart, You need to modify the configuration file.
Modify global variables
Mysql> show variables like '% sort_buffer_size % ';
+ --------------------------- + ------------ +
| Variable_name | Value |
+ --------------------------- + ------------ +
| Sorting _ buffer_size | 6291448 |
+ --------------------------- + ------------ +
1 rows in set (0.00 sec)
Use the set GLOBAL command to set GLOBAL variables
Mysql> set GLOBAL sort_buffer_size = 7000000;
Query OK, 0 rows affected (0.00 sec)
Mysql> show variables like '% sort_buffer_size % ';
+ --------------------------- + ------------ +
| Variable_name | Value |
+ --------------------------- + ------------ +
| Sorting _ buffer_size | 6291448 |
+ --------------------------- + ------------ +
Reference: http://blog.csdn.net/turkeyzhou/article/details/5741626