Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 56 10 Older Entries

Displaying posts with tag: MySQL Workbench (reset)

MySQL Workbench Plugin: Slow Query Log Statistics
Employee +4 Vote Up -0Vote Down

This is my first attempt at creating a plugin for MySQL Workbench.  As a first step, I’ve created a plugin that summarizes the slow query log if it’s output to the slow_log table, which is an option available in MySQL version 5.1 or newer.  It’s similar to the mysqldumpslow perl script, except that it doesn’t require perl, which should be more convenient on Windows.  In my next update, the plugin will provide the same summary statistics for the slow query log file on disk.

While the slow query log reports query time, lock time, rows sent and rows examined for each query; it’s often useful to group and aggregate similar queries for analysis.  For example, here’s a sample of the plugin output, which is sorted by count, after just a few clicks on a drupal6 site:

  [Read more...]
All-GUI MySQL on Mac
+4 Vote Up -1Vote Down

aka “How to use multiple MySQL Servers and Workbench in Snow Leopard without using Terminal… and live happily ever after”

The MySQL Community is a world of command-line aficionados. Many people, including myself, show their love to the simple-but-powerful interface of the mysql command-line client, but not everybody is keen to use a bash shell and give up its GUI, no matter how powerful the software is.

Until recently, GUI tools for MySQL were half baked solutions: in the end, there was always something that you had to do via the command line. Today, you can install, set up and use MySQL on your Mac with Snow Leopard without using Terminal, at all.

My Special Needs

Before digging into the details of the installation, let me describe what I need on my Mac. I use various versions of MySQL and I often need to run 2 or more

  [Read more...]
MySQL Workbench 5.2 goes GA – partial support for MySQL Cluster
Employee +7 Vote Up -0Vote Down

Configure MySQL Server nodes for MySQL Cluster

The new version of MySQL Workbench (5.2.25) has just gone GA – see the Workbench BLOG for details.

So what’s the relevance to MySQL Cluster? If you have a Cluster that uses MySQL Servers to provide SQL access then you can now use MySQL Workbench to manage those nodes:

  • Start & stop the mysqld processes
  • Configure the per-mysqld configuration data held in my.cnf or my.ini

The reason that I describe the support as ‘partial’ is that these MySQL Servers are treated as independent entities (no concept of them being part

  [Read more...]
Breakfast seminar on what’s new with MySQL – London
Employee +2 Vote Up -0Vote Down

If you’re in London on Thursday 24th June then there’s a great chance to find out what’s new in MySQL.

Join us for an Oracle MySQL Breakfast Seminar to better understand Oracle’s MySQL strategy and what’s new with MySQL!
09:00 a.m.    Welcome Coffee/Tea
09:30 a.m.    Oracle’s MySQL Strategy
10:00 a.m.    What’s New – The MySQL Server & MySQL Cluster
10.45 a.m.    Coffee/Tea Break
11:00 a.m.    What’s New – MySQL Enterprise & MySQL Workbench
11:45 a.m.    Q&A
12:00 noon    End of the Breakfast Seminar

None, it’s a free event! But places are

  [Read more...]
InfiniDB Alpha 1.1.2 on 64-bit Windows and MySQL Workbench
Employee +1 Vote Up -0Vote Down
This week has been rough on my computers and I had to reinstall Vista on my main Windows system. But being a 'glass half full' guy, I took it as an opportunity to load the new alphas for both InfiniDB and MySQl Workbench.

I downloaded the InfiniDB software from and Workbench from respectively. In stalled them in that order and started the database and then Workbench.

I was expecting to have to fiddle with configuring one or the other to get them to work together. But I received a delightful surprise. Both worked out of the chute with no customization. Congratulations to the folks writing the install scripts at both companies!
A Useful Tool to Centrally Manage Many MySQL Instances
+7 Vote Up -2Vote Down

I have been talking with a group of folks who have been making a product that has lots of free functionality, including the ability to centrally manage many MySQL instances. The administration functions include starting and stopping MySQL, seeing status and system variables, seeing and managing the MySQL config file (/etc/my.cnf), seeing and managing accounts, a small dashboard of overall health graphs, and more.

With this free tool you can look at and manage local and remote databases. It supports ssh tunneling, including ssh using password-protected ssh keys. It’s pretty neat, and I have been working with the product manager to add features. I think this took will become the de facto standard for centralized GUI administration of MySQL.

The tool is
MySQL workbench….Surprise! One of the best new features for the

  [Read more...]
MySQL Workbench 5.2.16 Beta
+1 Vote Up -0Vote Down

MySQL Workbench 5.2.16 is a beta release, which comes with upgraded query browser, upgraded system administrator and addition features of workbench as a all in one bundle.

I was using workbench 5.0 earlier and the changes in 5.2.16 is very much visible. Best thing I could utilize is printing the ER diagrams to pdf files and other file formats. It’s now lot more easier to use and seems like many bugs have been addressed.

The 5.2.16 beta release is enabled to store passwords in OSX-keychain, gnome-keyring or on windows in a encrypted password-vault-file
New wizard added and reworked the “new server instance”.
Features like SQL templates from object context-menu to copy statements to clipboard or right into the query area
Administration module stabilization has been improved
Added option to change the placement of the sidebar in query mode

  [Read more...]
Updates in unstable repo (not only) for openSUSE
+0 Vote Up -0Vote Down

I already mentioned this repository several times on my blog. It is the repository where I’m trying to keep bleeding edge stuff for MySQL. I’ve been updating it recently and we’ve got new package there and some interesting updates I want to mention.

MariaDB and MySQL

First thing to mention is that this repository contains MariaDB builds. MariaDB is fork of MySQL and their goals are certainly interesting. For list of differences, try upstream page. As I consider it interesting, I’m keeping eye on it Maybe our users may benefit from it.

  [Read more...]
MySQL Unstable Builds
+0 Vote Up -0Vote Down

It’s been some time already since I informed you about server: database: UNSTABLE repository in openSUSE Build Service. Today I want to mention what is going on there. As the name of the repository suggests, it’s probably not the best idea to use anything from here on your production servers

MySQL 5.4

I’m keeping there MySQL 5.4. Currently in version 5.4.3 beta. 5.4 branch of MySQL contains some patches to improve performance. That is the reason why it might be interesting. Downside is that it isn’t released as often as 5.1 and it is not considered production ready. I already

  [Read more...]
MySQL Workbench 5.1.16 is GA!
+0 Vote Up -0Vote Down
MySQL Workbench Version 5.1.16 the General Availability build can be downloaded at to the Workbench team for their great effort in this release.
10 Newer Entries Showing entries 31 to 40 of 56 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.