TL;DR Make sure you increase innodb_buffer_pool_size from the stock value!
One of our client's servers (that we inherited from another developer) has been having some issues with high CPU load. Upon investigating, we found that MySQL was...
by Leon Miller-Out
I've now run into trouble when using "localhost" as my database server address with a couple of unrelated database servers, namely MySQL and Microsoft SQL Server. At this point, it seems like a good rule of thumb to always use...
by Leon Miller-Out
One of our clients has a MySQL server that sees moderate load. The MySQL server process often spikes one of the server's two CPUs. Without a lot of prior experience in tuning MySQL, I set out to figure out what was causing this...