As mentioned in a previous thread, I'm migrating to SQL based bayes.
I performed the backup from the original bayes DB, which took about a minute to export. I then setup the SQL, and now am trying to import into it... but it has been running for m more than 6 hours!? When I check MySQL I see: mysql> SELECT COUNT(*) spam_count FROM bayes_token; +------------+ | spam_count | +------------+ | 3944353 | +------------+ 1 row in set (5.36 sec) It is incrementing, telling me it is doing something. I am running the sa-learn --restore in debug mode and the last section shows: [29103] dbg: replacetags: replacing tags [29103] dbg: replacetags: done replacing tags [29103] dbg: bayes: using username: root [29103] dbg: bayes: database connection established [29103] dbg: bayes: found bayes db version 3 [29103] dbg: bayes: Using userid: 3 [29103] dbg: bayes: not available for scanning, only 1 spam(s) in bayes DB < 200 [29103] dbg: config: score set 1 chosen. [29103] dbg: bayes: database connection established [29103] dbg: bayes: found bayes db version 3 [29103] dbg: bayes: Using userid: 3 [29103] dbg: bayes: database connection established [29103] dbg: bayes: found bayes db version 3 [29103] dbg: bayes: using userid: 4 I don't feel as if it is a MySQL problem, as I'm using the same instance for backends to other applications that do not have performance problems. For reference this is using SpamAssassin 3.1.7, on a 1.2Ghz w/ 1GB of RAM. my.cnf: [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M sql.cf (in /etc/mail/spamassassin): bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:spam_bayes:localhost bayes_sql_username spambayes bayes_sql_password ******** auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList user_awl_dsn DBI:mysql:spam_bayes:localhost bayes_sql_username spambayes bayes_sql_password ******** [EMAIL PROTECTED] spamassassin]# sa-learn --dump magic 0.000 0 3 0 non-token data: bayes db version 0.000 0 0 0 non-token data: nspam 0.000 0 0 0 non-token data: nham 0.000 0 2936345 0 non-token data: ntokens 0.000 0 1167206400 0 non-token data: oldest atime 0.000 0 1167764660 0 non-token data: newest atime 0.000 0 0 0 non-token data: last journal sync atime 0.000 0 0 0 non-token data: last expiry atime 0.000 0 0 0 non-token data: last expire atime delta 0.000 0 0 0 non-token data: last expire reduction count What am I missing? I'd be thankful for any input. Thanks, Dave
