"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
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
> -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
>
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