bayes mysql performance
J.Ede at birchenallhowden.co.uk
Wed Apr 7 09:38:35 IST 2010
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the MailScanner