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

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

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

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

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.