MySQL 5 - Slow Login from remote
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.20-max (i tried it also with 5.0.20-standard and 5.0.18-standard) I tried to login from an MS Windows XP Machine with ODBC 3.51.20 and with MySQL Administrator and Query Browser. I tried it also with SuSE 10 with MySQL Administrator and Query Browser. Everytime it is the same. Login Process is very poor. When i use the Query Browser, for each Query there is a new Login to the Server. So he needs for each Query about 30 Seconds and for the Query (a small one) 1 Second. Thats ugly. Somebody a Tip for me, how to figure out the Problem? Kai pgp3YtSkfIy9C.pgp Description: PGP signature
Re: MySQL 5 - Slow Login from remote
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] section of your my.cnf file, and restarting the MySQL server software. Would easily help you identify whether DNS is the cause of your issue. Hope this helps, Dan 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.20-max (i tried it also with 5.0.20-standard and 5.0.18-standard) I tried to login from an MS Windows XP Machine with ODBC 3.51.20 and with MySQL Administrator and Query Browser. I tried it also with SuSE 10 with MySQL Administrator and Query Browser. Everytime it is the same. Login Process is very poor. When i use the Query Browser, for each Query there is a new Login to the Server. So he needs for each Query about 30 Seconds and for the Query (a small one) 1 Second. Thats ugly. Somebody a Tip for me, how to figure out the Problem? Kai -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5 - Slow Login from remote
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 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.20-max (i tried it also with 5.0.20-standard and 5.0.18-standard) I tried to login from an MS Windows XP Machine with ODBC 3.51.20 and with MySQL Administrator and Query Browser. I tried it also with SuSE 10 with MySQL Administrator and Query Browser. Everytime it is the same. Login Process is very poor. When i use the Query Browser, for each Query there is a new Login to the Server. So he needs for each Query about 30 Seconds and for the Query (a small one) 1 Second. Thats ugly. Somebody a Tip for me, how to figure out the Problem? Kai -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5 - Slow Login from remote
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 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] section of your my.cnf file, and restarting the MySQL server software. Would easily help you identify whether DNS is the cause of your issue. Hope this helps, Dan 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.20-max (i tried it also with 5.0.20-standard and 5.0.18-standard) I tried to login from an MS Windows XP Machine with ODBC 3.51.20 and with MySQL Administrator and Query Browser. I tried it also with SuSE 10 with MySQL Administrator and Query Browser. Everytime it is the same. Login Process is very poor. When i use the Query Browser, for each Query there is a new Login to the Server. So he needs for each Query about 30 Seconds and for the Query (a small one) 1 Second. Thats ugly. Somebody a Tip for me, how to figure out the Problem? Kai pgpsbUz47k8qt.pgp Description: PGP signature
Re: Slow login
Jiri, Gerald said it could be one of two things. You've just said it's not the first. Think some more about the second (reverse DNS)... If you don't have the authority/ability to configure DNS in your environment, add the systems to each other's hosts files (C:\WINNT\system32\drivers\etc\hosts on W2K) and try again - a reboot may be required; hey, this is M$. Connecting by IP addresses does not mean that the underlying mechanisms won't go through a host resolution process. If that doesn't eleviate things, consider checking the network statistics for errors (netstat -e on W2K) and approach it from that angle; verifying proper speed/duplex configuration between your hosts and networking equipment. As a last resort, you can look through your OS (eventvwr on W2K) and/or MySQL's log files for indications of the problem. Good luck, Roy -- 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 server in local network and I use IP address, so there is no DNS usage... Jiri Matejka - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Jiri Matejka [EMAIL PROTECTED] 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Slow login
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 - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Jiri Matejka [EMAIL PROTECTED] 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 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't be caused by it. I tried several client applications and all behave in the same way, so I guess the problem is inside the database. Can anybody help me? Thanks Jiri Matejka, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Slow login
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 or 4.0.18. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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't be caused by it. I tried several client applications and all behave in the same way, so I guess the problem is inside the database. Can anybody help me? Thanks Jiri Matejka, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Slow login
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't be caused by it. I tried several client applications and all behave in the same way, so I guess the problem is inside the database. Can anybody help me? Thanks Jiri Matejka, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql 4.1.1 slow login
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 about 1 second. I connect to mysql server from my win2k machine with MySQL Front. So I uninstall MySQL 4.1.1 and reinstall 4.0.17, and connection done in 1 second again even my Win2K server machine offline. Can anyone explain this behavior of MySQL 4.1.1? It's difficult to know just what you want explained. You're varying a lot of independent variables (MySQL version, OS, and machine online/offline), and, as far as I can tell, you're not varying them systematically. What is the question that you are asking? If it's why are connections slow when the machine is offline, it's probably a problem of DNS being slow when the machine is offline. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql 4.1.1 slow login
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 from my win2k machine with MySQL Front.So I uninstall MySQL 4.1.1 and reinstall 4.0.17, and connection done in 1 second again even my Win2K server machine offline. Can anyone explain this behavior of MySQL 4.1.1? regards, Hendro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]