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 …

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

Monitoring MySQL and MariaDB databases without a powerful tool like MONyog can be challenging. However, if you already use MONyog you might not be using it to it’s full potential. In this webinar, we will introduce you to the entire feature set of MONyog followed by a Q&A session.

You’ll also be delighted to know that one lucky winner gets MONyog Ultimate worth $399 for free. So, make sure you book your spot.

Date: Tuesday, July 8, 2014
Time: 10:00 am PT
Presenter: Rohit Nadhani (CEO, Webyog)
Register your spot for free

Update: Congratulations to Vandana Sharma on …

Ever had this nightmare of your system crashing, or you accidentally closing SQLyog and losing all your open tabs and queries? Don’t worry, we have you covered!

Introducing Session Restore. You can now restore your previous session along with all queries and history tab the way you left it. Here’s a quick video:

Session Restore is available for all SQLyog users. Existing customers can download the latest build from Customer Portal. To evaluate SQLyog, please download a 30-day trial.

We are very excited about this release, and hope that you will like it. We would love to hear your feedback.

Cheers,
Team SQLyog

Tweet

The post …

As we’ve hinted at for some time now, we have been busy preparing some good stuff for our Debian and Ubuntu users. And today we’re delighted to launch our own official MySQL apt repos for Debian and Ubuntu. After working closely with the Debian and Ubuntu communities to make sure that the native MySQL packages […]

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 …

I'm very proud to announce PostgreSQL support as a big new feature!

Read and take part in the discussions:
* http://www.heidisql.com/forum.php?t=7025
* issue #3190

Or download the installer (which includes required DLL's).

We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the ‘Heartbleed’ OpenSSL bug have been upgraded to non-affected versions (the new MONyog release will have a few more fixes as well).

Since this security issue became known a few days ago, media and Internet have swollen with information about vulnerable systems. There is probably both a lot of facts and fiction circulating.

A good summary appeared in the Percona blog. It mostly focuses on server-side vulnerabilities. However this blog indicates that the vulnerability may also be exploitable from clients linking a vulnerable OpenSSL version. SQLyog and MONyog users …

The recently released MySQL Workbench 6.1 continues expanding the capabilities of the tool. This version focuses on performance analysis features for MySQL server workload and queries, taking advantage of performance_schema improvements introduced in MySQL 5.6 and 5.7 DMR.

This is a overview of the new features we’ve added. Some of them are covered in more detail in separate posts.

New Navigator PERFORMANCE Section

The new PERFORMANCE section includes Dashboard, Performance Reports, andPerformance Schema Setup pages. Generally, this new performance reporting feature provides a graphical representation of key statistics from the MySQL server status, and provides an overview of the MySQL server subsystems.

Dashboard

View server performance statistics in a graphical dashboard.

…