A log of unfortunate events, probably mostly sysadmin related.
Table of contents
Clean Your Logs
Added Wed Sep 3 12:10:02 PDT 2008.
I have a database at work that has Ruby in front of it. The devs set up a
logged_exceptions table, into which Ruby puts any exceptions that occure, so
there's a record.
We forgot to set up reaping.
It should be being reaped to 30 days, at most. The earliest entries are from
late 2007. We've had a few cases where bad releases meant hundreds of
exceptions a second.
I discovered today that that table, SQL dumped, is 56GiB.
The rest of the database as an SQL dump is 19GiB.
It turns out that it *is* possible to have a table so large that "truncate
table" takes measurable time. it's up to 3400 seconds, in fact, as I write this.
Oh. "For an InnoDB table before version 5.0.3, InnoDB processes
TRUNCATE TABLE by deleting rows one by one."
(http://dev.mysql.com/doc/refman/5.0/en/truncate.html). That'd do
it then. Time to DROP and CREATE.