piggyback icon indicating copy to clipboard operation
piggyback copied to clipboard

mysql really slow when running over piggyback

Open jmallar3 opened this issue 5 years ago • 0 comments

We're noticing that when piggyback is used to bridge a connection to MySql/RDS, a) it takes MySql much longer to connect to the datasource, and b) simple queries take much longer.

ssh -F ~/.ssh/piggyback -i ~/.ssh/my.pem -T -L 9997:my-rds-host:8080 {jumphostip}

$ cat ~/.ssh/piggyback
Host * !github.nike.com !github.com
    SendEnv LANG LC_*
    ServerAliveInterval 30
    StrictHostKeyChecking no
    ProxyCommand /usr/local/bin/piggyback proxy-host 443 %h %p
    ServerAliveInterval 60

Connecting via MySqlWorkbench... The connection seems to establish within a few seconds, like it does without piggyback, but then something happens, and I get a spinner, and it stays there for ~ 30-45 seconds, and then I get a response.

Running queries shows similar effects. The query can take several minutes to run, but the actual execution time of the query is in milliseconds.

As a test, I ran this SQL (which isn't even valid SQL).
select now;

After hitting return, I got a spinner for ~30-45 seconds, and then an error. The execution time of the query that return the error is .098 seconds.

Something is introducing communication delays here.

jmallar3 avatar Jul 16 '19 21:07 jmallar3