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
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