forums › forums › SQLyog › SQLyog Comments › Very Slow With Ssh Tunnel
- This topic is empty.
-
AuthorPosts
-
-
June 30, 2009 at 6:00 am #29247
navyashree.r
MemberHi,
Currently we are on progressing to improve this “reconnect” functions in SQLyog.
With SSH there are many reasons this latency can occur. The ssh connection happens through ssh client plink. The reconnect happens mainly for 2 reasons,
1. If any network issue happens between ssh server, again this plink neeed to re-initialize.
2. Because of less wait_timeout.
We will look into this and you could expect noticeable improvements in 8.13 Beta2.
BTW…
* Could you please tell us whether SQLyog & SSH are in same machine?
* What is the MySQL version?
* Also please tell the o/p of show variables like '%timeout'?
Regards,
Navya
-
June 30, 2009 at 6:48 am #29248
tomp_gl
MemberSQLyog is on my desktop, and the SSH daemon is on the remote gateway.
MySQL version is 5.0.45-log.
mysql> SHOW VARIABLES LIKE '%timeout%';
connect_timeout 50
delayed_insert_timeout 300
innodb_lock_wait_timeout 50
innodb_rollback_on_timeout OFF
interactive_timeout 50
net_read_timeout 30
net_write_timeout 60
slave_net_timeout 3600
table_lock_wait_timeout 50
wait_timeout 5
Thanks
-
June 30, 2009 at 6:48 am #29249
tomp_gl
Member[accidently double posted]
-
June 30, 2009 at 8:01 am #29250
nithin
MemberThanks for quick response.
From the output of SHOW VARIABLES LIKE '%timeout%' I understand the wait_timeout set for 5 seconds. It means if SQLyog idle for more than 5 seconds It needs reconnection for the next query to execute. With current implementation the reconnect functionality always requires reconnect to server and re-initializing plink. We already told that we are in progress of improving this reconnect operation that doesn’t need re-initializing plink(if no network issue happened) and also reconnecting the sever using MySQL APIs, and I hope this will solve the latency you are facing.
We can provide you special build probably by 3 – 5 days once the development is over.
I will update the status here.
-
June 30, 2009 at 10:59 am #29251
nithin
MemberAs a workaround execute this query from SQLyog editor once connected to the server.
set @@session.wait_timeout = 28800;
The session wait_timeout can overirde the 5 second timeout set for the server. But this query is required for each time when SQLyog connected to server.
Please tell this workaround solves the latency issue or not?
Thanks
-
June 30, 2009 at 10:49 pm #29252
tomp_gl
MemberThanks! That fixed the problem.
-
July 15, 2009 at 2:55 pm #29253
navyashree.r
MemberHi,
This issue is fixed and available in 8.13 beta2, publicly available!
Please refer to:
http://www.webyog.com/blog/2009/07/15/sqly…-been-released/
Please let us know the status.
Thank you.
Regards,
Navya
-
September 14, 2012 at 1:21 am #29254
Jet
MemberHi, I use sqlyog v 8.82 and connec to mysql use ssh tunnel very very slowly.
mysql> SHOW VARIABLES LIKE '%timeout%';
+
+
+| Variable_name | Value |
+
+
+| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 28800 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| table_lock_wait_timeout | 50 |
| wait_timeout | 28800 |
+
+
+ -
September 14, 2012 at 7:33 am #29255
peterlaursen
ParticipantPlease explain: is it the connection that establishes slowly (only) or do you experience a slowness also after connection has been established?
-
-
AuthorPosts
- You must be logged in to reply to this topic.