[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