MySQL5.7新特性之在线动态修改innodb_buffer_pool_size
在MySQL5.7之前的版本中，innodb_buffer_pool_size不能在线修改，只能重启MySQL进程进行修改。MySQL5.7开始可以在线动态修改其大小。
在MySQL5.6测试环境：
查看innodb_buffer_pool_size大小
在MySQL5.6测试环境：
点击(此处)折叠或打开
-
mysql> select version();
-
+-----------+
-
| version() |
-
+-----------+
-
| 5.6.36 |
- +-----------+
点击(此处)折叠或打开
-
mysql> show variables like 'innodb_buffer_pool_size';
-
+-------------------------+-----------+
-
| Variable_name | Value |
-
+-------------------------+-----------+
-
| innodb_buffer_pool_size | 134217728 |
- +-------------------------+-----------+
- 修改innodb_buffer_pool_size大小
-
在MySQL5.7测试环境：点击(此处)折叠或打开
-
mysql> set global innodb_buffer_pool_size=500*1024*1024;
- ERROR 1238 (HY000): Variable 'innodb_buffer_pool_size' is a read only variable
-
mysql> set global innodb_buffer_pool_size=500*1024*1024;
-
点击(此处)折叠或打开
-
mysql> select version();
-
+------------+
-
| version() |
-
+------------+
-
| 5.7.18-log |
- +------------+
- 查看当前innodb_buffer_pool_size大小。
-
点击(此处)折叠或打开
-
mysql> show variables like 'innodb_buffer_pool_size';
-
+-------------------------+-----------+
-
| Variable_name | Value |
-
+-------------------------+-----------+
-
| innodb_buffer_pool_size | 536870912 |
- +-------------------------+-----------+
- 修改innodb_buffer_pool_size大小：
-
查看innodb_buffer_pool_size大小：点击(此处)折叠或打开
-
mysql> set global innodb_buffer_pool_size=800*1024*1024;
- Query OK, 0 rows affected, 1 warning (0.00 sec)
-
mysql> set global innodb_buffer_pool_size=800*1024*1024;
-
点击(此处)折叠或打开
-
mysql> show variables like 'innodb_buffer_pool_size';
-
+-------------------------+-----------+
-
| Variable_name | Value |
-
+-------------------------+-----------+
-
| innodb_buffer_pool_size | 939524096 |
- +-------------------------+-----------+
-
mysql> show variables like 'innodb_buffer_pool_size';
-
-
mysql> show variables like 'innodb_buffer_pool_size';
-
mysql> select version();
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30135314/viewspace-2144496/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
