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/update.html
Each value can be given as an expression, or the keyword DEFAULT to set a column explicitly to its default value. Rows for which duplicate-key conflicts occur on a unique key value are not updated. If you use a multiple-table UPDATE statement ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
Command Options for Encrypted Connections This section describes options for client programs that specify whether to use encrypted connections to the server, the names of certificate and key files, and other parameters related to ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
The optional GLOBAL keyword aggregates the values over all connections, and SESSION shows the values for the current connection. Caching_sha2_password_rsa_public_key The public key used by the caching_sha2_password authentication plugin for RSA key ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
On storage engines that support both atomic DDL and foreign key constraints, creation of foreign keys is not permitted in CREATE TABLE ... An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
The way InnoDB does fast primary key lookups is a natural fit for memcached single-item queries. The direct, low-level database access path used by the daemon_memcached plugin is much more efficient for key-value lookups than equivalent SQL queries.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
Use the set command to insert a record with a key of test1, a flag value of 10, an expiration value of 0, a cas value of 1, and a value of t1. The example record with a key of AA, and the record you just inserted, with a key of test1. The c1 column ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
LATEST FOREIGN KEY ERROR This section provides information about the most recent foreign key constraint error. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL tries to reduce the number of random disk access for range scans by first scanning the index only and collecting the keys for the relevant rows. Then the keys are sorted and finally the ... Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
row *************************** Table: accounts Non_unique: 0 Key_name: ACCOUNT Seq_in_index: 1 Column_name: USER Collation: NULL Cardinality: NULL Sub_part: NULL Packed: NULL Null: YES Index_type: HASH Comment: Index_comment: Visible: YES ...