ABSTRACT

MySQL Workbench has many important features available for database developers and DBAs.Chapter 4 provides a practical example for using visual database design in MySQL Workbench. The chapter covers a reverse engineer example in MySQL Workbench. A visual query builder for MySQL and other databases (FlySpeed SQL Query) is also introduced. This chapter discusses MySQL Server Status, MySQL Server Logs, MySQL Server Performance Dashboard, MySQL Online Backup, Synchronization in MySQL Workbench. The author also provided MySQL INSERT IGNORE statement example.