基于jboss调整项目连接数限制的参数调整

1、调整jboss应用的最大连接数

cap-ds.xml

********************************************************************

 

   <!-- The minimum connections in a pool/sub-pool. Pools are lazilyconstructed on first use -->

   <min-pool-size>10</min-pool-size>

 

    <!-- The maximum connectionsin a pool/sub-pool -->

   <max-pool-size>500</max-pool-size>

 

   <!-- The time before an unused connection is destroyed -->

<idle-timeout-minutes>10</idle-timeout-minutes>

********************************************************************

 

 

2、调整项目应用的数据库连接cap4j应用的最大连接数

dataAccessContext.xml

********************************************************************

          <bean id="mcamt"class="com.mchange.v2.c3p0.ComboPooledDataSource"

                   destroy-method="close">

                   <propertyname="driverClass"

                            value="oracle.jdbc.driver.OracleDriver"/>

                   <propertyname="jdbcUrl"

                            value="jdbc:oracle:thin:@168.5.15.33:1521:mcam"/>

                   <propertyname="user" value="mcam" />

                   <propertyname="password" value="cap4j" />

                   <propertyname="autoCommitOnClose" value="true" />

                   <propertyname="checkoutTimeout" value="5000" />

                   <propertyname="initialPoolSize" value="20" />

                   <property name="minPoolSize"value="20" />

                   <propertyname="maxPoolSize" value="400" />

                   <propertyname="maxIdleTime" value="25200" />

                   <propertyname="acquireIncrement" value="5" />

                   <propertyname="maxIdleTimeExcessConnections" value="1800" />

          </bean>

********************************************************************

 

 

3、调整数据库的最大连接数

修改最大连接数alter system setprocesses = 800 scope = spfile;

 

4、mina最大连接数

init.xml

<basic>

              <isStartup>true</isStartup>

              <port>9090</port>

              <timeout>30</timeout>

              <minaIoThreadsNum>20</minaIoThreadsNum>

              <minaExecutorMaxPoolSize>400</minaExecutorMaxPoolSize>

              <backlog>200</backlog>

              <tcpnodelay>true</tcpnodelay>

           </basic>

 

4、调整操作系统用户最大连接数

修改linux最大进程数限制

修改linux最大进程数限制某些系统会限制一个用户的最大进程数

用ulimit -u　可查看最大进程数，通常用4090

但可以通过ulimit -u unlimited　｜　n设置成不限制最大进程数或为一个数值n。

 

 

 

测试最大压力是数据库服务器崩溃：错误如下

ORA-00604: error occurred at recursive SQLlevel 1

ORA-04031: unable to allocate 3840 bytes ofshared memory ("shared pool","SELECT ORA_TQ_BASE$.NEXTVAL...","sga heap(1,0)","kglsim object batch")