PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-options-variables.html
The delay is intended to provide enough time for the file system on the recipient host to free space before data is cloned from the donor MySQL Server instance. On these file systems, cloning data too soon after dropping existing data can result in ...In this case, the server may also produce error messages for other clone settings because it does not recognize ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html
(You must be using MySQL NDB Cluster with the NDB storage engine to create NDB tables.) InnoDB storage engine. CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
Its state at the time of failure is described by an arbitration state code state_code: possible state code values can be found in the file include/kernel/signaldata/ArbitSignalData.hpp. In the event of arbitration failure, an error_message and an ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
REORGANIZE PARTITION: ALTER TABLE table_name REORGANIZE PARTITION partition_name INTO (partition_definition TABLESPACE=innodb_file_per_table); There must be no queries and stored program definitions from MySQL 8.0.12 or lower that use ASC or DESC ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
Table information must be read from the data dictionary and by reading table files. Using filesort (JSON property: using_filesort) MySQL must do an extra pass to find out how to retrieve the rows in sorted order. That is, the named index covers the ... The EXPLAIN statement provides information about how MySQL executes ...Note MySQL Workbench has a Visual ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Scenario 3: You want specific transactions to read only up-to-date data from the group, so that whenever sensitive data such as credentials for a file is updated, reads always use the most recent value. This guarantees consistency, but means that ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
If the file cannot be found, the following error results: ERROR 2 (HY000): File '/person.xml' not found (Errcode: 2) The ROWS IDENTIFIED BY '<person>' clause means that each <person> element in the XML file is considered equivalent to a row in the ...To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...This is true regardless of whether the replica is a single server or a ...ndb_replication is also used in NDB Replication conflict detection and ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-overview.html
In practice, the advanced InnoDB performance features mean that InnoDB tables often outperform the simpler MyISAM tables, especially for a busy database. The InnoDB storage engine handles most locking issues without involvement from you, allowing ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
From MySQL 8.0.27, when GTID-based replication is in use (gtid_mode=ON), set GTID_ONLY=1, which makes the replica use only GTIDs in the recovery process, and stop persisting binary log and relay log file names and file positions in the replication ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...