tomcat - MySQL number of connections not increasing -


i have set mysql max_connections variable 1024. i'm using connection pool connect database.

  <resource type="javax.sql.datasource"                         name="jdbc/testdb"                         factory="org.apache.tomcat.jdbc.pool.datasourcefactory"                         driverclassname="com.mysql.jdbc.driver"                         url="jdbc:mysql://192.168.2.110:3306/testdb?zerodatetimebehavior=converttonull&amp;autoreconnect=true"                         username="test"                         password="test"                          initialsize="10"                         maxactive="1000"                         maxwait="60000"                                                   maxidle="50"                         removeabandonedtimeout="300"                         removeabandoned="true"                         minidle="10" /> 

but when i'm running application, application threads blocked database connections. while application running execute following query:

show status `variable_name` = 'threads_connected'; 

it gives me answer of 131. shouldn't increase until reaching max_connections parameter?

the status value max_used_connections highwater mark threads_connected. find 1000. "131" current number of connections.

there 1 connection reserved super users in. seen in max_used_connections = 1025 when max_connections 1024.


Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -