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

Written By
January 08, 2005 01:57AM
Re: too many connections issue
January 10, 2005 12:44AM
January 11, 2005 10:21AM
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.