distal-attribute
distal-attribute
distal-attribute
distal-attribute

What does (+ 5.975 sec. network) mean in status

User, date Message
Written by wzhao6898
3 years ago
Category: General
2 posts since Fri, 16 Sep 11
Hi there,

I have a query returns status:
/* 0 rows affected, 1,575 rows found. Duration for 1 query: 3.198 sec. (+ 5.975 sec. network) */
does + 5.975 sec. network mean to took the network 5.9 sec to deliver the data to my heidisql client?
thanks,

David
Written by Rapid-eraser
3 years ago
34 posts since Wed, 23 Jun 10
Yes the first reading is the time mysql took to complete the query but the overhead of the data is causing the client to buffer stuff in order to get the complete data set.
At that time only mysql client is blocking just to revise data.
The total blocking time is 3.198+5.975= 9.173sec
Written by wzhao6898
3 years ago
2 posts since Fri, 16 Sep 11
thanks for your reply, does this mean that there is network latency on my network? My client is a window client querying a linux mysql server.
Thanks,

David
Written by Rapid-eraser
3 years ago
34 posts since Wed, 23 Jun 10
Yes but remember that this is between Heidi and mysql server.
If your mysql client is local to the server and if you are connected through a socket there wont be such a delay.
 

Please login to leave a reply, or register at first.