Despite all this, I would add:
- I was using the 4.0.20b, now I'm using the 4.1.3beta version, adn the
error still occurs, plus, I used the earlier version because the 4.1.3 Beta
is almost FOUR times slower than 4.0.20b.
As a matter of fact, 4.0.20b, is really fast, has a truly high-end
performance.
> -----Mensaje original-----
> De: Pablo Cuadrado [mailto:pcuadrado@stripped]
> Enviado el: jueves 15 de julio de 2004 08:19
> Para: pbhasin@stripped; Win32 MySQL List
> Asunto: RE: STRANGE behavior (MySQL hangs & then it works again)...
> Importancia: Alta
>
>
> Hi again!
>
> May I suppose that, in case that happens, this error would occur?:
>
> Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) Message: Too many
> connections
>
> Thanks!
>
> -----Mensaje original-----
> De: Puneet Bhasin [mailto:pbhasin@stripped]
> Enviado el: jueves 15 de julio de 2004 03:33
> Para: beau.frusetta@stripped; win32@stripped
> Asunto: RE: STRANGE behavior (MySQL hangs & then it works again)...
>
>
>
> Hi,
>
> I had replied to such a problem earlier. I might have been wrong then and
> might be wrong again now :) .. but here it is ...
>
> In my app such thing used to happen and I found out that I was not closing
> the conection after getting the data from MySQL. The number of connections
> kept on increasing till they reached max and then I could nto connect.
>
> It might be that after 10 min after connections cease the
> succeeed, DB might
> be timing out the unused connections and then the connections would work
> again. It certainly happend in my case when I used ASP.NET with MySQL. You
> can verify it by checking the number of connections using MySQlAdmin
>
> cheers
> Puneet
>
>
> Original Message:
> >From: "Beau Frusetta" <beau.frusetta@stripped>
> >To: <win32@stripped>
> >Subject: RE: STRANGE behavior (MySQL hangs & then it works again)...
> >Date: Wed, 14 Jul 2004 22:57:49 -0700
>
> >I have had this same problem before and it finally "worked"
> itself out. I
> >was consistently losing a connection, but then it regains the connection
> >upon retry. I can't explain it...maybe a MySQL guru can step in
> >here...anyone...anyone...bueller??? :)
> >
> >Thank you,
> >Beau Frusetta (beau.frusetta@stripped)
> >
> >-----Original Message-----
> >From: Pablo Cuadrado [mailto:pcuadrado@stripped]
> >Sent: Wednesday, July 14, 2004 1:54 PM
> >To: win32@stripped
> >Subject: STRANGE behavior (MySQL hangs & then it works again)...
> >Importance: High
> >
> >
> > Hello, I'm working on an Intranet application, adn I'm using
> MySQL 4.0.20,
> >well:
> >
> > The PHP scripts, IIS, web pages, are stored on one server (called
> >"einstein"), while the MySQL Server is installed on a different server
> >(called "VPNGONAR"), that server is faster than "einstein".
> >
> > Alright, then: I ran the scripts, use the web-based system, it works
> >PERFECTLY... for (almost) exactly TEN MINUTES. And then it just STOPS
> >WORKING for (almost) exactly TEN MINUTES.
> >
> > Tired of this, I wrote a PHP script that runs every 30 seconds
> and then it
> >dumps a textfile as log, look at a short version of it:
> >
> >(I'm from Argentina, "Conexión exitosa" means "Succesfull
> connection", and
> >the date we use is day/month/year).
> >
> >14/07/04 16:19:03 - Conexión exitosa.
> >14/07/04 16:19:33 - Conexión exitosa.
> >14/07/04 16:20:24 - 2003: Can't connect to MySQL server on 'vpngonar'
> >(10060)
> >
> >(Returning this every 30 seconds...)
> >
> >14/07/04 16:29:46 - 2003: Can't connect to MySQL server on 'vpngonar'
> >(10060)
> >
> >14/07/04 16:30:21 - Conexión exitosa.
> >14/07/04 16:30:51 - Conexión exitosa.
> >14/07/04 16:31:21 - Conexión exitosa.
> >
> >(Returning this every 30 seconds...)
> >
> >14/07/04 16:40:16 - Conexión exitosa.
> >14/07/04 16:41:07 - 2003: Can't connect to MySQL server on 'vpngonar'
> >(10060)
> >
> >(Returning this every 30 seconds...)
> >
> >14/07/04 16:49:38 - 2003: Can't connect to MySQL server on 'vpngonar'
> >(10060)
> >
> >14/07/04 16:50:29 - 2003: Can't connect to MySQL server on 'vpngonar'
> >(10060)
> >
> >14/07/04 16:51:00 - Conexión exitosa.
> >
> >And so on...
> >
> >So? Anyone knows why?
> >
> > Thanks.
> >
> >
> >Pablo.
> >
> >
> >--
> >MySQL Windows Mailing List
> >For list archives: http://lists.mysql.com/win32
> >To unsubscribe:
> http://lists.mysql.com/win32?unsub=1
> >
> >
> >
> >
> >--
> >MySQL Windows Mailing List
> >For list archives: http://lists.mysql.com/win32
> >To unsubscribe:
> http://lists.mysql.com/win32?unsub=1
> >
> >
> >
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=1
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=1
>
