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文件中。具体内容看官方文档。
New features introduced in 8.0
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。