欢迎光临
我们一直在努力

New features introduced in 8.0

mysql> set persist innodb_buffer_pool_size=2048*1024*1024;
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like 'innodb_buffer_pool_size';
+-------------------------+------------+
| Variable_name           | Value      |
+-------------------------+------------+
| innodb_buffer_pool_size | 2147483648 |
+-------------------------+------------+
1 row in set (0.00 sec)

mysql> set persist innodb_buffer_pool_size=4096*1024*1024;
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like 'innodb_buffer_pool_size';
+-------------------------+------------+
| Variable_name           | Value      |
+-------------------------+------------+
| innodb_buffer_pool_size | 4294967296 |
+-------------------------+------------+
1 row in set (0.00 sec)

mysql> 

[root@roidb3 data]# pwd
/zxdata/my3311/data
[root@roidb3 data]# ls -l mysqld-auto.cnf 
-rw-r-----. 1 mysql mysql 186 Dec 24 08:59 mysqld-auto.cnf
[root@roidb3 data]# more mysqld-auto.cnf 
{ "Version" : 1 , "mysql_server" : { "innodb_buffer_pool_size" : { "Value" : "4294967296" , "Metadata" : { "Timestamp" : 
1577149148131600 , "User" : "root" , "Host" : "localhost" } } } }
[root@roidb3 data]# 

持久化参数直接写入到mysqld-auto.cnf文件中。具体内容看官方文档。
赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。