On Wed, 2014-08-20 at 13:38 -0700, redtailjason wrote: > We are seeing about 4000-7000 delayed messages per day. We do utilize a > dedicated MySQL Server for the Bayes and all 8 scanners share it. Please let > me know if this does not fully clarify our setup for you.
So we're talking about 1% of the messages. Does this happen with all scanner machines, or is this isolated to a single one? If not all scanners are affected, any differences in network connection? When did this start? Any relevant changes roughly about that time? What's your DB server load? Any noticeable load spikes, like 5k times a day? In particular, while a message is taking 2 minutes wall-clock time for Bayes, does either the scanner or database server have an unusual high load? Do you have MySQL logs which might show issues? Can you reproduce the Bayes lags? That is, can you identify a sample message, and re-process manually? When replying, please include the relevant quoted parts you're directly referring to. With some context it is easier to follow the thread. -- char *t="\10pse\0r\0dtu\0.@ghno\x4e\xc8\x79\xf4\xab\x51\x8a\x10\xf4\xf4\xc4"; main(){ char h,m=h=*t++,*x=t+2*h,c,i,l=*x,s=0; for (i=0;i<l;i++){ i%8? c<<=1: (c=*++x); c&128 && (s+=h); if (!(h>>=1)||!t[s+h]){ putchar(t[s]);h=m;s=0; }}}