If you need details about whats going on within your MySQL instance, the query log is still very useful, even though it’s not good for permanent use, since it costs performance and disk space. But with some luck you already … Continue reading
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