Karl Pielorz wrote:
>
>
> --On 25 August 2009 01:52 +0200 Josephus <[email protected]> wrote:
>
>>
>> I have compiled the most recent git snapshot on FreeBSD 7.2.
>
>> Aug 25 00:46:38 mail dspam[31755]: Can't connect to MySQL server on
>> '10.1.0.1' (1)
>
> We had a similar issue here (FreeBSD 7.2, DSpam 3.8.0) - setting 'max
> connections' under mysql to 1,000 seemed to fix it.
>
> The system doesn't need anywhere near that many connections - but I
> think something with mysql gets lagged behind on high connection churn
> rates.
>
> Another system we have (using different software) had a similar issue
> on highly churned connections - we had to go to 4,000 connections on
> that one.
>
> Worked for us, but YMMV :)
>
> -Kp
No luck, I set it as high as 3000, but still the same. I'm new to dspam
and I'm not familiar with its design that well, but would it be possible
to use persistent mysql connections?
Threads: 2 Questions: 75091 Slow queries: 0 Opens: 20 Flush tables:
1 Open tables: 13 Queries per second avg: 197.607
(We are talking about 5.1.35)
"show full processlist" only shows one connection at a time for dspam,
however connection id goes up to 20000 in a few minutes due to
reconnects, maybe mysql is not freeing something after a disconnect or
it might be related to the networking stack?
There seems to be plenty of fds left though.
# netstat -an | grep TIME_WAIT | grep 10.1.0.1 | wc -l
3456
kern.maxfiles: 8072
kern.maxfilesperproc: 7264
kern.openfiles: 506
# netstat -m
258/1482/1740 mbufs in use (current/cache/total)
256/1342/1598/17088 mbuf clusters in use (current/cache/total/max)
256/755 mbuf+clusters out of packet secondary zone in use (current/cache)
BR,
Jos
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Dspam-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspam-user
