S2SH+tomcat+mysql突然出现运行速度变慢
悬赏：25 发布时间：2008-07-07 提问人：jnotnull (初级程序员)
系统采用Struts2+Spring+Hibernate+tomcat+mysql实现。
采用了数据库连接池技术，URLRewrite技术，然后在加入Acegi进行调试的过程中，系统地运行速度变慢，就连tomcat的启动都变慢了，要三分钟来启动，而系统响应请求也非常慢，好像struts2的请求转发器反映迟钝似的。Hibernate的查询也变得缓慢，从控制台中看到查询时一条一条的，显得不如以前快。
我把acegi撤掉之后，速度还是一样，撤掉urlrewrite后，速度没有改观，太郁闷了。
大家看看是什么原因呢。
这是我的tomcat的启动信息
2008-7-7 10:38:29 org.apache.catalina.core.AprLifecycleListener init
信息: Loaded Apache Tomcat Native library 1.1.8.
2008-7-7 10:38:30 org.apache.coyote.http11.Http11AprProtocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
2008-7-7 10:38:30 org.apache.coyote.ajp.AjpAprProtocol init
信息: Initializing Coyote AJP/1.3 on ajp-8009
2008-7-7 10:38:30 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 2093 ms
2008-7-7 10:38:30 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2008-7-7 10:38:30 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.10
2008-7-7 10:38:31 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2008-7-7 10:38:31 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2008-7-7 10:38:33 org.apache.catalina.core.ApplicationContext log
信息: Loading Spring root WebApplicationContext
0 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - Bean factory for application context [Root WebApplicationContext]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [indexAction,registerAction,loginAction,edituserAction,validateUserAction,classaddAction,cityaddAction,inforAction,productAction,integAction,indusAction,markAction,videoAction,securityAction,transportAction,buildingAction,doorAction,fireAction,inforSecurityAction,equipmentAction,protectionAction,policeAction,locksAction,safeAction,searchAction,uploadAction,userDAO,userRoleDAO,classDAO,cityDAO,inforDAO,productDAO,integDAO,indusDAO,markDAO,dataSource,sessionFactory,userManageService,classManageService,cityManageService,inforManageService,productManageService,integManageService,indusManageService,markManageService,pagerService,org.springframework.aop.config.internalAutoProxyCreator,serviceOperation,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor,txAdvice,transactionManager]; root of BeanFactory hierarchy
93 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - 51 beans defined in application context [Root WebApplicationContext]
1281 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - Bean 'org.springframework.aop.config.internalAutoProxyCreator' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
1296 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@133f6dd]
1375 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@15b6116]
1750 [main] INFO com.mchange.v2.log.MLog - MLog clients using log4j logging.
1937 [main] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.0.4 [built 23-January-2006 22:20:29 -0500; debug? true; trace: 10]
4921 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.User -> user
5671 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Company -> company
5750 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.BigClass -> bigclass
5796 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.SmallClass -> smallclass
5828 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Province -> province
5859 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.City -> city
5953 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Informationnews -> informationnews
5984 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Product -> product
6046 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Integratednews -> integratednews
6109 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Industrynews -> industrynews
6140 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Marketnews -> marketnews
6171 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Role -> role
6187 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.UserRole -> userrole
6203 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: edu.cumt.jnotnull.domain.BigClass.smallClass -> smallclass
6203 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: edu.cumt.jnotnull.domain.Province.city -> city
6546 [main] INFO com.mchange.v2.c3p0.PoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource@11a772d[ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 11a772d, idleConnectionTestPeriod -> -1, initialPoolSize -> 1, jdbcUrl -> jdbc:mysql://localhost/security, loginTimeout -> 0, maxIdleTime -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ]
6734 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - awaitAvailable(): [unknown]
6734 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 0, unused: 0, excluded: 0]
7765 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 1, unused: 1, excluded: 0]
7765 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1d3633c)
7796 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1d3633c)
7859 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1d3633c)
7921 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1d3633c)
8156 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
8171 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
36171 [main] INFO com.opensymphony.xwork2.config.providers.XmlConfigurationProvider - Parsing configuration file [struts-default.xml]
45968 [main] INFO com.opensymphony.xwork2.config.providers.XmlConfigurationProvider - Parsing configuration file [struts-plugin.xml]
50453 [main] INFO com.opensymphony.xwork2.config.providers.XmlConfigurationProvider - Parsing configuration file [struts.xml]
50656 [main] WARN org.apache.struts2.config.Settings - Settings: Could not parse struts.locale setting, substituting default VM locale
50859 [main] INFO com.opensymphony.xwork2.config.impl.DefaultConfiguration - Overriding property struts.i18n.reload - old value: false new value: true
50875 [main] INFO com.opensymphony.xwork2.config.impl.DefaultConfiguration - Overriding property struts.configuration.xml.reload - old value: false new value: true
55765 [main] INFO org.apache.struts2.spring.StrutsSpringObjectFactory - Initializing Struts-Spring integration...
55953 [main] INFO com.opensymphony.xwork2.spring.SpringObjectFactory - Setting autowire strategy to name
55984 [main] INFO org.apache.struts2.spring.StrutsSpringObjectFactory - ... initialized Struts-Spring integration successfully
185156 [main] INFO com.opensymphony.xwork2.util.ObjectTypeDeterminerFactory - Setting DefaultObjectTypeDeterminer as default ...
2008-7-7 10:41:42 org.apache.coyote.http11.Http11AprProtocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2008-7-7 10:41:44 org.apache.coyote.ajp.AjpAprProtocol start
信息: Starting Coyote AJP/1.3 on ajp-8009
2008-7-7 10:41:45 org.apache.catalina.startup.Catalina start
信息: Server startup in 194797 ms
红色部分表示运行的非常慢
采用了数据库连接池技术，URLRewrite技术，然后在加入Acegi进行调试的过程中，系统地运行速度变慢，就连tomcat的启动都变慢了，要三分钟来启动，而系统响应请求也非常慢，好像struts2的请求转发器反映迟钝似的。Hibernate的查询也变得缓慢，从控制台中看到查询时一条一条的，显得不如以前快。
我把acegi撤掉之后，速度还是一样，撤掉urlrewrite后，速度没有改观，太郁闷了。
大家看看是什么原因呢。
这是我的tomcat的启动信息
引用
2008-7-7 10:38:29 org.apache.catalina.core.AprLifecycleListener init
信息: Loaded Apache Tomcat Native library 1.1.8.
2008-7-7 10:38:30 org.apache.coyote.http11.Http11AprProtocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
2008-7-7 10:38:30 org.apache.coyote.ajp.AjpAprProtocol init
信息: Initializing Coyote AJP/1.3 on ajp-8009
2008-7-7 10:38:30 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 2093 ms
2008-7-7 10:38:30 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2008-7-7 10:38:30 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.10
2008-7-7 10:38:31 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2008-7-7 10:38:31 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2008-7-7 10:38:33 org.apache.catalina.core.ApplicationContext log
信息: Loading Spring root WebApplicationContext
0 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - Bean factory for application context [Root WebApplicationContext]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [indexAction,registerAction,loginAction,edituserAction,validateUserAction,classaddAction,cityaddAction,inforAction,productAction,integAction,indusAction,markAction,videoAction,securityAction,transportAction,buildingAction,doorAction,fireAction,inforSecurityAction,equipmentAction,protectionAction,policeAction,locksAction,safeAction,searchAction,uploadAction,userDAO,userRoleDAO,classDAO,cityDAO,inforDAO,productDAO,integDAO,indusDAO,markDAO,dataSource,sessionFactory,userManageService,classManageService,cityManageService,inforManageService,productManageService,integManageService,indusManageService,markManageService,pagerService,org.springframework.aop.config.internalAutoProxyCreator,serviceOperation,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor,txAdvice,transactionManager]; root of BeanFactory hierarchy
93 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - 51 beans defined in application context [Root WebApplicationContext]
1281 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - Bean 'org.springframework.aop.config.internalAutoProxyCreator' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
1296 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@133f6dd]
1375 [main] INFO org.springframework.web.context.support.XmlWebApplicationContext - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@15b6116]
1750 [main] INFO com.mchange.v2.log.MLog - MLog clients using log4j logging.
1937 [main] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.0.4 [built 23-January-2006 22:20:29 -0500; debug? true; trace: 10]
4921 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.User -> user
5671 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Company -> company
5750 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.BigClass -> bigclass
5796 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.SmallClass -> smallclass
5828 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Province -> province
5859 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.City -> city
5953 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Informationnews -> informationnews
5984 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Product -> product
6046 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Integratednews -> integratednews
6109 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Industrynews -> industrynews
6140 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Marketnews -> marketnews
6171 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.Role -> role
6187 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: edu.cumt.jnotnull.domain.UserRole -> userrole
6203 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: edu.cumt.jnotnull.domain.BigClass.smallClass -> smallclass
6203 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: edu.cumt.jnotnull.domain.Province.city -> city
6546 [main] INFO com.mchange.v2.c3p0.PoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource@11a772d[ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 11a772d, idleConnectionTestPeriod -> -1, initialPoolSize -> 1, jdbcUrl -> jdbc:mysql://localhost/security, loginTimeout -> 0, maxIdleTime -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ]
6734 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - awaitAvailable(): [unknown]
6734 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 0, unused: 0, excluded: 0]
7765 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 1, unused: 1, excluded: 0]
7765 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1d3633c)
7796 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1d3633c)
7859 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1d3633c)
7921 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@146ac5a [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1d3633c)
8156 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
8171 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
36171 [main] INFO com.opensymphony.xwork2.config.providers.XmlConfigurationProvider - Parsing configuration file [struts-default.xml]
45968 [main] INFO com.opensymphony.xwork2.config.providers.XmlConfigurationProvider - Parsing configuration file [struts-plugin.xml]
50453 [main] INFO com.opensymphony.xwork2.config.providers.XmlConfigurationProvider - Parsing configuration file [struts.xml]
50656 [main] WARN org.apache.struts2.config.Settings - Settings: Could not parse struts.locale setting, substituting default VM locale
50859 [main] INFO com.opensymphony.xwork2.config.impl.DefaultConfiguration - Overriding property struts.i18n.reload - old value: false new value: true
50875 [main] INFO com.opensymphony.xwork2.config.impl.DefaultConfiguration - Overriding property struts.configuration.xml.reload - old value: false new value: true
55765 [main] INFO org.apache.struts2.spring.StrutsSpringObjectFactory - Initializing Struts-Spring integration...
55953 [main] INFO com.opensymphony.xwork2.spring.SpringObjectFactory - Setting autowire strategy to name
55984 [main] INFO org.apache.struts2.spring.StrutsSpringObjectFactory - ... initialized Struts-Spring integration successfully
185156 [main] INFO com.opensymphony.xwork2.util.ObjectTypeDeterminerFactory - Setting DefaultObjectTypeDeterminer as default ...
2008-7-7 10:41:42 org.apache.coyote.http11.Http11AprProtocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2008-7-7 10:41:44 org.apache.coyote.ajp.AjpAprProtocol start
信息: Starting Coyote AJP/1.3 on ajp-8009
2008-7-7 10:41:45 org.apache.catalina.startup.Catalina start
信息: Server startup in 194797 ms
红色部分表示运行的非常慢
采纳的答案
其他回答
好好看看Struts和Spring的配置文件吧!
itanger (初级程序员) 2008-07-07
