On Sat, September 2, 2006 11:11 am, Bill Hacker wrote:
> Brian wrote:
>
>> Hey all,
>>
>> We get these from time to time usually when we are being 'attacked' we
>> have exim at 150 connections max, and when it's 150 we get these in the
>> logs..
>>
>> Warning: ACL "warn" statement skipped: condition test deferred: MYSQL
>> connection failed: Too many connections
>>
>> The load on the box is nothing, and I would like to raise it beyond the
>> 150 but I can't seem to find what I need to raise in mysql to make this
>> work..
>>
>> any clues?
>>
>> mysql Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.1 (i386) using 5.0
>> Threads: 51 Questions: 3210284 Slow queries: 131 Opens: 6874 Flush
>> tables: 1 Open tables: 8 Queries per second avg: 6.760
>>
>> at this time there were probably 51 connections..
>>
>>
>>
>>
> Google:
>
> MySQL connection limits
>
> Second hit:
>
> http://dev.mysql.com/doc/refman/5.0/en/mysql-config-wizard-connections.html
>
> Bill
>
>
the in cnf (mine is in /var/db/mysql/my.cnf) I put this..
max_connections = 250
and it seems to not have that issue anymore ;)
thank you.
