tomcat7结合c3p0和mysql优化性能配置

tomcat7结合c3p0优化性能配置

下面给出的是本人在项目时的配置demo.我在配置服务器是用到的是tomcat7安装版，因此在配置优化JAVA_OPTS方式和下文有些区别，但是配置的内容是相同的，如果有什么疑议可以交流一下。

1、首先配置server.xml文件

<Resource          name="jdbc/MysqlDB"          auth="Container"          description="DB Connection"          factory="org.apache.naming.factory.BeanFactory"          type="com.mchange.v2.c3p0.ComboPooledDataSource"          driverClass="com.mysql.jdbc.Driver"          jdbcUrl="jdbc:mysql://localhost:3306/educationaloa?characterEncoding=utf-8"          user="root"          password="12345"          maxPoolSize="500"          minPoolSize="50"          acquireIncrement="1"          acquireRetryAttempts="30"          idleConnectionTestPeriod="60"          checkoutTimeout="100"          initialPoolSize="50"          maxStatements="100"          maxIdleTime="60"          preferredTestQuery="SELECT 1"          /><Connector port="8080" protocol="org.apache.coyote.http11.Http11NioProtocol"              connectionTimeout="30000"              acceptCount="1500"              minSpareThreads="25"              enableLookups="false"              maxThreads="1024"              maxHttpHeaderSize ="8443"              disableUploadTimeout="true"              redirectPort="8443"              compression="on"              noCompressionUserAgents="gozilla,traviata"                    compressableMimeType="text/html,text/xml,text/javascript,text/css,text/plain"              URIEncoding="utf-8" /><!--项目发布后关闭AJP服务<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" /> --><Host name="localhost"  appBase="webapps"            unpackWARs="false" autoDeploy="false">

2、conf/catalina.sh文件(linux),或者conf/catalina.bat文件(windows)

#JAVA_OPTS="$JAVA_OPTS $JSSE_OPTS"JAVA_OPTS="-server -Xms1G -Xmx2G -Xss256K -Djava.awt.headless=true -Dfile.encoding=utf-8 -XX:MaxPermSize=256m -XX:PermSize=128M -XX:MaxPermSize=256M"