Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/en/set-operations.html
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 Operations using DISTINCT and ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/xml-functions.html
For both ExtractValue() and UpdateXML(), the XPath locator used must be valid and the XML to be searched must consist of elements which are properly nested and closed. Table 14.16 XML Functions Name Description ExtractValue() Extract a value from ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
There could be inconsistencies in both InnoDB and non-InnoDB data if any changes are made while those files are being backed up. When both the optimistic-time and the optimistic-busy-tables options are used and they come into conflict on determining ... These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource ...