[olug] Horribly slow mysql workbench performance under linux

[Adam Haeder]

Dave, you were spot on.

This is a new load of Fedora 19 I just did a few weeks ago. I admit that I
have become pretty spoiled when it comes to desktop Linux: I expect
everything to Just Work(tm). I forget that there are still some tweakings
to do in some situations. Oh the days I wiled away in the past editing
/etc/X11/xorg.conf. But I digress.

This little desktop I'm using has an NVidia Geforce 210 card in it. Once I
did a 'yum install akmod-nvidia' and 'yum upgrade' (and rebooted) I now
have opengl support and access to 3d acceleration. Tested mysql-workbench
with this, still horribly slow. Ran it again with the
'--force-opengl-render' option, and viola, back to the snappy application I
remember. So that was it - mysql-workbench was trying to use opengl, and
since I didn't have the support it was enabled, it was falling back to
software rendering which is SLOOOOW

Thanks for the advice. My only issue now is that about 1/3 of the time the
damn app crashes about 5 seconds after startup. Not sure if that's an
opengl thing or a mysql-workbench thing. I'm guessing the latter; it was
never the more stable of the applications.

Thanks again


On Mon, Aug 5, 2013 at 3:15 PM, Dave Rowe <dave at roweware.com> wrote:

> A shot in the dark - but isn't there an option for hardware/software
> based rendering?  Ie, if it isn't using your video card things could
> be annoyingly sluggish.
>
> It has been a while since I've used the tool, but remember something
> along those lines...
>
> -Dave
>
> On Mon, Aug 5, 2013 at 3:10 PM, Adam Haeder <adam at adamhaeder.com> wrote:
> > I'm running the latest version of MySQL workbench (5.2.47) under a fresh
> > install of Fedora 19. I'm hitting a database server that has a dozen or
> so
> > databases, with a total of maybe 100 tables between all the databases,
> and
> > the performance of the application is TERRIBLE. Navigating around the UI
> is
> > an operation in frustration, as every click generates a 3-5 (or more)
> > second wait until the GUI responds to what I just clicked. Running 'top'
> > shows me that mysql is consuming all of one of CPUs pretty much all of
> the
> > time, and the little hard drive light on the front of my pc lights up and
> > stays lit up every time the UI seems to 'go to sleep'.
> >
> > I know this isn't a database issue, the load is low and queries are
> coming
> > back in no time. The desktop is a core i5 @ 3.2GHz with 4G ram running
> > 64bit Fedora 19. I've read some threads on the forums, and the only thing
> > people suggest is to lower the history limit in the preferences, which I
> > have done to no affect.
> >
> > It seems to be specifically limited to the Linux version of the app,
> > because I have a Windows 7 vm running on this same box (under virtualbox)
> > with the same version of mysql workbench installed, and none of these
> > problems occur.
> >
> > Anyone else ran into this? Any workarounds? I'd hate to have to use a
> > windows VM just to run this one app. Thanks
> >
> > --
> > Adam Haeder
> > adam at adamhaeder.com
> >
> > Check out my latest book: LPI Linux Certification in a Nutshell from
> > O'Reilly: http://bit.ly/bvQQ0I
> > _______________________________________________
> > OLUG mailing list
> > OLUG at olug.org
> > https://lists.olug.org/mailman/listinfo/olug
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> https://lists.olug.org/mailman/listinfo/olug
>



-- 
Adam Haeder
adam at adamhaeder.com

Check out my latest book: LPI Linux Certification in a Nutshell from
O'Reilly: http://bit.ly/bvQQ0I