problem with the Bayesian filter

Tue, 09 Mar 2010 10:24:54 -0800

My Bayesian filter keeps getting screwed up and causing mail flow to stop. The problem seems to be expiring tokens out of the database. My expiry setting is set to 200,000. I've tried many different settings for this but they all seem to behave about the same. Auto learn is also on.
When this happens the mysqld service eats up loads of CPU and stops responding to requests from Amavisd-new. Since Amavisd-new is expecting information from mysqld it stops the mail flow. I attached the output from the 'show processlist' command, one query seems to have been ran for 12hours without stopping. 


Is there other useful information I should get from the server? I have a 
script set up to fix this state, collecting other information would not 
be difficult. Using default MySQL settings (probably going to start 
playing with that today).



Any suggestions would be greatly appreciated, my experience with MySQL 
is very limited.


Thanks,
Curtis

ÿþId         User       Host              db   Command 
Time       State                   Info

512625   bayes     localhost     bayes     
Query            44878     Sending data       
SELECT count(*)\n               FROM 
bayes_token\n              WHERE id = 
'1'\n                AND ati

567964   bayes     localhost     bayes     
Query            1603       Sending data       
SELECT count(*)\n               FROM 
bayes_token\n              WHERE id = 
'1'\n                AND ati

568534   bayes     localhost     bayes     
Query            1303       Sending data       
SELECT count(*)\n               FROM 
bayes_token\n              WHERE id = 
'1'\n                AND ati

569007   bayes     localhost     bayes     
Query            996 Sending data       SELECT 
count(*)\n               FROM 
bayes_token\n              WHERE id = 
'1'\n                AND ati

569385   bayes     localhost     bayes     
Query            695 Sending data       SELECT 
count(*)\n               FROM 
bayes_token\n              WHERE id = 
'1'\n                AND ati

569686   bayes     localhost     bayes     
Query            392 Sending data       SELECT 
count(*)\n               FROM 
bayes_token\n              WHERE id = 
'1'\n                AND ati

569905   bayes     localhost     bayes     
Query            90   Sending data       SELECT 
count(*)\n               FROM 
bayes_token\n              WHERE id = 
'1'\n                AND ati

569942   bayes     localhost     bayes     
Query            0     Updating              UPDATE 
bayes_token SET atime = '1268144621' 
WHERE id = '1' AND token IN 
(')>LDh','S??m?','?z???','O

569943   bayes     localhost     bayes     
Query            0     statistics          SELECT 
RPAD(token, 5, ' '), spam_count, 
ham_count, atime\n                     
FROM bayes_token\n     

569944   bayes     localhost     bayes     
Query            0     Updating              UPDATE 
bayes_token SET atime = '1268144624' 
WHERE id = '1' AND token IN ('? 
.?F','??1G','H?FgZ','?:

569945   bayes     localhost     bayes     
Query            0     Sending data       SELECT 
RPAD(token, 5, ' '), spam_count, 
ham_count, atime\n                     
FROM bayes_token\n     

569947   bayes     localhost     bayes     
Query            0     Sending data       SELECT 
RPAD(token, 5, ' '), spam_count, 
ham_count, atime\n                     
FROM bayes_token\n     

569948   root       localhost     NULL       
Query            0     NULL                     show 
processlist





















					Reply via email to