Monday Jun 15, 2015

MySQL Workbench 6.3.4 GA has been released

The MySQL developer tools team announces 6.3.4 as our GA release for MySQL Workbench 6.3.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.3.4 GA now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 21 and Fedora 22, Ubuntu 14.04, Ubuntu
14.10 and Ubuntu 15.04 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

Enjoy!

Changes in MySQL Workbench 6.3.4 (2015-06-15)

  For detailed information about the new features, see What's
  New in MySQL Workbench 6.3
  (http://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html).

   Functionality Added or Changed

     * Added MySQL Enterprise Firewall support. For additional
       information, see MySQL Enterprise Firewall Interface
       (http://dev.mysql.com/doc/workbench/en/wb-mysql-firewall.html).

    * On Windows, SQL files are now automatically associated to
       MySQL Workbench after the installation.

On behalf of Oracle MySQL Release Team,
Murthy Narkedimilli

Friday Apr 24, 2015

MySQL Workbench 6.3.3 GA has been released

The MySQL developer tools team is pleased to announce 6.3.3 as our GA release for the MySQL Workbench 6.3

For the full list of changes in this revision, visit

http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For detailed information about the new features, see What’s
New in MySQL Workbench 6.3
http://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.3.3 GA now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 20 and Fedora 21, Ubuntu 14.04 and Ubuntu
14.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

Enjoy !

Friday Mar 13, 2015

MySQL Workbench 6.3.2 RC has been released

The MySQL developer tools team is pleased to announce 6.3.2 RC - the first release candidate for MySQL Workbench 6.3

For the full list of changes in this revision, visit

http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For detailed information about the new features, see What’s
New in MySQL Workbench 6.3
http://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.3.2 RC now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 20 and Fedora 21, Ubuntu 14.04 and Ubuntu
14.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

Enjoy !

Thursday Mar 05, 2015

MySQL Workbench 6.3.1 Beta has been released

The MySQL developer tools team is pleased to announce 6.3 Beta - the start of the public beta testing phase of MySQL Workbench 6.3

This release contains a number of new and enhanced features which are feature complete but might still contain
bugs. So use them with care.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For detailed information about the new features, see What’s
New in MySQL Workbench 6.3
http://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.3.1 beta now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 20 and Fedora 21, Ubuntu 14.04 and Ubuntu
14.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

Enjoy !

Wednesday Mar 04, 2015

MySQL Workbench 6.2.5 GA has been released

The MySQL developer tools team announces 6.2.5 as our maintenance release for MySQL Workbench 6.2.

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-2.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.2.5 now, for Windows, Mac OS X 10.7+,
Oracle Linux 6 and 7, Fedora 20, Fedora 21, and Ubuntu 14.04, Ubuntu
14.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/


Enjoy!

Changes in MySQL Workbench 6.2

   For detailed information about the new features, see What's
   New in MySQL Workbench 6.2
   (http://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html).


On behalf of the MySQL Workbench and the MySQL/ORACLE RE Team.

Vishal Chaudhary

Thursday Nov 20, 2014

MySQL Workbench 6.2.4 GA has been released

The MySQL developer tools team announces 6.2.4 as our maintenance release for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the new version 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.
  • MS Access migration Wizard - easily move to MySQL Databases.

Other significant usability improvements were made, aiming to raise productivity for advanced and new users:

  • Direct shortcut buttons to commonly used features in the schema tree.
  • Improved results handling. Columns have better auto-sizing and their widths are saved. Fonts can also be customized. Results "pinned" to persist viewing data.
  • A convenient Run SQL Script command to directly execute SQL scripts, without loading them first.
  • Database Modeling has been updated to allow changes to the formatting of note objects and attached SQL scripts can now be included in forward  engineering and synchronization scripts.
  • Integrated Visual Explain within the result set panel.
  • Visual Explain drill down for large to very large explain plans.
  • Shared SQL snippets in the SQL Editor, allowing multiple users to share SQL code by storing it within a MySQL instance.
  • And much more.

The list of provided binaries was updated and MySQL Workbench binaries
now available for:
  • Windows 7 32 and 64bits
  • Mac OS X Lion or newer
  • Ubuntu 12.04 LTS and Ubuntu 14.04 64bits
  • Fedora 20 64bits
  • Oracle Linux 6.5 64bits
  • Oracle Linux 7 64bits
  • Sources for building in other Linux distributions. Pre-compiled binaries are no longer provided for 32bit Linux distributions, although users may still download and build from sources.
Note: Workbench for Windows requires Visual C++ Redistributable for
Visual Studio 2013, which can be downloaded from:

http://www.microsoft.com/en-us/download/details.aspx?id=40784

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-2.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.2.4 now, for Windows, Mac OS X 10.7+, Oracle
Linux 6 and 7, Fedora 20, Ubuntu 12.04 and Ubuntu 14.04 or sources,
from:

http://dev.mysql.com/downloads/tools/workbench/

Tuesday Sep 23, 2014

MySQL Workbench 6.2.3 GA has been released

The MySQL developer tools team announces 6.2.3 as our GA release for MySQL Workbench 6.2.

MySQL Workbench 6.2 is the new version 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.
  • MS Access migration Wizard - easily move to MySQL Databases.

Other significant usability improvements were made, aiming to raise
productivity for advanced and new users:

  • Direct shortcut buttons to commonly used features in the schema tree.
  • Improved results handling. Columns have better auto-sizing and their widths are saved. Fonts can also be customized. Results "pinned" to persist viewing data.
  • A convenient Run SQL Script command to directly execute SQL scripts, without loading them first.
  • Database Modeling has been updated to allow changes to the formatting of note objects and attached SQL scripts can now be included in forward  engineering and synchronization scripts.
  • Integrated Visual Explain within the result set panel.
  • Visual Explain drill down for large to very large explain plans.
  • Shared SQL snippets in the SQL Editor, allowing multiple users to share SQL code by storing it within a MySQL instance.
  • And much more.

The list of provided binaries was updated and MySQL Workbench binaries
now available for:
  • Windows 7 32 and 64bits
  • Mac OS X Lion or newer
  • Ubuntu 12.04 LTS and Ubuntu 14.04 64bits
  • Fedora 20 64bits
  • Oracle Linux 6.5 64bits
  • Oracle Linux 7 64bits
  • Sources for building in other Linux distributions. Pre-compiled binaries are no longer provided for 32bit Linux distributions, although users may still download and build from sources.
Note: Workbench for Windows requires Visual C++ Redistributable for
Visual Studio 2013, which can be downloaded from:

http://www.microsoft.com/en-us/download/details.aspx?id=40784

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-2.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.2.3 now, for Windows, Mac OS X 10.7+, Oracle
Linux 6 and 7, Fedora 20, Ubuntu 12.04 and Ubuntu 14.04 or sources,
from:

http://dev.mysql.com/downloads/tools/workbench/

Friday Sep 05, 2014

MySQL Workbench 6.2.2 RC has been released

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.
  • MS Access migration Wizard – easily move to MySQL Databases.

Other significant usability improvements  were made, aiming to raise productivity for advanced and new users:
  • Direct shortcut buttons to commonly used features in the schema tree.
  • Improved results handling. Columns have better auto-sizing and their widths are saved. Fonts can also be
    customized. Results “pinned” to persist viewing data.
  • A convenient Run SQL Script command to directly execute SQL scripts, without loading them first.
  • Database Modeling has been updated to allow changes to the formatting of note objects and attached SQL
    scripts can now be included in forward engineering and synchronization scripts.
  • Integrated Visual Explain within the result set panel.
  • Visual Explain drill down for large to very large explain plans.
  • Shared SQL snippets in the SQL Editor, allowing multiple users to share SQL code by storing it within a
    MySQL instance. 
  • And much more.

The list of provided binaries was updated and MySQL Workbench binaries now available for:

  • Windows 7 32 and 64bits
  • Mac OS X Lion or newer
  • Ubuntu 12.04 LTS and Ubuntu 14.04 64bits
  • Fedora 20 64bits
  • Oracle Linux 6.5 64bits
  • Oracle Linux 7 64bits
  • Sources for building in other Linux distributions. Pre-compiled binaries are no longer provided
     for 32bit Linux distributions, although users may still download and build from sources.

For the full list of changes in this revision, visit 

http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-2.html

For discussion, join the MySQL Workbench Forums:

http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.2.2 now, for Windows, Mac OS X 10.7+, Oracle

Linux 6 and 7, Fedora 20, Ubuntu 12.04 and Ubuntu 14.04 or sources,
from:

http://dev.mysql.com/downloads/tools/workbench/

Tuesday Aug 19, 2014

MySQL Workbench 6.2.1 BETA has been released


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, aiming to raise productivity for advanced and new users:
  • Direct shortcut buttons to commonly used features in the schema tree.
  • Improved results handling. Columns have better auto-sizing and their widths are saved. Fonts can also be customized. Results "pinned" to persist viewing data.
  • A convenient Run SQL Script command to directly execute SQL scripts, without loading them first.
  • Database Modeling has been updated to allow changes to the formatting of note objects and attached SQL scripts can now be included in forward engineering and synchronization scripts.
  • Integrated Visual Explain within the result set panel.
  • Visual Explain drill down for large to very large explain plans.
  • Shared SQL snippets in the SQL Editor, allowing multiple users to share SQL code by storing it within a MySQL instance.
  • And much more.

The list of provided binaries was updated and MySQL Workbench binaries now available for:
  • Windows 7 or newer
  • Mac OS X Lion or newer
  • Ubuntu 12.04 LTS and Ubuntu 14.04
  • Fedora 20
  • Oracle Linux 6.5
  • Oracle Linux 7
  • Sources for building in other Linux distributions

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-2.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.2.1 now, for Windows, Mac OS X 10.7+, Oracle Linux 6 and 7, Fedora 20, Ubuntu 12.04 and Ubuntu 14.04 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

On behalf of the MySQL Workbench and the MySQL/ORACLE RE Team.

Tuesday Jul 01, 2014

MySQL Workbench 6.1.7 GA has been released

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 on Performance Schema, Information Schema, and other areas. Special thanks to the server optimizer team, server runtime team, and Mark Leith.  For Oracle DBAs MySQL SYS is similar to the V$ catalog views, and MSSQL folks its like DMVs (Dynamic Management Views).

MySQL Workbench 6.1 includes:

  • Improved drag and drop support in the Home screen and SQL Editor.
  • Visual Explain 2. The Visual Explain feature was revamped and is now easier to read and interpret. You can also get the traditional tabular explain output from within the same interface.
  • Performance Dashboard. A graphical representation of some key statistics from the server status, gives you a bird's eye view of the status of key server subsystems.
  • For advanced users, Performance Schema Instrumentation. A GUI for configuring the Performance Schema in detail, for advanced users.
  • Performance Schema based reporting. Gives insight into the operation of the server through many high-level reports.
  • New query result view. Get more information about queries you execute, such as information about the fields in your result set and key performance statistics from your query (timing, index usage, number of rows scanned, joins etc).
  • Form Editor for resultsets. In addition to the result grid, you can now edit records row by row in a form style editor.
  • Table Inspector. Similar to the Schema Inspector, view detailed information from tables. A streamlined interface for creating indexes is also included.
  • Support for the Windows accessibility API and Windows high contrast color schemes. A new high contrast theme has been introduced.
  • And more.

More than 60 enhancement requests and bugs reported by users have also been addressed, providing performance, usability and stability improvements across the board.

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-1.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.1.7 now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 20, Ubuntu 12.04 and Ubuntu 14.04 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products.

Quick links:
-http://mysqlworkbench.org/
- Download:http://dev.mysql.com/downloads/tools/workbench/
- Bugs:http://bugs.mysql.com
- Forums:http://forums.mysql.com/index.php?151

Enjoy!


Friday May 16, 2014

MySQL Workbench 6.1.6 GA has been released

The MySQL developer tools team announces 6.1.6 as our GA release for MySQL Workbench 6.1.

MySQL Workbench 6.1.6 is a maintenance release and contains over 30 fixes and minor enhancements made since the original GA release.

MySQL Workbench 6.1

Introducing 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 on Performance Schema, Information Schema, and other areas. Special thanks to the server optimizer team, server runtime team, and Mark Leith.  For Oracle DBAs MySQL SYS is similar to the V$ catalog views, and MSSQL folks its like DMVs (Dynamic Management Views).

MySQL Workbench 6.1 includes:

  • Improved drag and drop support in the Home screen and SQL Editor
  • Visual Explain 2. The Visual Explain feature was revamped and is now easier to read and interpret. You can also get the traditional tabular explain output from within the same interface.
  • Performance Dashboard. A graphical representation of some key statistics from the server status, gives you a bird's eye view of the status of key server subsystems.
  • For advanced users, Performance Schema Instrumentation. A GUI for configuring the Performance Schema in detail, for advanced users.
  • Performance Schema based reporting. Gives insight into the operation of the server through many high-level reports.
  • New query result view. Get more information about queries you execute, such as information about the fields in your result set and key performance statistics from your query (timing, index usage, number of rows scanned, joins etc).
  • Form Editor for resultsets. In addition to the result grid, you can now edit records row by row in a form style editor.
  • Table Inspector. Similar to the Schema Inspector, view detailed information from tables. A streamlined interface for creating indexes is also included.
  • Support for the Windows accessibility API and Windows high contrast color schemes. A new high contrast theme has been introduced.
  • And more.


More than 60 enhancement requests and bugs reported by users have also been addressed, providing performance, usability and stability improvements across the board.

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-1.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.1.6 GA now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 19, Fedora 20, Ubuntu 12.04 and Ubuntu 13.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products.

Quick links:

- http://mysqlworkbench.org/
- Download:http://dev.mysql.com/downloads/tools/workbench/
- Bugs:http://bugs.mysql.com
- Forums:http://forums.mysql.com/index.php?151

Enjoy!

Monday Mar 31, 2014

MySQL Workbench 6.1.4 GA has been released

The MySQL developer tools team announces 6.1.4 as our GA release for MySQL Workbench 6.1.

MySQL Workbench 6.1 is an upcoming major update for the official MySQL graphical development tool.
Introducing 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 in 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 on Performance Schema, Information Schema, and other areas. Special thanks to the server optimizer team, server runtime team, and Mark Leith.  For Oracle DBAs MySQL SYS is similar to the V$ catalog views, and MSSQL folks its like DMVs (Dynamic Management Views).

MySQL Workbench 6.1 includes:
  • Improved drag and drop support in the Home screen and SQL Editor
  • Visual Explain 2. The Visual Explain feature was revamped and is now easier to read and interpret. You can also get the traditional tabular explain output from within the same interface.
  • Performance Dashboard. A graphical representation of some key statistics from the server status, gives you a bird's eye view of the status of key server subsystems.
  • For advanced users, Performance Schema Instrumentation. A GUI for configuring the Performance Schema in detail, for advanced users.
  • Performance Schema based reporting. Gives insight into the operation of the server through many high-level reports.
  • New query result view. Get more information about queries you execute, such as information about the fields in your result set and key performance statistics from your query (timing, index usage, number of rows scanned, joins etc).
  • Form Editor for resultsets. In addition to the result grid, you can now edit records row by row in a form style editor.
  • Table Inspector. Similar to the Schema Inspector, view detailed information from tables. A streamlined interface for creating indexes is also included.
  • Support for the Windows accessibility API and Windows high contrast color schemes. A new high contrast theme has been introduced.
  • And more.

More than 60 enhancement requests and bugs reported by users have also been addressed, providing performance, usability and stability improvements across the board.

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-1.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.1.4 GA now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 19, Fedora 20, Ubuntu 12.04 and Ubuntu 13.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products.

Quick links:
- http://mysqlworkbench.org/
- Download: http://dev.mysql.com/downloads/tools/workbench/
- Bugs: http://bugs.mysql.com
- Forums: http://forums.mysql.com/index.php?151

Monday Mar 24, 2014

MySQL Workbench 6.1.3 RC has been released

The MySQL developer tools team announces 6.1.3 RC - the final release candidate for MySQL Workbench 6.1.

MySQL Workbench 6.1 is the upcoming major update for the official MySQL graphical development tool.
Introducing over 30 new features, this version has many significant enhancement focusing on real-time performance assessment and analysis from the SQL statement level to server internals and file IO. You'll see this in additions to the SQL Editor as well as new dashboard visualization and reporting that takes 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 on Performance Schema, Information Schema, and other areas. Special thanks to the server optimizer team, server runtime team, and Mark Leith.  For Oracle DBAs MySQL SYS is similar to the V$ catalog views and MSSQL folks its like DMVs (Dynamic Management Views).

MySQL Workbench 6.1 includes:
  • Improved drag and drop support in the Home screen and SQL Editor
  • Visual Explain 2. The Visual Explain feature was revamped and is now easier to read and interpret. You can also get the traditional tabular explain output from within the same interface.
  • Performance Dashboard. A graphical representation of some key statistics from the server status, gives you a bird's eye view of the status of key server subsystems.
  • For advanced users, Performance Schema Instrumentation. A GUI for configuring the Performance Schema in detail, for advanced users.
  • Performance Schema based reporting. Gives insight into the operation of the server through many high-level reports.
  • New query result view. Get more information about queries you execute, such as information about the fields in your result set and key performance statistics from your query (timing, index usage, number of rows scanned, joins etc).
  • Form Editor for resultsets. In addition to the result grid, you can now edit records row by row in a form style editor.
  • Table Inspector. Similar to the Schema Inspector, view detailed information from tables. A streamlined interface for creating indexes is also included.
  • Support for the Windows accessibility API and Windows high contrast color schemes. A new high contrast theme has been introduced.
  • And more.

More than 60 enhancement requests and bugs reported by users have also been addressed, providing performance, usability and stability improvements across the board.

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-1.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.1.3 RC now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 19, Fedora 20, Ubuntu 12.04 and Ubuntu 13.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products.

Quick links:
- http://mysqlworkbench.org/
- Download: http://dev.mysql.com/downloads/tools/workbench/
- Bugs: http://bugs.mysql.com
- Forums: http://forums.mysql.com/index.php?151

Tuesday Mar 04, 2014

MySQL Workbench 6.1.2 BETA has been released

The MySQL developer tools team is pleased to announce 6.1 Beta 2 - the start of the public beta testing phase of MySQL Workbench 6.1

MySQL Workbench 6.1 is the upcoming major update for the official MySQL graphical development tool.
Introducing over 30 new features, this version has many significant enhancement focusing on real-time performance assessment and analysis from the SQL statement level to server internals and file IO. You'll see this in additions to the SQL Editor as well as new dashboard visualization and reporting that takes advantage of MySQL Server 5.6 and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans.

Additionally Workbench 6.1 this leveraging work from various teammates in MySQL Engineering in introducing a schema called "SYS" that provides simplified views on Performance Schema, Information Schema, and other areas.
Special thanks to the server optimizer team, server runtime team, and Mark Leith. For Oracle DBAs MySQL SYS is similar to the V$ catalog views and MSSQL folks its like DMVs (Dynamic Management Views).

MySQL Workbench 6.1 includes:

  • Improved drag and drop support in the Home screen and SQL Editor
  • Visual Explain 2. The Visual Explain feature was revamped is now easier to read and interpret. You can also get the traditional tabular explain output from within the same interface.
  • Performance Dashboard. A graphical representation of some key statistics from the server status, gives you a bird's eye view of the status of key server subsystems.
  • For advanced users, Performance Schema Instrumentation. A GUI for making configuring the Performance Schema in detail, for advanced users.
  • Performance Schema based reporting. Gives insight into the operation of the server through many high-level reports.
  • New query result view. Get more information about queries you execute, such as information about the fields in your result set and key performance statistics from your query (timing, index usage, number of rows scanned, joins etc).
  • Form Editor for result sets. In addition to the result grid, you can now edit records row by row in a form style editor.
  • Table Inspector. Similar to the Schema Inspector, view detailed information from tables. A streamlined interface for creating indexes is also included.
  • Support for the Windows accessibility API and a new High contrast color theme in Windows.
  • And more.

More than 60 enhancement requests and bugs reported by users have also been addressed, providing performance, usability and stability improvements across the board.

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-1.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151

Download MySQL Workbench 6.1 beta now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 19, Fedora 20, Ubuntu 12.04 and Ubuntu 13.10 or sources, from:

http://dev.mysql.com/downloads/tools/workbench/

In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products.

Quick links:
- Download: http://dev.mysql.com/downloads/tools/workbench/
- Bugs: http://bugs.mysql.com
- Forums: http://forums.mysql.com/index.php?151

Wednesday Feb 05, 2014

MySQL Workbench 6.0.9 GA has been released

The MySQL developer tools team at Oracle is excited to announce the availability of MySQL Workbench 6.0.9.

MySQL Workbench 6.0 is the GUI Development and Administration tool for MySQL.

Changes in MySQL Workbench 6.0.9 (2014-02-05)

This section documents all changes and bug fixes applied to MySQL Workbench since the release of 6.0.8.

Functionality Added or Changed

  •  The restore operation can restore to a different schema.

Bugs Fixed

  •  MySQL Workbench now builds on Debian 7.0-unstable.
  •  Ubuntu 13.10 is now supported.
  •  Fedora 20 is now supported
  •  On Linux, the Cancel button was written as "Cance" on some systems, depending on the GTK theme used on the system.
  •  Sometimes, when exporting an EER diagram to SQL, the generated SQL code did not include "DROP SCHEMA" statements even with  the Generate DROP SCHEMA option checked.
  •  One tab could execute the query from a different tab, after swapping tabs.
  •  On Linux, building MySQL Workbench from source would generate many glib related warnings with newer versions of glib.
  •  After creating a new view inside a model, clicking Add View would display a new view in the editor this new could not be saved.
  •  The --routines command line option was missing from the generated mysqldump command when multiple schemas were selected for a dump into a single file backup when the routines option was enabled. This could happen after executing the dump multiple times.
  •  Executing Model, Forward Engineering with the Do not create users, only export privileges option enabled would recreate the user instead of simply changing privileges for the existing user.
  •  On Linux, renaming foreign keys and indexes would crash MySQL Workbench.
  •  On Mac OS X, switching colors with layers and tables several times could eventually cause a crash.
  •  Adding a new table to an empty EER diagram would crash MySQL Workbench.
  •  When building from source and without building the documentation, the documentation link will open the online MySQL Workbench manual.
  •  The Inserts tab under Forward Engineering would sometimes unexpectedly fail.
  •  The ENUM type now corresponds better to its definition better under Model, User Defined Types, to allow arguments.
  •  On Microsoft Windows and Mac OS X, the bundled PyCrypto library was upgraded to version 2.6.1.
  •  MySQL Workbench could crash when using a MySQL connection that connects via an SSH tunnel with success, but is defined using incorrect MySQL server credentials. A dialog now requests the correct information.
  •  The catalog treeview for an EER diagram was replaced by a central control with improved handling, which allows MySQL Workbench  to worth more smoothly with a large number of tables.
  •  Indexes that were auto-created for a Foreign Key can now be deleted in case another suitable index was available.
  •  Under certain scenarios, the File, Print to File... action would not allow models to be unchecked.
  •  Model synchronization would complete, but if repeated then MySQL Workbench would ask to update the database again.
  •  Changing the collation type would not always be detected, as "No changes detected" would be reported after attempting to apply the change.
  •  The MySQL Forums link on the MySQL Workbench home page was updated, and it now links to a MySQL Workbench page that also  links to the MySQL Workbench - Database Migration forum, when before it was difficult to find.
  •  From Database, Reverse Engineer, and after selecting a schema with multiple tables, clicking the left or right arrow buttons with the Show Filter feature to include/exclude tables would lose the cursor position, and always move the cursor to the top of the list.
  •  For models, tables can now be renamed by double-clicking the name column, and the columns edited.
  •  A large SQL script file could not be saved for a model, although a limit of around 200MB limit still exists.
  •  MySQL Workbench could crash after choosing Recover when prompted to recover a model file from a previous session after MySQL Workbench was not closed properly.
  •  Applying an large SQL Script object to a model could crash MySQL Workbench.
  •  The "Scratch" SQL editor tabs were removed, and instead standard SQL editor tabs are always opened.
  •  Editing a mandatory relationship now updates the referenced column.
  •  The Copy and Paste keyboard shortcut did not always function from within table cells in all environments.
  •  The Schema Privileges tab was hidden in the Schema editor, and is now more viewable.

and much more. For a detailed overview of what's new in MySQL Workbench 6.0, please visit:
http://dev.mysql.com/doc/workbench/en/wb-what-is-new.html

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-0.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152

Download MySQL Workbench 6.0 now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 19, Fedora 20, Ubuntu 12.04 and Ubuntu 13.10 or sources, from:
http://dev.mysql.com/downloads/tools/workbench/

In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products. For RPM  package based Linux distributions, you can get and update Workbench using the new MySQL RPM repository at:

http://dev.mysql.com/downloads/repo/

Quick links:
- Download: http://dev.mysql.com/downloads/tools/workbench/
- Bugs: http://bugs.mysql.com
- Forums: http://forums.mysql.com/index.php?152

Read more about MySQL Workbench 6.0 and some of its features in

MySQL Workbench 6.0: What’s New:

http://mysqlworkbench.org/2013/06/mysql-workbench-6-0-whats-new/

About

The latest news, tutorials and articles about MySQL Workbench, the GUI SQL development, administration and EER modeling tool for MySQL.

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today