Archive for the new Category
Published July 9th, 2010
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 [...]
Published March 28th, 2010
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 [...]
Published October 2nd, 2009
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 [...]