PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE.
https://dev.mysql.com/doc/refman/8.0/en/replication-bugs.html
For example, if you update the replica outside of the replication threads, the data goes out of synchrony, and you can have unique key violations on updates. Ensure that the replica is running with binary logging enabled (the log_bin system ... When ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
In addition, for a non-transactional update, if a disk write failure occurs while attempting to write to the binary log cache and a gap is therefore created in the binary log, the resulting incident log event is assigned a GTID. It also means the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-implementation.html
Replication is based on the source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. Tables are created or their structure modified, and data is inserted, deleted, and updated according to the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
In those cases, the database being created, altered, or dropped replaces the default database when determining whether to log or ignore updates. When using row-based logging with the same option, the server logs only those updates that change data ... When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-rbr-monitoring.html
For example to get progress for update events issue: mysql> SELECT WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current -> WHERE EVENT_NAME LIKE 'stage/sql/Applying batch of row changes (update)' If ... The current progress ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
This account must have the EXECUTE privilege for p1 as well as the UPDATE privilege for the table t1 referenced within the object body. p2 fails if the invoker lacks the EXECUTE privilege for p2 or the UPDATE privilege for the table t1. Stored ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
Only statements that modify databases or tables count against the update limit. The max_questions, max_updates, and max_connections columns store the per-hour limits, and the max_user_connections column stores the MAX_USER_CONNECTIONS limit. One ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
This mode causes compiler warnings to become errors, so disabling it may enable compilation to proceed. For information about acquiring or updating tools, see the system requirements in Section 2.8, “Installing MySQL from Source”. If you do ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
To require an encrypted connection, a client need specify only the --ssl-mode=REQUIRED option; the connection attempt fails if a secure connection cannot be established. CREATE USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...