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-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactions.html
In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. You should also avoid using any statement that accesses both transactional (or temporary) and nontransactional tables ...The server uses these rules for binary logging: If the initial statements in a transaction are nontransactional, they are written to the binary log ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
Both variables have global and session values, and each can assume an integer value between 1 and 65,535 inclusive. This section describes the server options and system variables that you can use on replication source servers. You can specify the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
When viewed in terms of events, the process of checking table options is the same for both row-based and statement-based replication. Note Statement-based replication stops if a single SQL statement operates on both a table that is included by a ...
https://dev.mysql.com/doc/refman/8.0/en/resource-groups.html
The default priority is 0, for both system and user groups. MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
This enables assignment of sets of privileges to accounts and provides a convenient alternative to granting individual privileges, both for conceptualizing desired privilege assignments and implementing them. (It is permitted to assign both ...Like ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
In MySQL 8.0.19 and later, set operations work the same way when one or more TABLE statements, VALUES statements, or both, are used to generate the set. Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
If both g1 and g2 are of dimension 1: If the lines cross each other in a finite number of points (that is, no common line segments, only single points in common). ST_Touches() handles its arguments as described in the introduction to this section ...
https://dev.mysql.com/doc/refman/8.0/en/system-variable-privileges.html
SET PERSIST_ONLY can be used for both dynamic and read-only system variables, but is particularly useful for persisting read-only variables, for which SET PERSIST cannot be used. (For information about dynamic variables, see Section 7.1.9.2, ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
In both cases, the actual version applicable to the existing MySQL installation is stored in the data dictionary, and the current expected version is compiled into the new version of MySQL. If both versions indicate an upgrade is needed, the data ...