PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
This method is efficient and only takes a significant amount of time if the replica is behind the source by a large number of binary log files. The elapsed time until the replica receives the first missing transaction depends on its offset in the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
If binary logging is enabled (log_bin is ON), from MySQL 8.0.17 for the InnoDB storage engine only, the server updates the mysql.gtid_executed table in the same way as when binary logging or replica update logging is disabled, storing the GTID for ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-verify-transactions.html
Or wait for a day, or whatever time period you consider safe for your deployment. This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
If there is an error in evaluation on the replica, particularly when executing complex statements, statement-based replication may slowly increase the margin of error across the affected rows over time. This also means that making and restoring a ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...
https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html
For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during execution. If the server does not detect this change the next ...Caching enables the server to perform more efficiently because it avoids the overhead of reconverting the statement should it be needed again during the ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
Orphan Stored Objects An orphan stored object is one for which its DEFINER attribute names a nonexistent account: An orphan stored object can be created by specifying a nonexistent DEFINER account at object-creation time. For an event, an error ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
Because MySQL does not check if a function really is deterministic at creation time, the invocation of a stored function with the DETERMINISTIC keyword might carry out an action that is unsafe for statement-based logging, or invoke a function or ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
Permissible locale values are the same as the legal values for the lc_time_names system variable (see Section 12.16, “MySQL Server Locale Support”). REPEAT(str,count) Returns a string consisting of the string str repeated count times. For ...