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

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

wzhao6898 posted 3 years ago in General
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
Rapid-eraser posted 3 years ago
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
wzhao6898 posted 3 years ago
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
Rapid-eraser posted 3 years ago
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.