Hi all, We're trying to get a new 64-bit machine going to get around the memory limitations of the 32-bit machines we have. On this dual Opteron server with 8GB memory we've installed Fedora Core 4 and MySQL 4.1.13.
Our sysadmin configured MySQL to use a 7GB buffer pool to accomodate a few big tables. After a while he needed to restart MySQL (made some changes somewhere) and it refused to do so: 050726 14:13:12 mysqld started 050726 14:13:12 InnoDB: Error: cannot allocate 7340048384 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 78086952 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: We keep retrying the allocation for 60 seconds... InnoDB: Fatal error: cannot allocate the memory for the buffer pool 050726 14:14:12 [ERROR] Can't init databases 050726 14:14:12 [ERROR] Aborting 050726 14:14:12 [Note] /usr/sbin/mysqld: Shutdown complete 050726 14:14:12 mysqld ended He then rebooted the entire server and: 050726 14:16:37 mysqld started 050726 14:16:41 InnoDB: Started; log sequence number 0 43635 /usr/sbin/mysqld: ready for connections. Version: '4.1.13-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) ...it runs happily again. Any ideas anyone on the cause and (more importantly) how to fix this problem? Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
