Slow WAN ODBC Connect - Beating a Dead Dog

[Brian Pilati]

My ODBC pauses 10 seconds between queries. I have read some of the other threads on this subject but nothing has helped. Maybe if someone sees my details I can find a solution:

Redhat Linux 2.4.20-8
MySQL 4.1.10 or 4.1.10a (I have one of each server on two machines)
MyODBC 3.51.3, 3.51.10, 3.51.11-3

Everything was fine while I was using 3.51.10 and 4.0 but when I upgraded to 4.1 it slowed way down. The LAN is fine no pausing.

This is a report of the tethereal sniff (Look at the 10 seconds intervals, they should be concurrent then a few are concurrent and then intervaled, again):

16.292598 172.16.3.3 -> 192.168.16.4 MySQL Server Greeting Protocol : 10 ,version: 4.1.10a-standard-log Caps: 0xffffa22c

16.293395 192.168.16.4 -> 172.16.3.3 MySQL Login Request Caps:

16.399583 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

16.508006 172.16.3.3 -> 192.168.16.4 MySQL Response OK

26.722685 172.16.3.3 -> 192.168.16.4 MySQL Server Greeting Protocol : 10 ,version: 4.1.10a-standard-log Caps: 0xffffa22c

26.723205 192.168.16.4 -> 172.16.3.3 MySQL Login Request Caps:

26.870087 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

26.982438 172.16.3.3 -> 192.168.16.4 MySQL Response OK

37.193078 172.16.3.3 -> 192.168.16.4 MySQL Server Greeting Protocol : 10 ,version: 4.1.10a-standard-log Caps: 0xffffa22c

37.193604 192.168.16.4 -> 172.16.3.3 MySQL Login Request Caps:

37.318319 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

37.435606 172.16.3.3 -> 192.168.16.4 MySQL Response OK

37.438294 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Quit

37.439095 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Quit

47.677699 172.16.3.3 -> 192.168.16.4 MySQL Server Greeting Protocol : 10 ,version: 4.1.10a-standard-log Caps: 0xffffa22c

47.678229 192.168.16.4 -> 172.16.3.3 MySQL Login Request Caps:

47.901597 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

48.012678 172.16.3.3 -> 192.168.16.4 MySQL Response OK

48.018171 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

48.137827 172.16.3.3 -> 192.168.16.4 MySQL Response OK

48.138845 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Quit

48.146600 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

48.285379 172.16.3.3 -> 192.168.16.4 MySQL Response OK

48.286330 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

48.412633 172.16.3.3 -> 192.168.16.4 MySQL Response OK

49.128214 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

49.244233 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

59.582064 172.16.3.3 -> 192.168.16.4 MySQL Server Greeting Protocol : 10 ,version: 4.1.10a-standard-log Caps: 0xffffa22c

59.582581 192.168.16.4 -> 172.16.3.3 MySQL Login Request Caps:

59.700839 172.16.3.3 -> 192.168.16.4 MySQL Response OK

59.702758 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Query :

59.821953 172.16.3.3 -> 192.168.16.4 MySQL Response OK

59.985738 192.168.16.4 -> 172.16.3.3 MySQL Request Command: Quit

Thanks

Brian