Search Results
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. On Windows, you can create a ... On ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-cloud.html
Only single-file backups can be created on and restored from a cloud storage. GCP object storage A cloud backup is created using the cloud options for mysqlbackup, which are described in details in Section 20.15, “Cloud Storage Options”. Here ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/setting-up-innodb-cluster-and-mysql-router.html
AdminAPI has built-in functionality for creating sandbox instances that are pre-configured to work with InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet in a locally deployed scenario. This example contains the following sections: ... In the ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or reset the sequence value for an existing table, respectively. When you create an ARCHIVE table, the ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
The default setting (which is the maximum permitted sequence number for a transaction in a GTID) means that state transfer from a donor's binary log is virtually always attempted rather than cloning. Group members that are still online can ... This ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 8.4, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-cluster-log.html
Keep GCI = current_gci oldest restorable GCI = old_gci The local checkpoint having sequence ID lcp has been started on node node_id. LocalCheckpointStarted Checkpoint 7 INFO Node node_id: Local checkpoint lcp completed The local checkpoint having ...
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
Important Columns created using this class cannot be seen by the MySQL Server. As with other database objects, Column object creation and attribute changes to existing columns done using the NDB API are not visible from MySQL. Column Constructor ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
Create a mysql User and Group If your system does not already have a user and group to use for running mysqld, you may need to create them. $> groupadd mysql $> useradd -r -g mysql -s /bin/false mysql Note Because the user is required only for ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. Suppose that a table t is defined as follows: CREATE TABLE t (i INT NOT NULL); In this case, i has no ... Data type specifications can have explicit or implicit default ...