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/lock-tables.html
Locks may be used to emulate transactions or to get more speed when updating tables. For cascading updates, a shared-nothing write lock (LOCK TABLES WRITE) is taken on related tables that are involved in the operation. WRITE locks normally have ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html
A member applies these policies to decide whether to join the group normally, or join in read-only mode, or not join the group, depending on which choice results in the safe operation of the joining member and of the existing members of the group.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
These functions manage the process of changing the group's mode and ensure the safety and consistency of your data. Group Replication operates either in single-primary mode or in multi-primary mode. The group's mode is a group-wide configuration ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
In earlier MySQL releases, foreign key metadata, which is owned by the child table, could not be updated safely. Alternatively, double quotation marks (") can be used if the ANSI_QUOTES SQL mode is enabled. Referential Actions When an UPDATE or ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-mode.html
When you change to single-primary mode, strict consistency checks are also disabled on all group members, as required in single-primary mode (group_replication_enforce_update_everywhere_checks=OFF). The following functions enable you to control the ...Return value: A string containing the result of the operation, for example whether it was successful or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
If all binary logs on the server were generated using MySQL 5.7.8 or later, binlog_gtid_simple_recovery=TRUE can always safely be used. If the server's most recent binary log files do not have GTID log events, for example if gtid_mode=ON was used ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
For the %U, %u, %V, and %v specifiers, see the description of the WEEK() function for information about the mode values. This means, for example, that “zero” dates or dates with part values of 0 are permitted unless the SQL mode is set to ...
https://dev.mysql.com/doc/refman/8.0/en/kerberos-pluggable-authentication.html
On Windows, the authentication_kerberos_client authentication plugin supports two modes, which the client user can set at runtime or specify in an option file: SSPI mode: Security Support Provider Interface (SSPI) implements GSSAPI (see Commands for ... Note Kerberos pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
The key to safe database management is making regular backups. Copy all InnoDB data files (ibdata files and .ibd files) into a safe place. Copy all InnoDB redo log files (#ib_redoN files in MySQL 8.0.30 and higher or ib_logfile files in earlier ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
(Once any possibility of a downgrade is past, you can safely change the corresponding system variable ndb_schema_dist_upgrade_allowed back to 1, the default, in the mysql client.) When each NDB Y SQL node starts, it connects to the cluster and ...