PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. However this caused issues when logging or replicating, in STATEMENT ...TRUNCATE TABLE is treated for purposes of logging and replication as DDL rather than DML so that it can be logged and replicated as a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
If you use this method, the replica must be configured for GTID-based replication, in other words with gtid_mode=ON. There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
From MySQL 8.0, the system variables are also not modified when Group Replication is in single-primary mode, where only one server writes. If it is left with its default value, and Group Replication is started on the server in multi-primary mode, it ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-checking.html
SELinux is enabled by default on some Linux distributions including Oracle Linux, RHEL, CentOS, and Fedora.
https://dev.mysql.com/doc/refman/8.0/en/set.html
Duplicate values in the definition cause a warning, or an error if strict SQL mode is enabled. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
If this option is used with the multi-threaded applier, a warning is raised, and the replica switches to single-threaded mode. START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
For example, in a replication setup, perhaps your source server uses InnoDB tables for maximum safety, but the replica servers use other storage engines for speed at the expense of durability or concurrency. To prevent confusing, unintended behavior ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
The following lines are equivalent: 'a string' 'a' ' ' 'string' If the ANSI_QUOTES SQL mode is enabled, string literals can be quoted only within single quotation marks because a string quoted within double quotation marks is interpreted as an ... A ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-lock-waits.html
blocking_lock_mode The mode of the lock that is blocking the waiting lock. These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at ...