MySQL Workbench as an administrative tool


MySQL Workbench is a handy administrative tool. Workbench provides server status information, client connection data, the best user admin interface, a browser for system variables, access to data export, an import/restore function, access to system logs, option file editing, performance reports, and startup/shutdown switch.

This is a snapshot of the dashboard on a laptop running a few very simplequeries.

This is a snapshot of the dashboard on a laptop running a few very simplequeries.

In the past I have either used the CLI or tools like PHPMyAdmin. Well, the CLI is often victim to my poor typing skills and PHPMyAdmin is not always installed when I need it. But if I can connect via the CLI, I can connect with Workbench.

The Server variables can be easily copied to a clipboard with one click

The Server variables can be easily copied to a clipbaord

Comparing server variables across systems can be painful but Workbench lets you copy the data to a clipboard so you can save the data to a text file that can be used with diff or similar tool to find discrepancies. This is also a hand trick for documenting instances. Over the past few releases, the Workbench Team have added items like this that show they know what information a DBA scrambles for in the wee hours of the morning when hunting problems.

A performance report on the most active files on the instance.

A performance report on the most active files on the instance.

Need Performance Schema info? It is there too. Calculating Runtimes in the 95th percentile used to be a ‘dark art’ that is now just a click away.

So if you are looking for a great admin tool, check out MySQL Workbench.

About these ads

3 Comments

Filed under MySQL Workbench

3 responses to “MySQL Workbench as an administrative tool

  1. I’m using MySQL Workbench 6.0, but dashboard you show. Where do I find this? Thanks!

  2. Enow

    Great post.Only issue i have with workbench is its poor auto-completion – it’s not context sensitive.has that been addressed in wb 6.1 ?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s