[Systems] Huge oledrupal database

[Bernie Innocenti]

On Sat, 2011-12-10 at 18:49 -0500, Bernie Innocenti wrote:
> Today sunjammer ran out of space in the root filesystem.
> 
> I looked around and found that /var/lib/mysql had jumped to 25GB, mostly
> due to the oledrupal_* databases.
> 
> This one alone ia 16B:
> 
> -rw-rw---- 1 mysql mysql   151977852 Nov  8 11:47 watchdog.MYD
> -rw-rw---- 1 mysql mysql     7371776 Dec 10 18:36 watchdog.MYI
> -rw-rw---- 1 mysql mysql        8912 Dec  1  2010 watchdog.frm
> 
> mysql> select count(*) from watchdog;
> +----------+
> | count(*) |
> +----------+
> |   445634 |
> +----------+
> 1 row in set (0.00 sec)
> 
> So I wonder: what's this watchdog table for and why is it huge? Googling
> around reveals:
> 
>   http://stackoverflow.com/questions/3993908/can-i-truncate-sessions-and-watchdog-table-in-drupal
> 
> It seems we can safely TRUNCATE the table. Can I go ahead?

It seems we're not running this cleanup job:

 http://api.drupal.org/api/drupal/modules--dblog--dblog.module/function/dblog_cron/6

I'm running this query by hand from the sql prompt, but it's taking a
long time and I'm tempted to just recreate the table.

-- 
 _ // Bernie Innocenti
 \X/  http://codewiz.org