The delay is definitely on the client side. Packet #17 is the final packet in an "INSERT INTO" statement that comprises packets 2,3,4,6,8,9,11,12,14,15, and 17. The server immediately ACKs this packet in #18. The server very quickly follows up with a "Response OK" in packet #19 indicating that it has successfully fulfilled the request. The client workstation ACKs the 7 bytes from the server response packet in packet #21. At this point, there is no outstanding data on either side.
It is the client that is taking 39.8 seconds to begin issuing the next "INSERT INTO" statement, which begins on packet #58 and continues in 59,60,62,64,65,67, and 68. I'm assuming that this trace was taken on the client machine, and therefore the fact that there are no retransmissions preceding packet #58 indicates that there was no communications problem between the client and server.
Be sure you have TCP Reassembly turned on and you can see the reassembled "INSERT INTO" statements in packets 17 and 68.
One other thing, which doesn't have anything to do with this problem, is that the MSS for the connection appears to be 1380 bytes instead of 1460 bytes. You may need to double check your MTU configuration.
Andrew
-----Original Message-----
From: ethereal-users-bounces@xxxxxxxxxxxx [mailto:ethereal-users-bounces@xxxxxxxxxxxx] On Behalf Of Ben Hall
Sent: Wednesday, January 11, 2006 4:15 PM
To: ethereal-users@xxxxxxxxxxxx
Subject: [Ethereal-users] MySQL application problem?
I am trying to figure out an issue with a distributed MySQL application that seems to halt for
40s.
Ethereal is listing a lot of Request Command: Unknown and is making it more difficult to figure
out. The last real command I see is a Create Database, but the programmer says it is not issuing
a Create Database command and Ethereal must be wrong.
After packet #21, it sits for 40seconds before Packet #58. I see some generic switch traffic, but
that shouldn't be affecting this app.
Any ideas would be great. Even if what you are thinking is that it's an application problem and
it sure is performing a Create Database.
172.30.21.43 = Server and MySQL Database
172.30.19.231 = Desktop Client
Thanks!
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com