Re: InnoDB as storage engine for sa_bayes

2007-08-30 Thread Paweł Tęcza
"Paweł Tęcza" <[EMAIL PROTECTED]> writes: > Alex Woick <[EMAIL PROTECTED]> writes: >> Perhaps you played around and first imported the data without >> innodb_file_per_table, which imported into ibdata1. Then you perhaps >> dropped the tables and defined innodb_file_per table and imported >> again

Re: InnoDB as storage engine for sa_bayes

2007-08-30 Thread Paweł Tęcza
Alex Woick <[EMAIL PROTECTED]> writes: >> -rw-rw 1 mysql mysql 1010M Aug 28 08:25 ibdata1 > >> -rw-rw 1 mysql mysql 264M Aug 27 17:09 awl.ibd >> -rw-rw 1 mysql mysql 112K Aug 28 08:25 bayes_expire.ibd >> -rw-rw 1 mysql mysql 96K Aug 27 17:09 bayes_global_vars.ibd >> -rw-rw 1 m

Re: InnoDB as storage engine for sa_bayes

2007-08-29 Thread Alex Woick
> -rw-rw 1 mysql mysql 1010M Aug 28 08:25 ibdata1 > -rw-rw 1 mysql mysql 264M Aug 27 17:09 awl.ibd > -rw-rw 1 mysql mysql 112K Aug 28 08:25 bayes_expire.ibd > -rw-rw 1 mysql mysql 96K Aug 27 17:09 bayes_global_vars.ibd > -rw-rw 1 mysql mysql 468M Aug 27 21:11 bayes_seen.ibd >

InnoDB as storage engine for sa_bayes

2007-08-28 Thread Paweł Tęcza
Hello Spamassassins! ;) A few weeks ago I had problems with a capacity of my MySQL 5.0.38 server with sa_bayes database stored in MyISAM when it was handling a lot of SQL queries from my Spamassassin cluster. The only one solution was to disable using Bayes. I wrote about my problems here and I h