Changing Default MySQL Temp Dir from /tmp to someting else

Today, we ran a repair table on a 32M record table as it was marked as crashed and as it was being repairing, we got disk warning on / root partition. After a quick investigation it looks like mysql tried to write temp files in /tmp, which happens ot be on root partition that was [...]

Freeing Disk Space from MyISM Table Space

Recently, we discovered that we have a ton of tables with lots of logging data in a large MySQL database that can be deleted to free up disk space. A simple PHP script that runs a query such as the following was used to remove the old data:

$table [...]

MySQL Blocked Becauase of Too Many Connections

This morning we found out that one of our MySQL server is blocking connection for all our Web servers due to too many connections. We solved the problem of too many connections that were coming from the Web server but still MysQL had the Web hosts blocked.
To unblock, we had to run the following command [...]