Search Results
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-custom.html
Assuming that MySQL Workbench has been installed into the default location on Windows, this is C:\Program Files\MySQL\MySQL Workbench 8.0 SE\modules\data\wb_model_reporting. MySQL's UUID() function also generates GUIDs: mysql> SELECT UUID(); ... In ...
https://dev.mysql.com/doc/workbench/en/wb-admin-server-management.html
Manage your MySQL instances with a comprehensive view of your MySQL server connections. MySQL Connection Navigator The Navigator area of the sidebar panel has an Administration secondary tab (previously named Management) with functionality to ...
https://dev.mysql.com/doc/workbench/en/wb-configuration-additional.html
This affects the generated syntax and database structure in relation to how MySQL changed over time. Commonly used configuration options and preferences include: Rescan for Local MySQL Instances: Right-click on the home screen, and this option will ...For example, DELETE FROM foo is considered unsafe, whereas DELETE FROM foo WHERE id = 1 is safe and will always ...
https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
Note Be aware that backward incompatible MySQL syntax changes are introduced over time, so for this reason it is important to set the Default Target MySQL Version modeling preference according to your needs. For example, exporting results from a ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
Option file: [mysqld] innodb_file_per_table=ON Using SET GLOBAL at runtime: mysql> SET GLOBAL innodb_file_per_table=ON; File-Per-Table Tablespace Data Files A file-per-table tablespace is created in an .ibd data file in a schema directory under the ...An innodb_file_per_table setting can be specified in an option file or configured at runtime using a SET GLOBAL ... A file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
FOR SHARE statements do not acquire read locks on MySQL grant tables. Here, FOR SHARE is not a good solution because if two users read the counter at the same time, at least one of them ends up in deadlock when it attempts to update the counter. In ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough ...
https://dev.mysql.com/doc/refman/8.4/en/no-login-pluggable-authentication.html
The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...Use ...
https://dev.mysql.com/doc/refman/8.4/en/xa.html
The MySQL XA implementation is based on the X/Open CAE document Distributed Transaction Processing: The XA Specification. The XA interface to a MySQL server consists of SQL statements that begin with the XA keyword. MySQL client programs must be ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/crd-ndbclusterspec.html
Important Once an NDB Cluster has been created, it is possible but quite difficult and time-consuming to change this value. managementNode (NdbManagementNodeSpec): (optional) Specifies the configuration of the management node running in MySQL ...