I’m sure there’s plenty of people who would beg to differ, but in my opinion MySQL Workbench is a huge festering pile of shit.
Those of you who have been dealing with MySQL for more than a few years will remember that the administrative applications used to be separate. We had MySQL Query Browser and MySQL Administrator as separate programs. This worked quite well because each program’s goal was individual, so they could strive for an application that did its job well.
The MySQL Query Browser was designed to provide the same sort of interface that phpMyAdmin. It was relatively lightweight and only really had issues when dealing with intensive or laggy queries. MySQL Administrator was also pretty good at its job. It worked out of the box and provided a fast way to monitor and tweak your MySQL server instance.
Now MySQL Workbench tries to combine the two along with a database modelling tool. Anyone with any design experience and sense will immediately realise the problem with this. It means that they can no longer tailor the design and structure of the application to suit a particular task. Instead, it all has to be a generic one-size-fits-all solution that doesn’t do any of its jobs in an optimal way. One would expect that anyone developing an SQL server would understand this problem, but sadly not. You need to put the work in to develop a tool that works well, rather than just grabbing a generic off-the-shelf solution and shipping it.
Here’s a few specific gripes:
- Uses three times the memory the old apps did.
- Leaks memory like a hippocampectomy patient.
- Performs horribly and freezes frequently.
- One tool causing a crash (this happens often) crashes the rest of the tools.
- You have to give the administrator tool full access credentials to your remote machine, i.e. an administrative user on the machine (yes, I’m serious)
- On Linux you have to provide SSH access to the administrator tool.
- On Windows you have to enable remote WMI and allow it through the firewall.
- Random bugs occur (e.g. broken fonts, UI glitches, freezes) and don’t tend to get patched explicitly, though they do randomly get fixed on some platforms.
- Interface is cluttered.
- Tab names and sub-tab names aren’t descriptive, making it difficult to do much at once.
Seems to be that the Oracle model of software development is “if it ain’t broke, fuck with it until it’s broken”.