MySQL workbench freezes during long query editing forever

Question

I have very long queries text (~50 lines). Recently MySQL workbecnh is exhibiting strange behavior. While editing the query (I open it, I edit one character and want to continue to the next), it freezes forever.

I suspect it can be something related to memory? I see in the preferences there is a default value for maximum query length to store in history in bytes with this default value: 65536. Is this relevant? What do you suggest?

My device is running Ubuntu 18.04 and the workbench is verion 8.0 which is the latest. I cleaned the temp files using: clean and autoclean commands but no hope.

Please help me how to overcome this problem. Knowing that I do not face it when I edit the query in a text editor. Just when I am using the workbench editor. But it is not practical to use external editor.

I also tried to reboot and shut down my device and open the database connection again.

If you need the log, please specify the step to get it for you.

Answer 1

I solved it by disabling Code Completion in Preferences → Query Editor.

Answer 2

Not an answer, but it can help you debug if it's a memory problem

1.- Open mysql-workbench from a terminal window with mysql-workbench --log-level=debug3 -v

2.- Open a second terminal and run this command to monitor the memory and set a baseline, it will autoupdate every 2 seconds (in GB)

while true; do ps aux | grep 'mysql-workbench-bin' | grep -v -E 'grep|catchsegv' |  awk '{$5=int(100 * $5/1024/1024)/100"GB";}{ print;}' | awk '{print $5" "$11}'; sleep 2; done

It will output something like this 0.93GB /usr/lib/mysql-workbench/mysql-workbench-bin every 2 seconds.

3.- Open the query in mysql-workbench and monitor the increase of memory (if any).
Also check the output of the terminal running mysql-workbench.

4.- Open a 3rd terminal and run htop, that will give you an overview of the general usage (cpu/memory/swap) of your system.

Answer 3

I solves this changing some DBMS settings in SQL Editor: