PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
Column Filtering When using row-based replication, (binlog_format=ROW), a replica where the last columns are missing from a table is supported, as described in the section Section 16.4.1.10, “Replication with Differing Table Definitions on Source ... The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
A warning is logged if you use this function when binlog_format is set to STATEMENT. ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
A warning is logged if you use this function when binlog_format is set to STATEMENT. It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html
Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using it. This section provides information about restrictions on and limitations of replication with GTIDs. When using ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
Since there is no actual SQL statement being processed by the MySQL server, all memcached commands (except for flush_all) use Row-Based Replication (RBR) logging, which is independent of any server binlog_format setting. Because the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
If you use READ COMMITTED with binlog_format=MIXED, the server automatically uses row-based logging. Transaction isolation is one of the foundations of database processing. Isolation is the I in the acronym ACID; the isolation level is the setting ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transactions.html
The binlog_format and binlog_checksum system variables are read-only as long as a transaction is in progress. In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. You ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql database are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
When binlog_format=ROW, you can prevent the replica from stopping if you set slave_exec_mode=IDEMPOTENT before you start the replica again. When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this ...