List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:July 26 2005 1:05pm
Subject:malloc troubles on 64-bit machine
View as plain text  
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.

Thread
malloc troubles on 64-bit machineJigal van Hemert26 Jul
  • Re: malloc troubles on 64-bit machineJoerg Bruehe26 Jul
  • Re: malloc troubles on 64-bit machineJigal van Hemert26 Jul
    • Re: malloc troubles on 64-bit machineJoerg Bruehe27 Jul
Re: malloc troubles on 64-bit machineMatthijs van der Klip29 Jul
  • Re: malloc troubles on 64-bit machineJoerg Bruehe29 Jul
    • Re: malloc troubles on 64-bit machineMatthijs van der Klip1 Aug
      • Re: malloc troubles on 64-bit machineJoerg Bruehe1 Aug
        • Re: malloc troubles on 64-bit machineMatthijs van der Klip8 Aug
          • Re: malloc troubles on 64-bit machineIngo Strüwing9 Aug