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

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

What’s New in MySQL Workbench 6.1

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. Figure 2.1 Performance Dashboard Performance Reports Performance schema based reports that provide insight into the operation of the MySQL server through many high-level reports. Figure 2.2 Performance Reports: ...

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

New MySQL Workbench video

The MySQL Workbench team just uploaded a new video to the MySQL channel at Youtube. This video is meant for beginners and describes the process of creating and troubleshooting connections in MySQL Workbench.

MySQL Workbench 6.1: Updating accounts using the old (pre-4.1.1) authentication protocol

In MySQL each 'user' has its own password hash. To provide better security, pasword hashes were extended from 16 to 41 bytes in MySQL 4.1. This change created a situation. If the user was created prior to version 4.1 and the server updated to a newer version, the password hash that was stored in the database is left in the old, deprecated format. This is because MySQL doesn't store passwords in plain text so there's no way to automatically regenerate a password hash. For this case, we consider two scenarios: - If the secure_auth server option is disabled, you can login and update your password. You may also need to enable the allow old_password option in the Workbench advanced options tab for ...

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

MySQL Workbench 6.1: Server Variables grouping

MySQL Workbench has an option to view MySQL server variables divided into groups [img. 1], for example: Binlog, General, Keycache, Performance, etc. This is okay if we just wanted to look around, but it can become overwhelming as sometimes we only want to monitor specific variables from different groups. [caption id="attachment_2078" align="alignnone" width="790"] img.1. Server Variables main view[/caption] In MySQL Workbench 6.1, we solve this by implementing Custom Groups. It's a special group that can be created by the user. At the end of the Category List, there is already one defined group, called Custom. When selected, you'll find a description in the Variable List [img. 2]. [caption id="attachment_2080" align="alignnone" width="790"] img. 2. Server Variables custom group[/caption]   Variable grouping is easy. You simply right-click ...

MySQL Workbench 6.1: Performance Schema Reports

The Performance Schema Reports feature from MySQL Workbench show summaries of the many statistics gathered by the MySQL performance_schema. By inspecting these reports, you can get some insight of what's happening in a MySQL server in aspects such as: I/O by amount of data I/O by latency/time spent Index usage Performance critical operations performed by queries of the same type (table scans, index scans, temporary tables, sorts etc) The MySQL SYS Schema MySQL 5.5 introduced the performance_schema feature. performance_schema contains tables that log server performance and activity statistics. You can inspect it to have a clearer understanding about what kind of work is the server doing, how much time is spent doing that, resources used globally or by individual queries etc. MySQL 5.6 expanded on it ...

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