MySQL Workbench 6.2: Spatial Data

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.

spatial_viewer

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 Spatial View, you’ll notice several layers for each resultset. You can also zoom in/out, and jump to specific location.

 

The Geometry Viewer

Both the Field and Form Editors were updated to support the GEOMETRY datatype. You can view geometry data like polygons from a single row as an image or as text, in any of the common WKT, GeoJSON, GML or KML formats. form_editor

MySQL Workbench 6.2.3 GA has been released

Dear MySQL users,

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/

MySQL Workbench 6.2.2 RC has been released

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.
  • 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/

MySQL Workbench 6.2.1 BETA has been released

Dear MySQL Users,

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(32 and 64 bits)
* 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.
Vishal Chaudhary

MySQL Workbench 6.1.7 GA has been released

Dear MySQL users,

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

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

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

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

MySQL Workbench 6.1.1 BETA has been released

The MySQL developer tools team is pleased to announce 6.1 Beta 1 – 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