Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why is mysql workbench editor is so slow when working on a slow network?

I recently upgraded from Mysql workbench 5.x to 6.0.7.11215, And I am noticing strange slowness problem.

Whenever I try to edit the query, move the cursor around, or just try to add any characters, the editor hangs for a bit for a few seconds, and then resume normally.

This only happens when I am using a slow network connection to the server.

This issue was never there in the old Mysql workbench verison 5.x.

I disabled autocomplete, and restarted the program, but the issue is still there.

I used wireshark to examine the network traffic, and noticed a few of SSH packets at the time of the slowness, but I can't really know what is in them since, since the packets are encrypted. (it is worth noting that I am using database connection over an ssh tunnel)

like image 419
sharp12345 Avatar asked Oct 18 '13 17:10

sharp12345


1 Answers

I guess the slowness happens because of the context help. This feature queries the server's help tables to get help information for a specific topic that MySQL Workbench derives from the current caret position. Try this: hide the context help pane (activate snippet tab or hide the right side bar). If that context help pane is not visible no help queries are sent.

For more information about the context help see my blog post here: http://mysqlworkbench.org/2013/08/mysql-workbench-6-0-help-is-on-the-way/

like image 112
Mike Lischke Avatar answered Sep 28 '22 06:09

Mike Lischke