## 1. innodb_buffer_pool_size 1. 备份配置文件 ~~~ cp /etc/mysql/my.cnf /etc/mysql/my.cnf_20171222 ~~~ 2. 修改配置文件 ~~~ vim /etc/mysql/my.cnf [mysqld] innodb_buffer_pool_size=1G ~~~ 3. 重启mysql ~~~ service mysql restart ~~~ 4. 查看修改后的效果 ~~~ show global variables like 'innodb_buffer_pool_size'; ~~~