Mysql> set persist innodb_buffer_pool_size=2048*1024*1024; Query OK, 0 rows affected (0.01 sec) mys
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文件中。具体内容看官方文档。
--结束END--
本文标题: New features introduced in 8.0
本文链接: https://lsjlt.com/news/39578.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0