[Webware-discuss] Webkit hangs after MySQL error

[Costas M. <co...@ho...>]

I am trying to diagnose a WebKit crash: my website got a large number of 
hits yesterday, and apparently WK crashed completely.  WK is connected to 
MySQL on the backend, and the last thing I saw from WK (I cannt telnet to 
the box to do forensics on WK yet) was a MySQL error: "lost connection to 
the database".

Now, MySQL is still up and running (I am using phpmyadmin so I am sure the 
system's OK), but I am trying to figure out why WK reacted so badly.

One possible reason:  in my classes, I am opening a single mysql connection 
that's instantiated once and passed around to every DB-dependant class.  Is 
it possible that a WK crash closed this connection and then the servlets 
cannot re-open it?  if so, is there a work-around for this?

Even more general, possible OT:  am I better off performance wise, to re-use 
the same DB connection, or instead open up one per-servlet instance or 
something?

Thanks,

Costas



_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com