MySQL is consuming lots of CPU

If MySQL is consuming a lot of your CPU resources or is maxing out your server, the best thing to do is login and watch the queries in realtime.  Login to the server as root, and run “gp mysql login root” and then run: show processlist; And you’ll see something like the following screen: This […]

MySQL is taking up a LOT of disk space. Why?

If you’re finding that your MySQL is taking up a large amount of disk space on your servers, and you’re not running any particularly large websites, it’s likely that this is due to how InnoDB works. What may be happening is your sites are storing a lot of temporary data inside the database. Each InnoDB table […]