为什么innodb_pool_buffer_size的最大值只能到4G
我在 Linux 2.6.9 x86_64 GNU/Linux, 16G 内存的操作系统上用源码安装MySQL4.0.16,执行步骤如下:
1. ./configure --prefix=/home/mysql/mysql
2. make
3. make install
在 my.cnf中我设置 innodb_pool_buffer_size = 8G,但当我用命令"show variables like 'innodb_buffer_pool_size';时,结果为4G:
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 4093640704 |
+-------------------------+------------+
然后我在my.cnf中将 innodb_pool_buffer_size 修改为 5G,上面的结果变为:
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 1996488704 |
+-------------------------+------------+
不知道为什么?请高手指教!!