Hello everyone,
I am testing a servlet on Jboss AS 7.1.1.Final. In production environment it is expected to get around 10,000 requests in a minute. When I have simulated it without connecting to database it was taking requests close to 12,000 per minute. However, when I add database connection to it, it takes around 100 to 2000 requests per minute. When I start the server, till the time pool is filled it takes only around 50-100 request in a minute and after 3-4 minutes it takes 2000 requests.
I am using Oracle RAC 11g 11.2.0.3 and server is having 8GB RAM.
This is my datasource setting.
<datasources>
<datasource jta="true" jndi-name="java:jboss/datasources/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:oci:@ Connection - String</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>ojdbc6.jar</driver>
<pool>
<min-pool-size>100</min-pool-size>
<max-pool-size>500</max-pool-size>
<prefill>true</prefill>
</pool>
<security>
<user-name>moviebeam_usr</user-name>
<password>m0viebe4m</password>
</security>
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
</validation>
<timeout>
<blocking-timeout-millis>1000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
<statement>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</datasource>
<drivers>
<driver name="ojdbc6.jar" module="com.oracle.ojdbc">
<xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>
</driver>
</drivers>
</datasources>
Also i have added this setting for threads.
<bounded-queue-thread-pool name="http-executor">
<core-threads count="14500"/>
<queue-length count="30"/>
<max-threads count="15000"/>
<keepalive-time time="300" unit="seconds"/>
</bounded-queue-thread-pool>
<connector name="http" protocol="HTTP/1.1" scheme="http" socket-binding="http" max-post-size="2048" max-save-post-size="0" executor="http-executor" max-connections="12000"/>
This is datasource outcome in cli.
{
"outcome" => "success",
"result" => {
"ActiveCount" => "4",
"AvailableCount" => "496",
"AverageBlockingTime" => "0",
"AverageCreationTime" => "805",
"CreatedCount" => "4",
"DestroyedCount" => "0",
"MaxCreationTime" => "1102",
"MaxUsedCount" => "4",
"MaxWaitTime" => "0",
"TimedOut" => "0",
"TotalBlockingTime" => "0",
"TotalCreationTime" => "3223"
}
}
{
"outcome" => "success",
"result" => {
"ActiveCount" => "101",
"AvailableCount" => "400",
"AverageBlockingTime" => "0",
"AverageCreationTime" => "44052",
"CreatedCount" => "101",
"DestroyedCount" => "0",
"MaxCreationTime" => "71020",
"MaxUsedCount" => "100",
"MaxWaitTime" => "1",
"TimedOut" => "0",
"TotalBlockingTime" => "6",
"TotalCreationTime" => "4449312"
}
}
Am I missing anything or configuring it wrong.
Please suggest.
Thanks