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-functions-for-member-actions.html
When this member action is enabled and taken, super read-only mode is disabled on the primary, so that the primary becomes read-write and accepts updates from a replication source server and from clients. When this member action is disabled and not ... The following functions can be used to enable and disable actions for members of a group to take in specified situations, and to reset the configuration to the default setting for all member ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
An exclusive (X) lock permits the transaction that holds the lock to update or delete a row. Transaction data for an intention lock appears similar to the following in SHOW ENGINE INNODB STATUS and InnoDB monitor output: TABLE LOCK table `test`.`t` ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
JSON_ARRAY_INSERT(json_doc, path, val[, path, val] ...) Updates a JSON document, inserting into an array within the document and returning the modified document. In MySQL 8.0.4, the optimizer can perform a partial, in-place update of a JSON column ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
With statement-based binary logging, having different modes for the source and replicas might lead to replication errors. For example, the following two queries are equivalent: SELECT * FROM t1 USE INDEX (i1) IGNORE INDEX (i2) USE INDEX (i2); SELECT ... Index hints give the optimizer information about how to choose indexes during query ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB Cluster”. These log messages also correspond to log ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
For example, if a user can grant the SELECT and UPDATE privileges to regular accounts, then with SYSTEM_USER the user can also grant SELECT and UPDATE to system accounts. From MySQL 8.0.30, if the user that puts a server in offline mode does not ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
To do so, stop updating the related tables, commit all transactions, acquire shared locks on the tables, and perform the export operations. The .cfg file format was updated in MySQL 8.0.19 to include index key part sort order information. DISCARD ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
Where the current binary logging mode does not include all columns, but only changed columns (--ndb-log-updated-only=OFF, --ndb-log-update-minimal=ON, --ndb-log-update-as-write=OFF), this can increase the volume of data sent from data nodes to SQL ...Where dependencies cannot be efficiently determined, mysqld falls back to considering transactions dependent for reasons of ...To use this functionality with NDB ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
If backed-up log files are encrypted, also back up the corresponding encryption passwords to a safe place, should you need to decrypt the files later. This section describes how to configure audit logging characteristics, such as the file to which ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-summary.html
If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement). In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make ...