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/change-replication-source-to.html
When using a multithreaded replica (replica_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 stopped intentionally or ...] ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
create_admin_listener_thread: Whether to use dedicated listening thread for connections on administrative interface. innodb_fsync_threshold: Controls how often InnoDB calls fsync when creating new file. innodb_tmpdir: Directory location for ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
Use this option if you do not want to remove existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory. The MySQL server must have the necessary write access to create the directory. When the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is configured as the storage engine for on-disk internal temporary tables. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
From MySQL 8.0, this repository is created by default as an InnoDB table named mysql.slave_relay_log_info. GTID auto-positioning means the replica can reliably identify and retrieve missing transactions, even if there are gaps in the sequence of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
20.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. If you did not have binary logging enabled when you configured the user credentials on s1, and a remote cloning operation ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.0/en/import-table.html
IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege for the table to be created. If necessary, execute this statement to create it: mysql> CREATE SCHEMA hr; At the file system level, copy the ...The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata ...