So I kept running into some issues with a CPanel server I’d setup, typically the default mySQL configuration is all I use, where it was running out of RAM regularly. The server was a CentOS VPS running 2 vCPU’s and 1GB of RAM 2GB of SWAP which should be plenty for the sites it was configured to host. The mySQL configuration wasn’t the cause but during investigations I learnt more about the necessity to refine the mySQL configuration to improve performance! I also delved into saving memory in apache configuration but that is for another post. Above is a great video posted by CPanel themselves and I highly recommend watching and learning its content to better understand and help you configure and manage your mySQL deployment(s).
Link to the original post: http://videos.cpanel.net/mysql-optimization/
Link to the slides in the video in PDF: http://www.cpanel.net/2010_Slides/MySQL_Optimization.pdf