Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-repository-options.html
When the --with-timestamp option is also specified, an additional level of subdirectory, with the timestamp in its name, is created under --backup-dir (see description for the --with-timestamp option for details). When restoring a single-file backup ... These options specify various parameters related to the backup image or directory, or to how the backup will be ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} ...ndb-blob-read-batch-bytes: Specifies size in bytes that large BLOB reads should be batched ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
InitialLogFileGroup: Describes log file group that is created during initial start. MaxNoOfOpenFiles: Maximum number of files open per data node.(One thread is created per file). PartitionsPerNode: Determines the number of table partitions created ... ApiFailureHandlingTimeout: Maximum time for API node failure handling before ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-import-cluster.html
import cluster [--dryrun|-y] [--remove-angel] cluster_name This command imports a MySQL NDB Cluster created independently of MySQL Cluster Manager into a cluster named cluster_name that has been created in MySQL Cluster Manager. You are strongly ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
For all of the other database samples, such as world or employee data, you must create the MySQL Workbench (.mwb) file first before you can view the database objects in a model or add an EER diagram for it. To create a MySQL Workbench model file for ... MySQL Workbench represents each active data model as an icon in the models view of the home screen ...
https://dev.mysql.com/doc/workbench/en/wb-eer-diagram-editor.html
Enhanced Entity-Relationship (EER) diagrams are created by double-clicking Add Diagram in the Model Editor. You may create any number of EER diagrams just as you may create any number of physical schemas (databases). Note This tool is for creating ...Clicking an EER diagram tab navigates to the canvas used for graphically manipulating database ...
https://dev.mysql.com/doc/workbench/en/wb-home.html
For more information, see Chapter 5, Connections in MySQL Workbench and Section 5.2, “Creating A New MySQL Connection (Tutorial)”. Create a group by either right-clicking a connection and choosing the Move to group context menu option, or you ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-ssl-wizard.html
This wizard helps create SSL certificates for both MySQL clients and MySQL servers. In this simple example, MySQL Workbench is installed on the same host as the MySQL Server, and we created "C:\certs" on the system. Copy and paste the results to a ...Connections in MySQL Workbench are updated with the certificates by the ...
https://dev.mysql.com/doc/internals/en/optimizer-and-relations.html
Otherwise, since (both conditions are indexed and have equal join type) pick a driver based on the first index that was created. Here's an example: CREATE TABLE Table1 (s1 INT, s2 INT); CREATE INDEX Index1 ON Table1 (s2); CREATE INDEX Index2 ON ...
https://dev.mysql.com/doc/internals/en/variation-of-storage-engine.html
That means mostly: DO NOT use hardcoded storage engine assignments within CREATE TABLE statements. If you assume that there is no significant impact of storage engines on your testing object, create/run with storage engine variants and check this.