This is a discussion on 5 Seconds delay in login from other IP? within the MySQL forums, part of the Database Server Software category; --> When logging in from another machine on a mysql 4.19 server, there is a delay of about 5 seconds. ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| When logging in from another machine on a mysql 4.19 server, there is a delay of about 5 seconds. A new mysqld thread is started right away, but other activity occurs 5 sec later. When accessing this server via PHP on the same machine as the server, no such delay occurs. The users are known to the server as name@168.165.1.% a setting skip-name-resolution is added to the config for [mysqld] what could be the cause of this delay? |
| ||||
| Solution found: adding lines for the involved machines in c:\windows\system32\drivers\etc\hosts with some fake hostnames Gert Kok wrote: > When logging in from another machine on a mysql 4.19 server, there is a > delay of about 5 seconds. > > A new mysqld thread is started right away, but other activity occurs 5 > sec later. > > When accessing this server via PHP on the same machine as the server, no > such delay occurs. > > > The users are known to the server as name@168.165.1.% > a setting skip-name-resolution is added to the config for [mysqld] > > > > what could be the cause of this delay? |