[Systems] Huge oledrupal database

Bernie Innocenti bernie at sugarlabs.org
Sat Dec 10 18:49:46 EST 2011


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?

-- 
Bernie Innocenti
Sugar Labs Infrastructure Team
http://wiki.sugarlabs.org/go/Infrastructure_Team




More information about the Systems mailing list