Direct Schema Tree Action Buttons

The schema tree in the SQL Editor now has some very convenient buttons for accessing the most used functions for each object type:

• Table or Schema Inspector
• Object structure editor
• Table data browser/editor
• Call Stored Procedure or Function

Format Note Objects in Diagrams

Note objects in diagrams can now be resized and have its contents automatically rearranged. You can also change style attributes like font, background color and text color.

Other improvements and bug fixes that make a difference

MySQL password is remembered for the session, even if not …

MySQL Fabric Support

MySQL Fabric servers can now be added to the Workbench home screen. When clicked, these connections will dynamically query the Fabric server and individual connections for all the managed MySQL servers will be created. You can then connect to each instance as usual. 

Metadata Lock Browser

MySQL uses metadata locking to manage access to objects (tables, triggers, and so forth). Sometimes that can be puzzling, as your query may block waiting on an object being manipulated by another connection from maybe another user. The Client Connections list was updated to take advantage of the metadata lock information provided in the performance_schema starting in MySQL 5.7.3, to show …

Today MySQL is officially joining the GitHub community, with the launch of a beta GitHub repo for MySQL Server. Why We’re Doing It GitHub has become the place to be for successful open source projects; it has a large and rapidly growing user base, it is robust and fast, and it provides excellent tools for building and supporting vibrant open source […]

Improved Visual Explain

In MySQL 5.7, the Optimizer Team has been doing great work in refactoring as well as innovation with the new Cost Model. The improved Visual Explain enables the DBA to now get deeper insights into Optimizer decision making, for improved performance tuning of queries.   The UI was also improved to allow easier navigation in large query plans.

Streamlined Query Results Panel

The query results panel was updated to centralize the many features related to result sets into a single location. Result Grid, Form Editor, Field Types, Query Stats, Execution Plan (including the traditional and Visual Explain) and the new Spatial Viewer are all easily accessible from a single interface.

Run SQL …

The Spatial Viewer

MySQL 5.7 will include much awaited GIS support for InnoDB tables. To make it easier to quickly visualize spatial/geometry data in geographic context, Workbench 6.2 includes a viewer for resultsets containing that type of data. The viewer will render data from each row as a separate clickable element. When clicked, you can view the rest of the data from that row in the textbox. If you have multiple queries with geometry data, you can overlay them in the same map.

But that’s not all the features. The Spatial Data Viewer give you the possibility to display the data using different projection systems. Right now you can use Robinson, Mercator, Equirectangular, Bonne. There’s option to even merge different resultsets, execute all of them and switch to …

September 17, 2014 By Severalnines

The Severalnines team is pleased to announce the release of ClusterControl 1.2.8. This release contains key new features along with performance improvements and bug fixes. We have outlined some of the key new features below. 

Highlights of ClusterControl 1.2.8 include:

• YUM/APT repositories for ClusterControl
• Deployment and scaling of single-node MySQL, MariaDB and MongoDB
• Alerts and incident tracking with PagerDuty 
• Unified Event Viewer
• New flexible alarms/email notification system
• Audit logging - Administrator activity tracking
• Global MySQL User Management
• New default dashboards for MySQL/MariaDB
• Puppet Module …

Dear MySQL Users,

The MySQL developer tools team announces 6.2.2 RC – the final release
candidate for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the upcoming major update for the official MySQL
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL
5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5,
with features such as:

• A new spatial data viewer, allowing graphical views of result sets
  containing GEOMETRY data and taking advantage of the new GIS
  capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting
  on.
• MySQL Fabric cluster connectivity – Browsing, view status, and connect
  to any MySQL instance in a Fabric Cluster. …

The MySQL developer tools team announces 6.2.2 RC – the final release candidate for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the upcoming major update for the official MySQL 
graphical development tool .

MySQL Workbench 6.2 focuses on support for innovations released in MySQL 5.6  and MySQL 5.7
DMR (Development Release) as well as MySQL Fabric 1.5, with features such as:

• A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and
   taking advantage of the new GIS capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting on.
• MySQL Fabric cluster connectivity – Browsing, view status, and connect to any MySQL instance in a 
  Fabric Cluster. …

The MySQL Workbench team is announcing availability of the first beta release of its upcoming major product update, MySQL  Workbench 6.2.

MySQL Workbench 6.2 focuses on support for innovations released in MySQL 5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5, with features such as:

• A new spatial data viewer, allowing graphical views of result sets containing GEOMETRY data and taking advantage of the new GIS capabilities in MySQL 5.7.
• Support for new MySQL 5.7.4 SQL syntax and configuration options.
• Metadata Locks View shows the locks connections are blocked or waiting on.
• MySQL Fabric cluster connectivity - Browsing, view status, and connect to any MySQL instance in a Fabric Cluster.
• MS Access migration Wizard - easily move to MySQL Databases.

Other significant usability improvements were made, …

The MySQL Workbench team announces availability of version 6.1.7 of its flagship product.

MySQL Workbench 6.1.7 is a periodic maintenance release including 17 bug fixes. Additionally, the supported Linux distribution list has been refreshed. Users of the product are recommended to upgrade to this version.

MySQL Workbench 6.1

With over 30 new features, this version has many significant enhancements focusing on real-time performance assessment and analysis from the SQL statement level to server internals and file IO. You can see this from additions to the SQL Editor as well as new dashboard visualization and reporting that take advantage of MySQL Server 5.6 and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans.

Additionally Workbench 6.1 is leveraging work from various teammates in MySQL Engineering by introducing a schema called "SYS" that provides simplified views …