mysql命令行下查看
show variables like 'innodb_buffer_pool_size';
修改innodb_buffer_pool_size值:
windows下面 my.ini
Linux下面 my.cnf
修改[mysqld]下的
innodb_buffer_pool_size=1024M
重启mysql服务,mysql命令行下查看
mysql> show variables like 'innodb_buffer_pool_size';
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 1073741824 |
+-------------------------+------------+
1 row in set, 1 warning (0.00 sec)
success