MySQL Forums
Forum List  »  Performance

Re: too many connections issue
Posted by: changaya
Date: January 10, 2005 12:44AM

i think u adjust 'wait_timeout' variable.

mysql default 'wait_timeout' is 28800 = about 8 hours..

so if someone connect to mysql and just execute 1 query.
and he don't close connection..

mysql keep connection about 8 hours.

then 'too many connection error' occur..

--

first . u check ur source code that don't execute 'close connection' statement

second. u can increase 'max_connection' variable. but more connections.. more h/w requirement.

3rd. u decrease 'wait_timeout'(interactive_time) and other variable relate timeout
(connection_timeout.. etc)

--

sorry to my poor english.

Options: ReplyQuote


Subject
Views
Written By
Posted
2774
January 08, 2005 01:57AM
Re: too many connections issue
2147
January 10, 2005 12:44AM
2230
January 11, 2005 10:21AM
1943
January 11, 2005 12:53PM


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.