Re: Too Many Connections
Posted by:
Rick James
Date: August 10, 2011 09:52PM
Yes, Connections is an ever-increasing number, counting the number of connections since the server was started.
Max_used_connections is the high-water mark for simultaneous connections. If it hits max_connections, you get "out of connections". That is the VARIABLE to tune to allow more. But, I would also decrease GLOBAL.wait_timeout so that idle connections that have failed to disconnect will be bumped out.
Subject
Views
Written By
Posted
3161
August 09, 2011 10:33AM
Re: Too Many Connections
1832
August 10, 2011 09:52PM
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.