Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-enabling-monitors.html
Both the InnoDB Standard Monitor and InnoDB Lock Monitor must be enabled to have InnoDB Lock Monitor data printed periodically. Both the InnoDB standard Monitor and InnoDB Lock Monitor must be enabled to have InnoDB Lock Monitor data printed ...
https://dev.mysql.com/doc/refman/8.4/en/insert-select.html
You can explicitly select which partitions or subpartitions (or both) of the source or target table (or both) are to be used with a PARTITION clause following the name of the table. INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
The PARTITION clause takes a list of the comma-separated names of one or more partitions or subpartitions (or both) of the table. If both the column list and the VALUES list are empty, INSERT creates a row with each column set to its default value: ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-local-connections.html
For example, put the following lines in the server option file and restart the server: [mysqld] bind_address = * Specifying * (or ::) as the value for bind_address permits both IPv4 and IPv6 connections on all server host IPv4 and IPv6 interfaces.
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
If both arguments are objects, the result of the merge is an object with the following members: All members of the first object which do not have a corresponding member with the same key in the second object. All members with a key that exists in ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
The source and destination must differ, and the migration server must support both. The source and destination plugins must differ, and the migration server must support both plugins. MySQL supports the following keyring-related command-line ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Some keywords which are otherwise considered nonreserved are restricted from use as unquoted identifiers for roles, stored program labels, or, in some cases, both. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special ...
https://dev.mysql.com/doc/refman/8.4/en/logical-operators.html
When both operands are non-NULL, the result is 1 if any operand is nonzero, and 0 otherwise. Table 14.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
It is similar to calculating the arc tangent of Y / X, except that the signs of both arguments are used to determine the quadrant of the result. In the following example, the sequence of values produced by RAND(3) is the same both places it occurs.
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Suppose that a session begins a transaction that uses transactional table t and nontransactional table nt as follows: START TRANSACTION; SELECT * FROM t; SELECT * FROM nt; The server holds metadata locks on both t and nt until the transaction ends.