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/group-replication-single-primary-mode.html
In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write mode. All the other members in the group are set to read-only mode (with super_read_only=ON). All other servers that ...The member that is designated as the primary server can change in the following ways: If the existing primary leaves the group, whether voluntarily or unexpectedly, a new primary is elected ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
If strict mode is enabled, inserts and updates involving division by zero are prohibited, and an error occurs. In other words, inserts and updates involving expressions that perform division by zero can be treated as errors, but this requires ...In ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, locking depends on whether the statement uses a unique index with a unique search condition, or a range-type search condition. It is not recommended to mix ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-mode.html
Permissive mode allows operations that are not permitted in enforcing mode and logs those operations to the SELinux audit log. In disabled mode, polices are not enforced, and contexts are not applied to system objects, which makes it difficult to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
(See Section 19.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. In such cases, a warning is still issued by this ...
https://dev.mysql.com/doc/refman/8.0/en/MySQLInstallerConsole.html
For example, to show the console's help: MySQLInstallerConsole.exe --help =================== Start Initialization =================== MySQL Installer is running in Community mode Attempting to update manifest. Possible actions are: [--]configure, ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
Start the replica, then disable read-only mode on both servers, so that they can accept updates. To enable GTID-based replication, each server must be started with GTID mode enabled by setting the gtid_mode variable to ON, and with the ...For ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
For example, Com_delete and Com_update count DELETE and UPDATE statements, respectively. Com_delete_multi and Com_update_multi are similar but apply to DELETE and UPDATE statements that use multiple-table syntax. This context value may differ from ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. This causes the replica to be out of synchrony with the source and ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
For this reason, replication of such a statement may not be safe when STATEMENT mode is in use. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes ...In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL ...