Re: Server won't start with innodb_buffer_pool_size over 1GB

[Heikki Tuuri]

Ryan,

which MySQL version is this?

When I tested this on 4.1.9, I got:

C:\mysql-4.1.9\mysql-4.1.9\client_debug>mysqld-debug --console
050218 16:54:20 InnoDB: Fatal error: cannot allocate 1207975936 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 10684100 bytes. Operating system errno: 1455
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
050218 16:54:20 [ERROR] Can't init databases
050218 16:54:20 [ERROR] Aborting

050218 16:54:20 [Note] mysqld-debug: Shutdown complete


C:\mysql-4.1.9\mysql-4.1.9\client_debug>


8 (ERROR_NOT_ENOUGH_MEMORY)

Not enough storage is available to process this command.

1455 is ERROR_COMMITMENT_LIMIT

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php