mysql> show global status like ‘Innodb_buffer_pool_pages_data‘;
+-------------------------------+-------+
| Variable_name | Value |
+-------------------------------+-------+
| Innodb_buffer_pool_pages_data | 1728 |
+-------------------------------+-------+
1 row in set (0.00 sec)
mysql> show global status like ‘Innodb_buffer_pool_pages_total‘;
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| Innodb_buffer_pool_pages_total | 8191 |
+--------------------------------+-------+
1 row in set (0.00 sec)
mysql> show global status like ‘Innodb_page_size‘;
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Innodb_page_size | 16384 |
+------------------+-------+
1 row in set (0.00 sec)
mysql> SET GLOBAL innodb_buffer_pool_size=1073741824;
Query OK, 0 rows affected (0.01 sec)
或vim /etc/my.cnf
[mysqld]
innodb_buffer_pool_size = 1073741824
mysql修改 innodb_buffer_pool 大小笔记
原文：http://blog.51cto.com/zuoshou/2164818