I thought that the # of connections might be a problem at some point too.
The last time this happened, there were a lot of connections. Right now,
there are 19 connections.
How do I tell what the TTL is?
I'm not too familiar with perfmon. How do I set it up to watch MySQL
connections?
Thanks,
Jesse
----- Original Message -----
From: "Gary Smith" <g...@primeexalia.com>
To: "Jesse" <j...@msdlg.com>; <mysql@lists.mysql.com>
Sent: Tuesday, March 24, 2009 2:55 PM
Subject: Re: MySQL server has gone away...
Netstat -an. How many 3306 entries do you have in there. What's the TTL on
them. Once the pool issues the bad connection multiple issuances of the
same connection will probably result in the same error.if yoi birst to 20
connections then drop to 10 for the next 24 hours then burst to 11 that
11th might have been dropped. Next asp request gets 11. Next one gets 11.
And so on until the active requests drop to the point where the
connections are still active. Does this make sense?
It doesn't round robin them (at least to the best of my knowledge) so some
may go stayle.
When testing the odbc connection some time ago I had connections stay in
the pool for a day whereas my timeout was 120 minutes.
Anyway. Watch the connection count with the windows perfmon and see if
there is a corrolation.
Sent via BlackBerry by AT&T
-----Original Message-----
From: Jesse <j...@msdlg.com>
Date: Tue, 24 Mar 2009 14:47:30
To: Jesse<j...@msdlg.com>; <mysql@lists.mysql.com>
Subject: Re: MySQL server has gone away...
An update on this issue. It just happened again, and the first error was:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]Lost connection
to
MySQL server during que
Then, after that, I got a BUNCH of "[MySQL][ODBC 3.51
Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away" errors.
I'm pretty sure that the 2nd errors were caused by the first error.
Again,
there is nothing strange in the IIS logs, or Windows Event log The
database
server is on the same machine as the web server, so the network should not
be involved here.
Why would it suddenly loose connection?
Jesse
----- Original Message -----
From: "Jesse" <j...@msdlg.com>
To: <mysql@lists.mysql.com>
Sent: Tuesday, March 24, 2009 11:41 AM
Subject: MySQL server has gone away...
We are running MySQL Server version 5.0.67-community-nt-log on a WS03
server. It seems like every once in a while (sometimes once or twice a
week, sometimes more), something will happen, then I'll start getting a
lot of errors:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has
gone away
This is driving me absolutely nuts. I don't see any errors in the Event
Viewer, or the MySQL error log. Does anyone know of any reasons that
this might happen?
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub...@msdlg.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=g...@primeexalia.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
