Search Results
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-client-connections.html
Figure 5.29 Client Connections Details Locks: MySQL uses metadata locking to manage access to objects such as tables and triggers. The client connection browser lists the active and sleeping MySQL client connections, and adds the ability to kill ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html
To open the Administration - Users and Privileges tab: Establish a connection to an active MySQL server instance. For example, if you select the role BackupAdmin, the privileges granted include EVENT, LOCK TABLES, SELECT, SHOW DATABASES. The ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-general-requirements.html
Setting an encryption password is required to perform backup and restore operations on encrypted tables (see Options Tab). MySQL Workbench attempts to locate the MySQL Enterprise Backup executable based on the version MySQL server in use, so check ... MySQL Enterprise Backup (MEB) is a MySQL Enterprise feature that is separate from MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-firewall.html
You can modify the plugin controls as follows: Install: Executes queries to install the new MySQL Enterprise Firewall tables and stored procedure needed to switch the state. MySQL Workbench provides a graphical interface to MySQL Enterprise ...
https://dev.mysql.com/doc/workbench/en/wb-performance-dashboard.html
Data points include the Table Open Cache efficiency, SQL Statements Executed, and counts (per second) for SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP statements. To display the dashboard, open a query tab and then click Dashboard from ...
https://dev.mysql.com/doc/workbench/en/wb-performance-query-statistics.html
The Query Stats SQL editor results tab (see the next two figures) uses Performance Schema data to gather key statistics collected for executed query, such as timing, temporary tables, indexes, joins, and more. Figure 7.5 SQL Editor: Query Stats ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
Tables, views, routines, routine groups, indexes, keys, and constraints can be imported from an SQL script file. To reverse-engineer a database using a create script, do one of the following: On the home screen, select the model view from the ...
https://dev.mysql.com/doc/workbench/en/wb-routine-groups.html
9.1.6.2.3.2 The Privileges Tab The Privileges tab of the routine group editor functions in exactly the same way as the Privileges tab of the table editor. 9.1.6.2.1 Adding Routine Groups to the Physical Schemata Double-clicking the Add Routine ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-connection-information-panel.html
Figure 8.21 SQL Editor - Connection Information Palette The Object Info tab of the Information panel summarizes information about a specific object, such as a table. The Session tab of the Information panel summarizes the current connection to the ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html
These cells are editable if MySQL Workbench is able to determine how, as for example they are editable if a Primary or Unique key exists within the result set. If not, MySQL Workbench will display a "read-only" icon at the bottom-right corner of the ... The SQL query secondary tab opens by default when you make a connection to a server from the Home ...