21.6.2011 21:10, David F. Skoll kirjoitti: > On Tue, 21 Jun 2011 21:06:49 +0300 > Jari Fredriksson <ja...@iki.fi> wrote: > >>> Our main database is 255MB, consisting of 6 220 831 tokens from >>> 731 289 spam messages and 900 447 non-spam messages. Each user >>> potentially has his/her own Bayes database in addition to the >>> central one, so the total Bayes data on one of our clusters is >>> 1.3GB or so. > >> And that is too much for MySQL? LOL. > > I never implied it was too _big_ for MySQL. All I'm saying is I > don't _trust_ MySQL, and can guarantee that local .cdb files will > outperform it for this workload by a factor of 5 or more. >
Are you sure you are not using MyISAM tables? When they lock, they lock the entire table, which is BAD for performance if there are multiple clients or threads using the database. InnoDB engine is much better. -- You are number 6! Who is number one?
signature.asc
Description: OpenPGP digital signature
