MySQL管理之道-笔记-MySQL5.7-在线调整innodb_buffer_pool_size
root@localhost:mysql3306.sock [(none)]>set global innodb_buffer_pool_size = 256*1024*1024; Query OK, 0 rows affected (0.18 sec)root@localhost:mysql3306.sock [(none)]>show variables like '%innodb_buffer_pool_size%';
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| innodb_buffer_pool_size | 268435456 |
+-------------------------+-----------+
row in set (0.02 sec)
root@localhost:mysql3306.sock [(none)]>select 268435456/1024/1024;
+---------------------+
| 268435456/1024/1024 |
+---------------------+
| 256.00000000 |
+---------------------+
row in set (0.00 sec)
root@localhost:mysql3306.sock [(none)]>select version();
+------------+
| version()|
+------------+
| 5.7.18-log |
+------------+
row in set (0.03 sec)
页:
[1]