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!