Re: max_open_connections
Posted by: Rick James
Date: July 30, 2013 09:03PM

max_open_connections ??
Perhaps you mean max_connections?

show GLOBAL variables like '%_timeout';

SHOW GLOBAL STATUS LIKE 'Max_used_connections';

> When an application kept opening more number of connections

Is one application opening multiple connections without closing them? Bad! Fix the application.

@@global.wait_timeout controls closing naughty connections.

Options: ReplyQuote


Subject
Written By
Posted
Re: max_open_connections
July 30, 2013 09:03PM
August 01, 2013 08:26PM


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.