Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
(Row-based replication, however, simply replicates the value returned by the function or stored program, so its effect on table rows and data is the same on both the source and replica.) See Section 19.5.1.16, “Replication of Invoked Features”, ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
You cannot have both the new and the old versions of the relevant plugin installed on an instance. The plugins must be enabled both on the source side and the replica side to enable semisynchronous replication. Semisynchronous replication is ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
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 persisted system variable causes the variable no longer to be ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. The RESIGNAL statement takes condition_value and SET clauses, both of which are optional. RESIGNAL may change some or all information before passing it on. RESIGNAL ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
Server-Side Runtime Configuration and Monitoring for SSL Session Reuse Client-Side Configuration for SSL Session Reuse Each full TLS exchange can be costly both in terms of computation and network overhead, less costly if TLSv1.3 is used. SSL ...
https://dev.mysql.com/doc/refman/8.4/en/role-names.html
It is possible for a row in the mysql.user system table to serve as both an account and a role. Specifying a role with a non-'%' host part can be useful if you intend to create a name that works both as a role an as a user account that is permitted ... MySQL role names refer to roles, which are named collections of ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
When run concurrently with STOP REPLICA, SHOW REPLICA STATUS returns without waiting for STOP REPLICA to finish shutting down the replication SQL (applier) thread or replication I/O (receiver) thread (or both). SQL_AFTER_GTIDS if the replication ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
Sorted Index Builds and Compressed Tables For compressed tables, the previous index creation method appended entries to both compressed and uncompressed pages. InnoDB performs a bulk load instead of inserting one index record at a time when ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-convenience-functions.html
If both geometry parameters are valid Cartesian Point or MultiPoint values in SRID 0, the return value is shortest distance between the two geometries on a sphere with the provided radius. If both geometry parameters are valid Point or MultiPoint ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
For example, the optimizer might be able to use materialization if both expressions are integer or both are decimal, but cannot if one expression is integer and the other is decimal. The optimizer uses materialization to enable more efficient ...