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 …

  [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 …

  [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 …
  [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!
Agenda:
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 …





  [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 http://infinidb.org/downloads/cat_view/40-binary-release/137-112-alpha-binary-releases and Workbench from http://dev.mysql.com/downloads/workbench/ 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 …



  [Read more...]
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 …

  [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 …

  [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 …

  [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. …

  [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 http://dev.mysql.com/downloads/workbench/5.1.html.Congratulations 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.