关于innodb_buffer_pool_size的设置问题

streetboy85

请问mysql的文档不是说可以设置成内存的40%-80%吗？我的机子内存是4G的，装的是centos 5.2，按道理来说，应该是可以把innodb_buffer_pool_size设到3G的，可是设了之后，就有问题了，看了log，可能是需要把maximum process size调大，即设置login_process_size的值，但是我搜了一下，在centos5.2里面，好像没有/etc/dovecot.conf这个配置文件...
请大家指点指点！
PS:ulimits已经设为4096了

090401  9:23:04  InnoDB: Error: cannot allocate 3019915264 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 35493848 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
InnoDB: Fatal error: cannot allocate the memory for the buffer pool
090401  9:24:04 [ERROR] Plugin 'InnoDB' init function returned error.
090401  9:24:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

streetboy85

好的，谢谢！