OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
why the max value of innodb_buffer_pool_size is always 4G

From: wangchunning45 (wangchunning45163.com)
Date: Mon Aug 13 2007 - 05:20:14 CDT

I install MySQL on Linux 2.6.9-52bs #2 x86_64 x86_64 x86_64 GNU/Linux, 16G memory with followiing step: 1. ./configure --prefix=/home/mysql/mysql2. make3. make install I set innodb_pool_buffer_size = 8G in my.cnf, but when I use "show variables like 'innodb_buffer_pool_size';" the result is : +-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 4093640704 |
+-------------------------+------------+ and I change the innodb_pool_buffer_size to 5G in my.cnf, the result is+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 1996488704 |
+-------------------------+------------+ why?? chuning