From: Michael Dykman Date: September 2 2010 3:02pm Subject: Re: cant establish connection at application side. List-Archive: http://lists.mysql.com/mysql/222797 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable You might want to have a good close look at the state of your network before you consider mysql as a cause.. - michael dykman On Thu, Sep 2, 2010 at 10:57 AM, karthik kumar wr= ote: > Hi .. I am facing a problem in mysql. > > =A0 =A0 =A0 =A0 I am getting error =A0'Can not open connection' at the ap= plication > side =A0which happens at random timings. =A0 What i found was at whenever= the > problem occurs it takes 70 secs for connecting to mysql server. The machi= ne > is a high end quad core, 16 GB ram, dedicated for mysql > > =A0I guess its problem is with my configurations. =A0 My guess is like if= i ve > configured some buffer to x =A0and when when mysql is being used it keeps > coming down and slows down connecting time for clients ( its a =A0wild gu= ess ) > .. =A0So can I do something to monitor the resources/ connections/ or > something else to see what does mysql lacks when connection time reaches = 70 > secs or my application gets a 'Can not open connection' problem so that I > give a larger value for that thing =A0.. > =A0 =A0 =A0 =A0 =A0Certainly changing (timout's .. or something else ) in= application > would solve but thats not a solution for my situation .. i have configure= d > max number of connections to 500 .. and the total number of connections > hardly reach 100 .. > =A0 =A0 =A0 =A0 =A0 Any help please .. > > Thanks > Karthik. > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.