Michael Parker wrote:
> Dan Bongert wrote:
>> I'm in the process of converting my Bayes DB setup from in users' home
>> directories (since I'm setting up a separate SpamAssassin server, and
>> accessing Bayes via NFS is causing insane amounts of I/O).
>>
>> After a bunch of fiddling, I have a MySQL server set up properly,
tables
>> created, and a spamassassin user set up so I can populate the database.
>>
>> I have 432 users, with about 1.6 GB of Bayes data to import (from
sa-learn
>> --backup). I started the import last Friday around 10am, and it's still
>> running (Monday at 1pm), on user 379.
>>
>> My question is this: is this normal? I don't really have any SQL
>> administration experience, so this is all very new to me. For what it's
>> worth, I'm using InnoDB instead of MyISAM tables.
>
> Thats probably normal, import takes awhile with SQL since its a lot of
> inserts and updates.
That's good--I was hoping this wouldn't be a performance issue once the
system goes into production, though I guess we'll see about that.
I was curious about a couple settngs that I heard can affect performance
when using Innodb so I did a few ad hoc tests:
http://www200.pair.com/mecham/spam/mysqlspeed.txt
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://www.mysql.com/news-and-events/newsletter/2003-11/a0000000269.html
Gary V
_________________________________________________________________
Get the latest Windows Live Messenger 8.1 Beta version. Join now.
http://ideas.live.com
