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.
smime.p7s
Description: S/MIME Cryptographic Signature