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 …
The MySQL Utilities Team is pleased to announce the latest
release candidate (RC) release of MySQL Utilities. This release
includes a number of improvements for useabilty, stability, and a
few enhancements. A complete list of all improvements can be
found in our release_notes.
New Utilities!
We have also included two new utilities.
- The mysqlrplsync utility was added, which checks data consistency between servers in a replicated setup.
- The mysqlrplms utility was added, which provides round-robin multi-source replication (a slave server continually cycles through multiple masters in order to store a consolidated data set).
How Can I Download MySQL Utilities?
You can download MySQL Utilities 1.4.2 from the following link
using one of the pre-built …
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 …
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 …
MySQL’s Performance schema is a relatively new tool for measuring performance and MySQL Workbecn 6.1.2 is the latest beta of that software. I have not had a lot of time to play with performance schema but now I am taking my first steps with the help of Workbench. Startup Workbench and you will find under the Navigator an item labeled Performance Schema Setup. Flip the toggle from OFF to ON and then start exploring.
InnoDB Buffer stats by Schema are show here — one of more than twenty pre-established metrics available.
Now you can run queries and see what the costs are, where the server is waiting, or what indexes remain unused. You can even use workbench to alter the options file to setup other Performance Schema instruments. Trying various settings for optimizer_search_depth is simple with the …
[Read more]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, …
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 …
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, …
Another obscure issue I ran into not long ago was when using MySQL Workbench, and clicking on a table, it became stuck in fetching mode.
What triggered the issue was a recent MySQL upgrade, but MySQL itself, not Workbench.
After checking the error log, we saw an error like:
Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64)
Instantly, I knew mysql_upgrade needed to be ran in order to fix the “Incorrect definition” issue, and turns out that is the root cause for Workbench getting stuck in the “fetching” mode.
So the solution is to run mysql_upgrade. Should that not fix the table for some reason, then you can also fix it alternatively with:
ALTER TABLE mysql.proc MODIFY `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; FLUSH TABLES;
Hope this helps.
The MySQL Utilities Team is pleased to announce the latest GA
release of MySQL Utilities. This release includes a number of
improvements for usability, stability, and a few enhancements. We
have also included a performance upgrade for exporting,
importing, and copying databases.
Improvements
The following highlights a few of the more significant
improvements.
* mysqldbexport, mysqldbimport, and mysqldbcopy have
multiprocessing support that allows for much improved
performance
* mysqlfrm can now generate a .frm file with storage engine
substitution
* Mac OS X packages added!
* mysqlserverinfo now includes the log files (error, general,
slow)
* mysqlprocgrep can now search and kill processes by id
* mysqlmetagrep can now search the body of routines with the new
--body option
* all utilities report license type with --version and
--help
* all utilities have the new …