PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The example uses the test.city table described in Creating a New Table and Column Mapping. When a range query finds multiple matching key-value pairs, results are returned in a key-value pair sequence. The examples use the test.city table described ... The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
Successive relay log files are created using successive sequence numbers, beginning with 000001. For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-key-rotation.html
When you rotate the binary log master key manually, MySQL Server takes the following actions in sequence: A new binary log encryption key is generated with the next available sequence number, stored on the keyring, and used as the new binary log ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
If you delete all rows in the table with DELETE FROM tbl_name (without a WHERE clause) in autocommit mode, the sequence starts over for all storage engines except InnoDB and MyISAM. In this case, reuse of values deleted from the top of the sequence ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
This might be zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. However, it might update zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. A ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. In the following example, the sequence of values produced by RAND(3) is the same ...ABS(X) Returns the absolute value of X, or NULL if X is ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
MRR iterates over a sequence of index ranges to obtain qualifying index tuples. The MRR optimization is not supported with secondary indexes created on virtual generated columns. Data rows are accessed according to the sorted index tuple sequence.
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
Omitting extraneous lines, the output for the row events produced by the preceding statement sequence looks like this: $> mysqlbinlog log_file ... The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
During the normal startup sequence, the server loads plugins registered in the table. The --plugin-load and --plugin-load-add options load plugins after built-in plugins and storage engines have initialized during the server startup sequence. For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
The keyring service handles the creation, retrieval, and deletion of the binary log encryption keys. A server instance only creates and removes keys generated for itself, but it can read keys generated for other instances if they are stored in the ... The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL ...