bayes mysql performance

[Lance Haig]

And Just when I am about to cluster my DB backend

Thanks for the great tip.

Lance


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 
> difference.
>
> Jason
>
>
> -- 
> This message was scanned by Better Hosted and is believed to be clean.
> Click here to report this message as spam 
> <http://mx1.betterhosted.com/cgi-bin/learn-msg.cgi?id=BB58E9F1A2.A12B6> 


--
This message was scanned by Better Hosted and is believed to be clean.
http://www.betterhosted.com

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