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

Where does get Heidi "network" figures from a query

Joselitux posted 1 year ago in General
Hi folks!

Executing some long queries Heidi is giving me some numbers about duration and network.
vg:

0,045 sec (+35,131 sec. network)



My guess is that we're having network latency issues
must we improve network performance or I'm missing the point?

Thanks
ansgar posted 1 year ago
I'm not 100% sure if you can rely on these details. However, here is how I am counting these both values:
* time that takes mysql_real_query() = query time (0,045 sec)
* time that takes mysql_store_result() = network time (35,131 sec)

Mostly you have long network times on queries which return *much data*. The query itself seems to be ok. The call to mysql_store_result is as far as I know transferring the result over the net.
Joselitux posted 1 year ago
Thanks ansgar
I Will check if running on server itself we Get better numbers. We were worried a bit because of probable latency issues

Thanks a lot
ansgar posted 1 year ago
After the result has "arrived" in the HeidiSQL grid, rightclick the grid, then click "Export grid rows". You will see a roughly calculated size of the whole result. Should be quite much according to 35sec. Or, if it's just a bit, then probably your network connection is slow, or HeidiSQL does the calculation wrong.
itsho posted 5 months ago
Hi.

that's quite weird.
i'm getting this on remote (connected to server IP):
Affected rows: 0 Found rows: 14,560 Warnings: 0 Duration for 1 query: 23.250 sec. (+ 71.828 sec. network)


And this on local (connected to 127.0.0.1):
Affected rows: 0 Found rows: 14,560 Warnings: 0 Duration for 1 query: 23.884 sec. (+ 69.374 sec. network)

i'm using HeidiSQL 8.3.0.4694
MySQL server version is 5.7.4

user01 posted 5 months ago
Is there any way of decreasing this network latency? I want to optimise my queries as well?

Thanks.
ansgar posted 5 months ago
Be sure to have "Compressed protocol" activated in your session.

Apart from that, increase your bandwidth to your server.

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