On Wed, 9 Feb 2005, Batara Kesuma wrote: > 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.
Are you trying this on a 32-bit cpu machine? > > [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]
