My curent config works great but my innodb_buffer_pool_size is too small as the database is very large.
All I am changing in my MySQL.cnf is
innodb_buffer_pool_size = 1G
innodb_buffer_pool_size = 2G
I then try and restart MySQL and it errors with the following..
110715 8:44:48 InnoDB: Error: cannot allocate 2147500032 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 25166072 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: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
This is a 4GB x86 machine dedicated to MySQL!