AutoLink Movable Type plugin clogged database repair
I don’t remember now exactly what the problem was, but at some point I discovered the AutoLink plugin was failing in Movable Type 5.01, filling the database with log entries till it grew many gigabytes.
[lib]# du -sh mysql/badgerh_*
This is the MySQL query I ran to clear out those log entries:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6153153
Server version: 5.1.31 MySQL Community Server (GPL) by Remi
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use badgerh_mt.5.01
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
mysql> delete from mt_log where log_message like 'AutoLink died with%';
Query OK, 24797414 rows affected (51 min 6.40 sec)