What does (+ 5.975 sec. network) mean in status
| User, date | Message |
|---|---|
|
Written by wzhao6898
2 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
2 years ago 33 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
2 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
2 years ago 33 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. |