cant establish connection at application side.

--001636832f2cec2b33048f4807b3
Content-Type: text/plain; charset=ISO-8859-1

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.

--001636832f2cec2b33048f4807b3--

Re: cant establish connection at application side.

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@gmail.com

=A0May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: cant establish connection at application side.

--001485f87d789b92f4048f487d7e
Content-Type: text/plain; charset=ISO-8859-1

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
> - mdykman@gmail.com
>
> May the Source be with you.
>

--001485f87d789b92f4048f487d7e--

Re: cant establish connection at application side.

--002215974c5ab202ca048f48a70d
Content-Type: text/plain; charset=ISO-8859-1

I had a similar problem and found a solution. My WAMP server could not serve
pages because the port that it was configured to utilize was in use by my
Skype app, which loaded first. All that I had to do, was quit out of Skype,
then start WAMP server, then restart Skype (which, I think, uses a different
port if it's first choice is in use).
Good luck.
-Leslie

On Thu, Sep 2, 2010 at 8:29 AM, karthik kumar wrote:

> 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
> > - mdykman@gmail.com
> >
> > May the Source be with you.
> >
>



--
Leslie Doak
Classic Page Works
619-222-3625 | lesliedoak@gmail.com | http://www.ClassicPageWorks.com
Twitter: http://twitter.com/lesliedoak | LinkedIn:
http://www.linkedin.com/in/lesliedoak

--002215974c5ab202ca048f48a70d--

Re: cant establish connection at application side.

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: jangita@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: cant establish connection at application side.

--0016364c7d9966c0ad048f48edd8
Content-Type: text/plain; charset=ISO-8859-1

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: jangita@yahoo.com
> Skype: jangita | GTalk: jangita.nyagudi@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=kumarkarthikn@gmail.com
>
>

--0016364c7d9966c0ad048f48edd8--

Re: cant establish connection at application side.

On 02/09/2010 6:01 p, karthik kumar wrote:
>
> Wow .. Cool that solved our problem...
> Thanks a lott ..

No problem, it took me two weeks to figure out why it takes sooo long to
log in; :-) enjoy!
--
Jangita | +256 76 91 8383 | Y! & MSN: jangita@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org