Re: bayes_seen on MySQL, growing and growing

2006-11-17 Thread Paolo Cravero
Jim Maul wrote: I dont use mysql with SA, but you should be able to use truncate instead of delete. It may very well be faster with all those rows. From MySQL 4.x manual: "For InnoDB, TRUNCATE TABLE is mapped to DELETE, so there is no difference." We're using InnoDB rather than MyISAM, s

Re: bayes_seen on MySQL, growing and growing

2006-11-13 Thread Jim Maul
Paolo Cravero wrote: Hi, while doing some checkup on production servers, I noticed that the bayes_seen table on MySQL is rather big: row: 15'814'021 (15.8Mr) size: 1'853'882'368 bytes ( 1.8GB) I've understood SA doesn't clean-up that table, so it has to be done manually. Can