RE: How to fix: Tomcat responce time gets to 10-200 seconds once a day
Thank you very much for all the hints. I'll try checking the points you mentioned later. However, for test purposes I've moved the database to another PC within the same network and the problem seems to have gone away! Other PC (Database server) runs SuSE 9.0 (with MySQL 3.23.55), 2 Pentium 4 processors, 1 GB RAM. Can this help to pin-point the problem. I can leave this setup (web server on one PC and that database on another), but I'm getting the following error once in the while (normally when there are many hits one after the other). What can be the problem? I've tried using the current database driver (com.mysql.jdbc.Driver), but it didn't solve the problem. Any ideas? Thanks a lot, Roman Zhovtulya P.S. Here is an exception: javax.servlet.ServletException: Communication link failure: java.io.IOException at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContex tImpl.java:471) at org.apache.jsp.go$jsp._jspService(go$jsp.java:352) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServle t.java:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja va:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 72) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja va:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.ja va:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja va:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 72) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234 7) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja va:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja va:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja va:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja va:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 72) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja va:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 72) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) at java.lang.Thread.run(Thread.java:536) root cause java.sql.SQLException: Communication link failure: java.io.IOException at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source) at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.Statement.executeQuery(Unknown Source) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Unknown Source) at graduate_school.SQLconnectionBean.sqlQuery(SQLconnectionBean.java:66) at org.apache.jsp.go$jsp._jspService(go$jsp.java:289) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.ser
How to fix: Tomcat responce time gets to 10-200 seconds once a day
Dear Sirs, I wonder if anyone had anything similar before. I'm running some JSP/Java Bean websites under Tomcat (on one PC as a stand-alone server, on another in connection with Apache). The website is a dynamic (3-tier architechture) connects to MySQL database to get the content to display any page (around 3-4 connections per page). Normally the performance is really good, but about once a day it gets really slow (around 1-5 minutes to display the page). It also recovers autocatically to normal response time when you simply wait 5-10 minutes. Any ideas? I'm running Tomcat 4.05 with Apache on RedHat 8.0 (one PC) as well as Tomcat 4.127 on SuSE 9.0 with MySQL 4.015. I'm closing all db-connections in JSP/JavaBeans, so I don't think it's a db-issue. I'd highly appreciate any help on the topic. Thank you very much, Roman Zhovtulya --- Roman Y. Zhovtulya Manager InternetServiceCenter Fachbereich Medien und Informationswesen FH Offenburg InternetServiceCenter bietet In-House Beratung, professionelle und preiswerte Entwicklung von individueller Software Lösungen in Bereich Internet, WWW, Datenbanken, etc Kostenlose vor-Ort Istanalyse und "Sparpotenzialanalyse" für potenzielle Kunden. Sprechen Sie uns an: InternetServiceCenter Offenburg University of Applied Sciences Room B205a Badstr. 24, Offenburg D-77652 Germany VoIP ID (Skype): romanlutsk (mehr unter www.skype.com) Tel.: +49 781 205 137 / Fax: 290 www.fh-offenburg.de/isc --- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
