bayes mysql performance
lhaig at haigmail.com
Wed Apr 7 15:29:46 IST 2010
And Just when I am about to cluster my DB backend
Thanks for the great tip.
On 07/04/2010 09:38, Jason Ede wrote:
> 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
> This message was scanned by Better Hosted and is believed to be clean.
> Click here to report this message as spam
This message was scanned by Better Hosted and is believed to be clean.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the MailScanner