PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
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-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 ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. (The DDL log is always created when required, and has no user-configurable options; see The DDL Log.) The following log-specific sections provide information ...
https://dev.mysql.com/doc/refman/8.0/en/set-role.html
The server writes warnings to its error log for default roles that cannot be activated, but the client receives no warnings. If a user executes SET ROLE DEFAULT during a session, an error occurs if any default role cannot be activated (for example, ... SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
If the key file contains a valid public key value but the value is incorrect, an access-denied error occurs. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements ...