Re: Question on max_connections
Posted by:
abilash vs
Date: October 14, 2010 01:07AM
Sander/Rick,thanks.
There are no errors saying 'too many connections' in our logs,the third party who maintain our servers informed us the issue was because of max connections and we are sure it is not because of it.
I also like to understanding one more thing,please correct me If I am wrong.
My max_connections is set to 4300 ,'threads_connected=1134' & show processlist returned 744 connections which are in SLEEP status.
1)threads_connected value is supposed to be the number of active connections.So does all the connections which show process list shows are a subset of threads_connected ?
2)I think the connections in SLEEP can be there because as I use jboss managed connection pooling, so the system would reuse exist connnections.
Regards,
Abilash
Subject
Written By
Posted
Re: Question on max_connections
October 14, 2010 01:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.