Bug #83075 Workbench 6.3.7 Windows 7

• Submitted: 21 Sep 2016 9:22
• Modified: 29 Sep 2016 11:46
• Reporter: Olavo Grego
• Status: Not a Bug
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.3.7
• OS: Windows (Windows 7 SP 1)
• CPU Architecture: Any

[21 Sep 2016 9:22] Olavo Grego

Description:
MySQL workbench is super slow on my current computer to do easy taskts like writing a sql on the editor it freezes and hangs every two words I type or edit copy and paste. 
Tried all work around from previous bugs reports and google it down to exhaustion and nothing. I suspect this is due to use Windows AD and all directories under my user folders are being synced via network (Sync Center).

I want to do a quick test

Is there a way I can change the Default Local Configuration Base File Path:
%AppData%\MySQL\Workbench\

to something like: 
C:\MySQL\Workbench\

I guess then all the working files won't be in use by Sync Center and Workbench will be faster.  

Please let me know.

How to repeat:
Have a windows AD user account shared in the network all users folders form the computer synced in real time. 

Install Workbench 6.3.7 or lower.

Open workbench select any table limit 10. Try to write any SQL simple code like select variables or tables.

[21 Sep 2016 11:38] Chiranjeevi Battula

Hello Olavo Grego,

Thank you for the bug report.
Could you please send us your system configuration like computer, RAM, processor (will get from Workbench ->  Help->System)  to confirm this issue at our end?.

Thanks,
Chiranjeevi.

[21 Sep 2016 16:22] Olavo Grego

Wb log file

Attachment: wb.log (application/octet-stream, text), 8.36 KiB.

[21 Sep 2016 16:23] Olavo Grego

Show info:
MySQL Workbench Community (GPL) for Windows version 6.3.7 CE build 1199 (64 bit)
Configuration Directory: \\UKBEFS01\UserDocs\ogrego\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
Cairo Version: 1.10.2
OS: Microsoft Windows 7 Enterprise Service Pack 1
CPU: 4x Intel(R) Core(TM) i7-3520M CPU @ 2.90GHz, 7.9 GiB RAM
Active video adapter Intel(R) HD Graphics 4000
Installed video RAM: -1984 MB
Current video mode: 1920 x 1080 x 4294967296 colors
Used bit depth: 32
Driver version: 10.18.10.4176
Installed display drivers: igdumdim64.dll,igd10iumd64.dll,igd10iumd64.dll,igdumdim32,igd10iumd32,igd10iumd32
Current user language: English (United Kingdom)

APPDIR=\\UKBEFS01\UserDocs\ogrego\AppData\Roaming\

Thanks

[22 Sep 2016 7:05] Chiranjeevi Battula

Hello Olavo Grego,

Thank you for your feedback.
You are using user data on network share (APPDIR=\\UKBEFS01\UserDocs\ogrego\AppData\Roaming\).
Please  install WB locally without network share (only for testing) and let us know if you have any issue.

Thanks,
Chiranjeevi.

[23 Sep 2016 9:40] Olavo Grego

Is there a way to change the WB appdir folder ? 

I don't have permissions to modify those shared directories. We have strict security for the notebooks on my company.

[23 Sep 2016 9:59] Chiranjeevi Battula

Hello Olavo Grego,

Thank you for your feedback.
Please try test same WB on other machine (even vm without user on "this" network share).

Thanks,
Chiranjeevi.

[23 Sep 2016 16:00] Olavo Grego

On my personal notebook that doesn't have shared directories and no sync it runs fast no hangs nor freezes. 

Thanks

[29 Sep 2016 11:46] Chiranjeevi Battula

Hello Olavo Grego,

Thank you for your feedback.
Thank you for confirming it is a network issue(shared directories).

Thanks,
Chiranjeevi.