Re: bad "too many connections" error (os x)

2004-09-06 Thread Egor Egorov
Michael Winston <[EMAIL PROTECTED]> wrote: >> Okay, so the first thing to try is obviously enlarge the >> max_connections. >> Have you tried this? > > Yes. It's set to 400 (a number we will never reach unless there's some > sort of logjam). max_connect_errors is set to 200. > >> Is it a webs

Re: bad "too many connections" error (os x)

2004-09-02 Thread Michael Winston
On Sep 2, 2004, at 6:04 AM, Egor Egorov wrote: Michael Winston <[EMAIL PROTECTED]> wrote: Okay, so the first thing to try is obviously enlarge the max_connections. Have you tried this? Yes. It's set to 400 (a number we will never reach unless there's some sort of logjam). max_connect_errors is

Re: bad "too many connections" error (os x)

2004-09-02 Thread Egor Egorov
Michael Winston <[EMAIL PROTECTED]> wrote: Okay, so the first thing to try is obviously enlarge the max_connections. Have you tried this? Is it a webserver backend database? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net

Re: bad "too many connections" error (os x)

2004-09-01 Thread Aftab Jahan Subedar
This also may caused by the TTL of the http socket and the launched zombie forks by the http/php server ( the FIN_WAIT_2 problem!!). Thats what it happend to me . I dunno who waited for who, and became zombie, was it MySQL waiting for timeout or was socket wating to timeout. You can test this e

Re: bad "too many connections" error (os x)

2004-09-01 Thread Michael Winston
This would make sense since they all the connections are coming from the same website. But if this is true, then why can't we connect using 'mysqladmin -uroot'? Shouldn't that work from any host? Thanks, Michael On Sep 1, 2004, at 9:08 AM, Victor Pendleton wrote: Is it a too many connections o

RE: bad "too many connections" error (os x)

2004-09-01 Thread Victor Pendleton
Not if the host that is blocked is `localhost`. -Original Message- From: Michael Winston To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 9/1/04 11:24 AM Subject: Re: bad "too many connections" error (os x) This would make sense since they all the connections are c

Re: bad "too many connections" error (os x)

2004-09-01 Thread Alex Greg
Michael Winston wrote: On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connec

Re: bad "too many connections" error (os x)

2004-09-01 Thread William R. Mussatto
Michael Winston said: > > On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: > >> >> >> Michael Winston wrote: >>> Hi- >>> We've been running into a pretty serious problem for the past several >>> versions of mysql 4.0 running on OS X (both client and server). >>> Every once in a while we wake up t

Re: bad "too many connections" error (os x)

2004-09-01 Thread Michael Winston
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connections" error coming up

Re: bad "too many connections" error (os x)

2004-09-01 Thread Santino
I think that there is an error in your code. I have had this problem with a small application I wrote: The problem arises when you don't send the quit command to mysql before dropping tcp. You must send a quit command in every case (if you opened a socket). I can not be more precise because i don'

Re: bad "too many connections" error (os x)

2004-09-01 Thread V. M. Brasseur
Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connections" error coming up. There really aren't too many connections (we ha

RE: bad "too many connections" error (os x)

2004-09-01 Thread Victor Pendleton
Is it a too many connections or Host blocked because of many connection erros? If it is the later you have reached max_connect_errors and need to issue flush-hosts. -Original Message- From: Michael Winston To: [EMAIL PROTECTED] Sent: 9/1/04 11:02 AM Subject: bad "too many connections" erro