{"id":2196,"date":"2011-02-27T10:49:23","date_gmt":"2011-02-27T09:49:23","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/mysql-workbench-52\/"},"modified":"2011-02-27T10:49:23","modified_gmt":"2011-02-27T09:49:23","slug":"mysql-workbench-52","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/mysql-workbench-52\/","title":{"rendered":"MySQL Workbench 5.2: changing the life of MySQL developers and DBAs"},"content":{"rendered":"

MySQL Workbench provides several necessary tools in order to manage a MySQL environment. MySQL Workbench 5.2 is available for Windows, Mac, and Linux platforms. It encapsulates three main functionalities: SQL Development, Data Modeling, and Server Administration.<\/p>\n

1.\u00a0\u00a0\u00a0 SQL Development<\/strong>: Allows connecting to existing databases and run SQL Queries, SQL scripts, edit data and manage database objects. This functionality replaces the ones previously provided by the Query Browser stand-alone application.<\/p>\n

2.\u00a0\u00a0\u00a0 Data Modeling<\/strong>: Helps to create and manage models, allows forward & reverse engineering and provides capability to compare and synchronize schemas<\/p>\n

3.\u00a0\u00a0\u00a0 Server Administration<\/strong>: Helps to configure a database server, to setup user accounts and browse status variables and server logs<\/p>\n

\"\"<\/p>\n

Let\u2019s have a look deeper in each of those features:<\/p>\n

SQL Development provides the capacity to execute SQL queries on the database connections using the built-in SQL Editor. This powerful SQL Editor also allows getting a global overview of all schemas and objects trough the object browser. Creating tables, views, routines and even new schema has never been so easy. The output provides information about the execution such as execution time, errors, number of returned rows. A section called \u201cSnippets\u201d provides a list of very useful statements classified by utility (User snippets, DB Management, DDL Statements, DML Statements). For instance, one can find in DB Management the \u201cSHOW FULL PROCESSLIST\u201d or \u201cSHOW PRIVILEGES\u201d syntax. This list of useful statements can be fully customized by users.<\/p>\n

\"MySQL<\/p>\n

Data Modeling, what thinking about a modeling tool that provides:<\/p>\n

1.\u00a0\u00a0\u00a0 The ability to design physical models in few clicks
\n2.\u00a0\u00a0\u00a0 The possibility to create a model from an existing database or from a SQL Script
\n3.\u00a0\u00a0\u00a0 An history that allows to move back and forward in a list of changes through simple clicks
\n4.\u00a0\u00a0\u00a0 Functionalities to create triggers, inserting rows into tables, enabling partitioning
\n5.\u00a0\u00a0\u00a0 The ability to manage schema privileges
\n6.\u00a0\u00a0\u00a0 All these functionalities through a nice and foremost efficient graphical interface<\/p>\n

\"MySQL<\/p>\n

According to me this tool is very useful. One of his main strength is that it allows forward and reverse engineering. However it would be even better if there was a possibility to generate SQL scripts for other databases than MySQL.<\/p>\n

Server Administration: Since version 5.2.6 MySQL Workbench has included functionality for managing server instances. Through the server status screen it is possible to monitor MySQL Server health. This screen shows the system load, the query cache hit ratio, the number of connection, etc.. There are several other views such as:<\/p>\n