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-reserved-words.html
Replication can fail in such cases with Error 1064 You have an error in your SQL syntax..., even if a database or table named using the reserved word or a table having a column named using the reserved word is excluded from replication. You can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
If no matching record is found, it returns the error ER_KEY_NOT_FOUND and stops the replication applier thread. If there are any unmatched rows remaining in the hash table, the algorithm returns the error ER_KEY_NOT_FOUND and stops the replication ... When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-synchronization.html
The function returns NULL if the replication SQL thread is not started, the replica's source information is not initialized, the arguments are incorrect, or an error occurs. The function returns NULL if the replication SQL thread is not started, the ... The functions listed in this section are used for controlling position-based synchronization of source and replica servers in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. If you cannot tell from the error log what the problem was, try the following techniques: Verify that the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
This statement displays an event as a base 64-encoded string, the meaning of which is not evident. When invoked with the --base64-output=DECODE-ROWS and --verbose options, mysqlbinlog formats the contents of the binary log to be human readable. When ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules.html
Beginning with MySQL 8.0.31, filtering rules are applied before performing any privilege checks; if a transaction is filtered out, no privilege check is performed for that transaction, and thus no error can be raised by it. If a replication source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
A multithreaded replica's coordinator thread also prints statistics to the replica's error log on a regular basis if the verbosity setting is set to display informational messages. The message lists the following statistics for the relevant ... On a ...
https://dev.mysql.com/doc/refman/8.0/en/reset-persist.html
If the variable is not present in the file, an error occurs. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a ...
https://dev.mysql.com/doc/refman/8.0/en/row-subqueries.html
An error occurs if the subquery produces multiple rows because a row subquery can return at most one row. Thus, the following query fails with a syntax error: SELECT * FROM t1 WHERE ROW(1) = (SELECT column1 FROM t2) Row constructors are legal in ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...