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.
