MySQL Memory Limit

Running MySQL on a 32Bit-Linux will probably impose a 2GB limit for innodb_buffer_pool_size (seen on Debian + Ubuntu), even though you already installed the bigmem kernel.

Assuming more RAM is available and you desperately want to use it, it’s worth downloading the Intel-compiled community server edition.

I was able to reserve 6GB for the InnoDB pool with that piece of software on a 32Bit-Debian with bigmem kernel and the Intel-compiler often provides some extra performance.

Continue reading