For general info (and archive): I finally made our BASE-based webapp thread-safe (so multiple users can use the site reliably!) but then noticed that the many SessionControls/DbControls (one per tomcat session, mostly generated by indexing robots) were
a) hitting or getting close to mysqld's max_connections b) easily hitting BASE's default hibernate connection pool c3p0.max_size of 20 (but since hibernate logging was switched off it took a while to figure this out) I increased these and tweaked some timeouts and everything is working fine. If you have a lot of concurrent users (or perhaps webservices clients) on your BASE instance you might find this is the explanation behind the site hanging for your users. cheers, Bob. -- Bob MacCallum | VectorBase Developer | Kafatos/Christophides Groups | Division of Cell and Molecular Biology | Imperial College London | Phone +442075941945 | Email [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
