Return-Path: 
 <tomcat-user-return-66356-qmlist-jakarta-archive-tomcat-user=nagoya.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org
Received: (qmail 42494 invoked from network); 2 Jun 2003 16:25:48 -0000
Received: from exchange.sun.com (192.18.33.10)
  by daedalus.apache.org with SMTP; 2 Jun 2003 16:25:48 -0000
Received: (qmail 26590 invoked by uid 97); 2 Jun 2003 16:28:03 -0000
Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org
Received: (qmail 26583 invoked from network); 2 Jun 2003 16:28:02 -0000
Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12)
  by nagoya.betaversion.org with SMTP; 2 Jun 2003 16:28:02 -0000
Received: (qmail 40987 invoked by uid 500); 2 Jun 2003 16:25:26 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 40972 invoked from network); 2 Jun 2003 16:25:26 -0000
Received: from navgwout.phillynews.com (HELO navgw.phillynews.com)
 (161.188.204.247)
  by daedalus.apache.org with SMTP; 2 Jun 2003 16:25:26 -0000
Received: from phlxch02.phillynews.com ([161.188.201.208])
 by navgw.phillynews.com (NAVGW 2.5.2.21) with SMTP id M2003060212252822018
 for <tomcat-user@jakarta.apache.org>; Mon, 02 Jun 2003 12:25:28 -0400
Received: by phlxch02.phillynews.com with Internet Mail Service (5.5.2655.55)
	id <K8M1AJGN>; Mon, 2 Jun 2003 12:25:28 -0400
Message-ID: <C39A2C9C164B52409C0FB55726CA77070446A84B@PHLXCH03.phillynews.com>
From: "Januski, Ken" <kjanuski@phillynews.com>
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
Subject: RE: Tomcat problems every morning.
Date: Mon, 2 Jun 2003 12:25:25 -0400 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2655.55)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C32923.92C4C8B0"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C32923.92C4C8B0
Content-Type: text/plain;
	charset="iso-8859-1"

For what it's worth I use Tomcat 4.0 and mySQL in production environment and
don't have any of the aforementioned problems. I DO restart mySQL from
script on daily basis but I never had any problems that caused me to do so.
I just wanted a daily backup of the database and daily transactions and for
me the simplest way to do it was to just stop the service, do whatever I
needed and then restart. But I had no problems before I switched to the
daily restart.

I'd have to check what version of mySQL and driver that I'm using. You're
probably using newer ones and there may be problems with them that I don't
have with mine.



-----Original Message-----
From: Chong Yu Meng [mailto:chongym@cymulacrum.net]
Sent: Monday, June 02, 2003 12:08 PM
To: Tomcat Users List
Subject: Re: Tomcat problems every morning.


Geralyn M Hollerman wrote:

>For the stuff I'm working with, *I'm* the DBA. 
>
Oops ! Sorry to hear that ! I've never had much luck with MySQL myself, 
because it has some pretty funky methods of configuring permissions. I 
use Firebird when I can. Anyway, I'm pretty sure it isn't Tomcat that is 
causing the problems, because it seems that your problem is pretty 
regular (every 8 hours ?). I could be wrong, but I'd look at the 
database. Connection pooling is not enabled by default in Tomcat.

Regards,
pascal chong




---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

------_=_NextPart_001_01C32923.92C4C8B0--