DELETE FROM fsck_log

dormando dormando at rydia.net
Sun Oct 14 00:58:26 UTC 2007


Hey all,

server/lib/MogileFS/Store.pm:1346:    $self->dbh->do("DELETE FROM 
fsck_log");

Now, in MySQL 5.0+ at least, 'TRUNCATE TABLE' over InnoDB is not be crap.

But, uh. This is bizarre enough that I'd like to run it by anyone else 
on the list before committing. Any reason _not_ to prefer 'TRUNCATE 
TABLE fsck_log' here? Postgres?

The fsck_log tables I've been having in "production" are always over a 
few million rows :)

Thanks,
-Dormando


More information about the mogilefs mailing list