views:

23

answers:

0

Facts:

  • 1 Tomcat installation , 1 MySql and 2 applications ( app1 and app2 )
  • Hosted on shared hosting, so most of admin stuff with mysql is not possible
  • When tomcat is started the applications ( both app1 and app2 ) are working fine

  • After about 30 minutes... I try to log in my app1

  • Sometimes it logs in and sometimes it just sits there and kind of "hangs"
  • Even if I log in.... after a click or a few clicks it stops responding ( like above )

  • If I check in phpMyAdmin, there are some processes in "sleep" mode

  • killing these will not solve anything
  • If I check in Tomcat Manager...there are these process sitting there as well

My analysis :

  • There are no permanent connections or connection leaks ( already checked )
  • Tomcat is up ( since manager is responding well )
  • MySql is also up ( since I am able to see the processes and kill them too )...and run queries
  • I guess there is some connection problem between Tomcat and Mysql
  • Something like Tomcat is sending and Mysql is getting but not replying back

My Doubts :

  • What could be a thing which is causing this ( timeout ? )
  • It HAS to be something which is ok at the start but goes wrong after 30 minutes or so

Please help. ( Tomcat logs are not very helpful. Though I have struts log from log4j )

thanks, Mayank