With the increasing number of SQL errors visiting the pages, such as "SQL server went away", "table marked as crashed", etc. I tweaked a few settings a few minutes ago.
Ideally, things will start running faster and smoother with less hiccups. But, perhaps not.
Feel free to post under this topic to let me know what you are seeing.
ETA: After just an hour or so after making a few tweaks to the setup, the CPU load of MySQL is phenomenally lower.