MySQL Workbench & Performance_Schema

Last week during the Oracle Users Group Leaders Summit in Bucharest I had the pleasure the meet the leaders for the MySQL Users Group from Azerbaijan,  Finland, Madrid and the Netherlands.

During some discussions, it appeared that some users are not aware of the Performance_Schema integration in MySQL Workbench. Indeed with WB you can enable PFS, add sys table if not present by default (<5.7).

Selection_196

You can use a default configuration or customize it and enable all the instruments and consumers you need.

Selection_197

When enabled, you can generate some useful reports

Menu_195

Selection_191Selection_192

 

Selection_194

 

Selection_192

In case you are also not yet aware of it, the following dashboard is also available in MySQL Workbench

Selection_190

The latest version of MySQL Workbench has been released yesterday, June 13th : 6.3.7 GA

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.