bayes mysql performance

[Jason Ede]

For information I finally tracked down the performance problems I was having with using bayes in mysql.

It seems that the inserts were taking an age to run and with multiple parallel inserts (i.e. multiple MS children) then the locks were slowing it down further. Changing the table types of all of the bayes tables from MyISAM to InnoDB using

ALTER TABLE bayes_seen ENGINE = innodb;

and repeating for each table seem to make a massive performance difference.

Jason

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20100407/d02476f1/attachment.html