PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
When using a multithreaded replica (replica_parallel_workers > 0 or slave_parallel_workers > 0), stopping the replica can cause gaps in the sequence of transactions that have been executed from the relay log, regardless of whether the replica was ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
For non-language-specific collations, characters in contraction sequences are treated as separate characters. For example, utf8mb4_unicode_ci works fine for German dictionary order and French, so there is no need to create special utf8mb4 collations. Miscellaneous Information The xxx_general_mysql500_ci collations preserve the pre-5.1.24 ordering of the original xxx_general_ci collations and permit upgrades for tables created before MySQL 5.1.24 (Bug ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
To search the title or body separately, you would create separate FULLTEXT indexes for each column. The MySQL FULLTEXT implementation regards any sequence of true word characters (letters, digits, and underscores) as a word. That sequence may also ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/en/flush.html
If binary logging is enabled, the sequence number of the binary log file is incremented by one relative to the previous file. Frees memory cached by the server as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. If relay ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
If you are using tablespaces with InnoDB, then the specific tablespace files you create are used instead. MySQL encodes any characters that are problematic in the corresponding file system objects when it creates database directories or table files: ... There is a correspondence between database and table identifiers and names in the file ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
This client transaction is assigned a GTID composed of the source's UUID and the smallest nonzero transaction sequence number not yet used on this server. A GTID is also assigned to the creation, alteration, or deletion of a database, and of a ...