Re: MySQL 5 - Slow Login from remote

2006-04-20 Thread Kai Schmidt
Hi Dan, thank you. That seems to be the Problem solved. Will test it tomorrow in the Office again. But over VPN the login was more faster then without the skip-name-resolve value. Damn, that was so easy, that should i found out by myself ;-) Kai Am Donnerstag, 20. April 2006 19:13 schrieb Dan

Re: MySQL 5 - Slow Login from remote

2006-04-20 Thread Prasanna Raj
Check where u resolve . that could help you I guess this DNS problem ,correct me if iam wrong . --Praj On Thu, 20 Apr 2006 18:43:39 +0200 Kai Schmidt <[EMAIL PROTECTED]> wrote: > Hi @all > > i have a Problem with Login into a MySQL 5 Server. When i try to login from a > remote Machine into

Re: MySQL 5 - Slow Login from remote

2006-04-20 Thread Dan Buettner
Kai, could this be a DNS issue? MySQL will normally try to look up which host you are coming from, if it is not localhost. If you have an incorrect DNS entry on the server, or a malfunctioning DNS server, this could be the problem. You can try adding skip-name-resolve under the [mysqld] se

MySQL 5 - Slow Login from remote

2006-04-20 Thread Kai Schmidt
Hi @all i have a Problem with Login into a MySQL 5 Server. When i try to login from a remote Machine into the Server, it needs up to 30 seconds. When i login from the same machine all is at it should be. After login the Server is responding normal to querys. My Environment: SuSE 10.0 MySQL 5.0

Re: Slow login

2004-05-11 Thread Roy Butler
- Date: Tue, 11 May 2004 08:47:13 +0200 To: <[EMAIL PROTECTED]> From: "Jiri Matejka" <[EMAIL PROTECTED]> Subject: Re: Slow login Message-ID: <[EMAIL PROTECTED]> >> Unfortunatelly it isn't true in my case. I connect to database

Re: Slow login

2004-05-11 Thread Sasha Pachev
Jiri Matejka wrote: Unfortunatelly it isn't true in my case. I connect to database server in local network and I use IP address, so there is no DNS usage... Jiri Matejka If I remember correctly, this is an old bug Windows-specific that has been fixed in the latest release. Try upgrading to 3.23.58

Re: Slow login

2004-05-10 Thread Jiri Matejka
Cc: <[EMAIL PROTECTED]> Sent: Monday, May 10, 2004 3:36 PM Subject: Re: Slow login > Slow connections are ususally a DNS or reverse DNS problem. > > Jiri Matejka wrote: > > >Hi, > > I'm using MySQL 3.23.53 on W2000 and I have a following problem: when I &

Re: Slow login

2004-05-10 Thread gerald_clark
Slow connections are ususally a DNS or reverse DNS problem. Jiri Matejka wrote: Hi, I'm using MySQL 3.23.53 on W2000 and I have a following problem: when I restart the database server then the first attempt to connect from any client program last cca 30 seconds (too long!!), each next attempt to

Slow login

2004-05-08 Thread Jiri Matejka
Hi, I'm using MySQL 3.23.53 on W2000 and I have a following problem: when I restart the database server then the first attempt to connect from any client program last cca 30 seconds (too long!!), each next attempt to connect lasts less than one second. The traffic is usually very small, so it can'

Re: MySql 4.1.1 slow login

2004-04-16 Thread Paul DuBois
At 15:18 +0700 4/15/04, Hendro S. wrote: Hi all, I have win2k server machine, if this machine online, i could login to MySQL 4.1.1 on RH 9 is about 1 second, but if this machine offline connection establish in about 10 seconds, then i try connect to mysql 4.0.17 in SuSe machine its done in abou

MySql 4.1.1 slow login

2004-04-15 Thread Hendro S.
Hi all, I have win2k server machine, if this machine online, i could login to MySQL 4.1.1 on RH 9 is about 1 second, but if this machine offline connection establish in about 10 seconds, then i try connect to mysql 4.0.17 in SuSe machine its done in about 1 second. I connect to mysql server fr