快上网专注成都网站设计 成都网站制作 成都网站建设
成都网站建设公司服务热线:028-86922220

网站建设知识

十年网站开发经验 + 多家企业客户 + 靠谱的建站团队

量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决

Newfeaturesintroducedin8.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文件中。具体内容看官方文档。

网页标题:Newfeaturesintroducedin8.0
网页网址:http://6mz.cn/article/ggegip.html

其他资讯