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