While working on an apparent MySQL connection hang I found this: http://www.mysql.com/documentation/connector-j/index.html#id2802198. So now I’ll be able to start thinking about an internet facing database!
I had a breakthrough today with my Tomcat hang. I’m using 5.0.14 beta on the site. It seems that from time to time Tomcat would hang up. On a whim I connected to the Tomcat manager app after roller and stuff hung up. It came up fine, there was no GC going on or anything. It smelled like database so I looled in the log and saw some io errors coming from the MySql driver. Here’s a link: http://www.mysql.com/documentation/connector-j/index.html#id2802490. It looks like autoReconnect is set in roller so there’s still a mystery.