PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/constraints.html
We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs. Several SQL mode options are available to provide greater control over handling of bad ... MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
The locking interface has these characteristics: Locks have three attributes: Lock namespace, lock name, and lock mode: Locks are identified by the combination of namespace and lock name. lock_type: The lock mode, either LOCKING_SERVICE_READ or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cluster-locks.html
The mode column shows the lock mode; this is always one of S (indicating a shared lock) or X (an exclusive lock). This is always one of the values READ, INSERT, UPDATE, DELETE, SCAN, or REFRESH. The cluster_locks table provides information about ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-server-locks.html
The mode column shows the lock mode, which is always one of S (shared lock) or X (exclusive lock). This is always one of the values READ, INSERT, UPDATE, DELETE, SCAN, or REFRESH. The server_locks table is similar in structure to the cluster_locks ...
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/innodb-standard-monitor.html
The lock modes reported in this section are explained in Section 17.7.1, “InnoDB Locking”. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
For another MySQL extension to standard SQL—that either inserts or updates—see Section 15.2.7.2, “INSERT ... such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For truncation of nonspace characters, you can cause an error to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-consensus-leader.html
From MySQL 8.0.27, the group communication engine can use a single leader to drive consensus when the group is in single-primary mode. Operating with a single consensus leader improves performance and resilience in single-primary mode, particularly ... By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a ...