Mysql myisam-sort-buffer-size参数

官网连接：https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_myisam_recover_options

https://www.cndba.cn/hbhe0316/article/22615

https://www.cndba.cn/hbhe0316/article/22615

The size of the buffer that is allocated when sorting MyISAM indexes during a REPAIR TABLE or when creating indexes with CREATE INDEX or ALTER TABLE.https://www.cndba.cn/hbhe0316/article/22615https://www.cndba.cn/hbhe0316/article/22615https://www.cndba.cn/hbhe0316/article/22615

1.设置session级别的参数

https://www.cndba.cn/hbhe0316/article/22615

mysql> set session myisam_sort_buffer_size=128*1024*1024;
Query OK, 0 rows affected (0.00 sec)

2.设置global级别的参数

https://www.cndba.cn/hbhe0316/article/22615

https://www.cndba.cn/hbhe0316/article/22615

mysql> set global myisam_sort_buffer_size=128*1024*1024;
Query OK, 0 rows affected (0.00 sec)

3.设置/etc/my.cnf文件https://www.cndba.cn/hbhe0316/article/22615

[root@mysql57 ~]# cat /etc/my.cnf | grep -i myisam-sort
myisam-sort-buffer-size = 128M
[root@mysql57 ~]# service mysqld restart
Shutting down MySQL.. SUCCESS! 
Starting MySQL. SUCCESS!

4.查看是否设置成功https://www.cndba.cn/hbhe0316/article/22615

mysql> SHOW VARIABLES LIKE 'myisam_sort_buffer_size';
+-------------------------+-----------+
| Variable_name           | Value     |
+-------------------------+-----------+
| myisam_sort_buffer_size | 134217728 |
+-------------------------+-----------+
1 row in set (0.00 sec)

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL