mysql 5.7 支持在线修改buffer_pool_size
select version();
show VARIABLES like "%buffer_pool_size%";
set global innodb_buffer_pool_size=15032385536;
mycli-TEST20: (none) 15:45:15>select version();
+------------+
| version() |
+------------+
| 5.7.16-log |
+------------+
1 row in set
Time: 0.030s
mycli-TEST2
mycli-TEST20: (none) 15:45:54>show variables like "%buffer_pool_size%"
+-------------------------+-------------+
| Variable_name | Value |
+-------------------------+-------------+
| innodb_buffer_pool_size | 17179869184 |
+-------------------------+-------------+
1 row in set
Time: 0.016s
mycli-TEST20: (none) 15:49:17> set global innodb_buffer_pool_size=15032385536;
Query OK, 0 rows affected
Time: 0.094s
0: (none) 16:19:33>show variables like "%buffer_pool_size%"
+-------------------------+-------------+
| Variable_name | Value |
+-------------------------+-------------+
| innodb_buffer_pool_size | 15032385536 |
+-------------------------+-------------+
1 row in set
Time: 0.054s