Re: cant establish connection at application side.
Wow .. Cool that solved our problem... Thanks a lott .. On Thu, Sep 2, 2010 at 9:20 PM, Jangita wrote: > On 02/09/2010 4:57 p, karthik kumar wrote: > >> Hi .. I am facing a problem in mysql. >> >> I am getting error 'Can not open connection' at the application >> side which happens at random timings. What i found was at whenever the >> problem occurs it takes 70 secs for connecting to mysql server. The >> machine >> is a high end quad core, 16 GB ram, dedicated for mysql >> >> I guess its problem is with my configurations. My guess is like if i ve >> configured some buffer to x and when when mysql is being used it keeps >> coming down and slows down connecting time for clients ( its a wild guess >> ) >> .. So 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 .. >> Certainly changing (timout's .. or something else ) in >> application >> would solve but thats not a solution for my situation .. i have configured >> max number of connections to 500 .. and the total number of connections >> hardly reach 100 .. >>Any help please .. >> >> Thanks >> Karthik. >> >> Try adding skip-name-resolve on your mysql.conf file; long connection > times sometimes are caused by the server trying to resolve, and with many > people connecting can sometimes slow the server to a halt! > > Make sure that your users table has IP addresses instead of host names on > the user table eg. 127.0.0.1 instead of localhost (since mysql wount resolve > anymore) > > -- > Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com > Skype: jangita | GTalk: jangita.nyag...@gmail.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=kumarkarth...@gmail.com > >
Re: cant establish connection at application side.
I am running a tool which just makes connection and closes it (using JDBC) .. The JDBC connection never says 'Can not establish connection' .. I just says ' at this time ' took 70 secs to establish a connection .. So my guess was network was not a problem,( since connection was established but takes extra time ) .. The application says 'Can not establish connection' => cant establish connection in a specified timeout.. Am i guessing anything wrong or can I get any ideas please ? Thanks Karthik. On Thu, Sep 2, 2010 at 8:32 PM, Michael Dykman wrote: > 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 > wrote: > > Hi .. I am facing a problem in mysql. > > > > I am getting error 'Can not open connection' at the application > > side which happens at random timings. What i found was at whenever the > > problem occurs it takes 70 secs for connecting to mysql server. The > machine > > is a high end quad core, 16 GB ram, dedicated for mysql > > > > I guess its problem is with my configurations. My guess is like if i > ve > > configured some buffer to x and when when mysql is being used it keeps > > coming down and slows down connecting time for clients ( its a wild > guess ) > > .. So 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 .. > > Certainly changing (timout's .. or something else ) in > application > > would solve but thats not a solution for my situation .. i have > configured > > max number of connections to 500 .. and the total number of connections > > hardly reach 100 .. > > Any help please .. > > > > Thanks > > Karthik. > > > > > > -- > - michael dykman > - mdyk...@gmail.com > > May the Source be with you. >
cant establish connection at application side.
Hi .. I am facing a problem in mysql. I am getting error 'Can not open connection' at the application side which happens at random timings. What i found was at whenever the problem occurs it takes 70 secs for connecting to mysql server. The machine is a high end quad core, 16 GB ram, dedicated for mysql I guess its problem is with my configurations. My guess is like if i ve configured some buffer to x and when when mysql is being used it keeps coming down and slows down connecting time for clients ( its a wild guess ) .. So 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 .. Certainly changing (timout's .. or something else ) in application would solve but thats not a solution for my situation .. i have configured max number of connections to 500 .. and the total number of connections hardly reach 100 .. Any help please .. Thanks Karthik.