Re: Can the use of Ephemeral ports be disabled?
Posted by: Rick James
Date: April 06, 2014 12:09AM

The normal pattern for TCP/IP connection is to
1. chat on a "well known port" (3306)
2. then switch to some other port, thereby leaving 3306 open for further connections.

Let's focus on this:

> eventually using up my max users limit

Are you referring to the setting in mysql of max_connections?

> maximum clients connected wont ever exceed about 60.

Again, are you referring to max_connections?

> so it connects on 3306, does it business, disappears, then creates a new connection 5 mins later,

That's good. Does it actually disconnect? Or does it somehow hang onto that connection and create another connection?

> eventually using up my max users limit, and filling my logs unnecessarily.

Which "logs"? MySQL does not have a log of connections.

Perhaps another problem is involved... What are the clients? Some web server such as Apache or Tomcat? If so, how many "children" are they configured for? If that number is bigger than MySQL's max_connections, you can run out of connections. Decrease the web server's max.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can the use of Ephemeral ports be disabled?
April 06, 2014 12:09AM


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.