I have a MySQL 5.0.75 server running on my Linux notebook to which I want to connect from another machine in the local network.
This connection takes 5-6 seconds:
mysql -h 172.22.65.101 -u myuser -p123
A ping to the MySQL host:
PING 172.22.65.101 (172.22.65.101) 56(84) bytes of data. 64 bytes from 172.22.65.101: icmp_seq=1 ttl=64 time=0.799 ms 64 bytes from 172.22.65.101: icmp_seq=2 ttl=64 time=0.000 ms 64 bytes from 172.22.65.101: icmp_seq=3 ttl=64 time=6.43 ms 64 bytes from 172.22.65.101: icmp_seq=4 ttl=64 time=0.000 ms 64 bytes from 172.22.65.101: icmp_seq=5 ttl=64 time=3.81 ms 64 bytes from 172.22.65.101: icmp_seq=6 ttl=64 time=0.706 ms ^C --- 172.22.65.101 ping statistics --- 6 packets transmitted, 6 received, 0% packet loss, time 5027ms rtt min/avg/max/mdev = 0.000/1.959/6.437/2.383 ms
Any Ideas? When I monitor the connection with SHOW PROCESSLIST; on the MySQL host, I can see that the command is "connect" and the user is "unauthenticated user". This lasts until the connection is established. (The user is then displayed as "myuser" and the command is "sleep")
I am a developer and need your suggestions about how to find the bottleneck!
My my.cnf on the host:
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M expire_logs_days = 10 max_binlog_size = 100M skip-federated [mysqldump] quick quote-names max_allowed_packet = 16M [isamchk] key_buffer = 16M
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
mysql Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (i486) using readline 5.2