Hi, I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL won't start if I set innodb_buffer_pool_size to >= 2GB. Here is my ulimit.
[EMAIL PROTECTED] mysql]# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 63484 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited Here is the error message: 050209 20:41:18 mysqld started 050209 20:41:18 [Warning] Asked for 196608 thread stack, but got 126976 050209 20:41:18 InnoDB: Fatal error: cannot allocate 2147500032 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 34049176 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! 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: Fatal error: cannot allocate the memory for the buffer pool 050209 20:41:18 [ERROR] Can't init databases 050209 20:41:18 [ERROR] Aborting I have also checked the archive and it looks like other people also having similar problem, but I couldn't find the answer. Is there any memory limit when it is run on linux? What can I do so MySQL can run with >= 2GB RAM? Thank you in advance. Regards, --bk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]