MySQL Bugs: #58733: mysql workbench performance is very slow

Bug #58733	mysql workbench performance is very slow
Submitted:	4 Dec 2010 17:11	Modified:	9 Dec 2010 0:50
Reporter:	Ryan adslf	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S5 (Performance)
Version:	5.2.30	OS:	Other (Windows 7 x64)
Assigned to:		CPU Architecture:	Any

Description:
when I perform a simple query which return 100 or more rows a significant portion of the time is spent rendering the rows to the screen. also when I try to scroll down the results it appears to be re-rendering the rows every time it moves. I had been using the Mac version without any trouble but today I decided to try it on my new windows PC and it is just terrible.

my mac is a Core 2 Duo 2.33Ghz with 3GB ram.
my windows 7 pc is a Core i7 2.8 Ghz with 6GB ram.

How to repeat:
run a simple query which return 100 rows or more.

Suggested fix:
it appears to be a rendering bug, the contents of the window should be rendered to a frame buffer or something so that they are not constantly being re-rendered.

How many columns are there? What are their types and usual length?
What kind of video card does that machine use? Can you paste the output of Help -> System Info?
A 100 row query here doesn't come up instantly for sure, but it's not slow either.
How slow is "very slow"? Takes a minute to render the results? 10 seconds? 5?
 If you could show a screen recording of what you're describing, 
it would make it easier to see what you mean.

the query I have been running has 26 columns, they are mostly varchars and ints. the windows 7 computer has an EVGA 470 video card which is a powerful card.

as for how long it takes, on my mac it usualy displays in 1-2 seconds. On the windows 7 computer it takes 4-5 seconds and continues to refresh them (they disappear and reappear) for about another 5-7 seconds. scrolling through the results is also very slow.

I will try to attach a video of the issue.

performance problem

Attachment: smaller file.mp4 (video/mp4, text), 446.19 KiB.

Please, send the output of Help > System Info menu item. I'd like to check if OpenGL is used with your card.

I think i may have discovered the root of the problem. I had been running the Folding@home GPU client which doesn't impact most of the applications I have been running, including video games. apparently when running the Folding@home GPU client OpenGL performance decreases significantly. when I turned off the Folding@home client I was a able to see the query load in about the same amount of time as my mac and scrolling was much faster, I would have expected it to be a little smoother but it is good now.

here is the sys info anyways:

MySQL Workbench CE for Windows version 5.2.30

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 4.1.0

OS: Microsoft Windows 7 Ultimate Edition (build 7600), 64-bit

CPU: 8x Intel(R) Core(TM) i7 CPU         930  @ 2.80GHz, 6.0 GiB RAM

Video adapter info:

Adapter type: NVIDIA GeForce GTX 470

Chip Type: GeForce GTX 470

BIOS String: Version 70.0.21.0.70

Video Memory: 1310720 KB

Current user language: English (United States)

Starting thread...

Thread started

63000 INFO Connecting to SSH server at 192.168.2.51:22...

C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE/python/site-packages\paramiko\client.py:93: UserWarning: Unknown ssh-rsa host key for 192.168.2.51: 4d77b4d681b89da487b597514f055298

  (key.get_name(), hostname, hexlify(key.get_fingerprint())))

New client connection

client connection established

63000 INFO Tunnel now open ('127.0.0.1', 49225) -> ('192.168.2.51', 22) -> ('192.168.2.51', 3306)

New client connection

client connection established

63000 INFO Tunnel now open ('127.0.0.1', 49228) -> ('192.168.2.51', 22) -> ('192.168.2.51', 3306)

MySQL Workbench CE for Windows version 5.2.30

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 4.1.0

OS: Microsoft Windows 7 Ultimate Edition (build 7600), 64-bit

CPU: 8x Intel(R) Core(TM) i7 CPU         930  @ 2.80GHz, 6.0 GiB RAM

Video adapter info:

Adapter type: NVIDIA GeForce GTX 470

Chip Type: GeForce GTX 470

BIOS String: Version 70.0.21.0.70

Video Memory: 1310720 KB

Current user language: English (United States)