PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/join.html
A table reference (when it refers to a partitioned table) may contain a PARTITION clause, including a list of comma-separated partitions, subpartitions, or both. INNER JOIN and , (comma) are semantically equivalent in the absence of a join ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
The --nodeid and --backupid options are now both required when invoking ndb_restore. Both increasing and decreasing the number of columns making up the original primary key are supported. The new option can be used multiple times in the same ... The ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
Compressed connections originate on the client side but affect CPU load on both the client and server sides because both sides perform compression and decompression operations. For successful connection setup, both sides of the connection must agree ... Connections to the server can use compression on the traffic between client and server to reduce the number of bytes sent over the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Prior to MySQL 8.0.16, if the CONSTRAINT symbol clause was not defined, or a symbol was not included following the CONSTRAINT keyword, both InnoDB and NDB storage engines would use the FOREIGN_KEY index_name if defined. If a FOREIGN KEY clause is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...This is true regardless of whether the replica is a single server or a ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
(As a result, josh can connect with either the primary or secondary password.) The remaining properties apply globally to all accounts named in the statement, so for both accounts: Connections are required to use SSL. ALTER USER Authentication ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
Both ON DELETE and ON UPDATE actions on foreign keys are supported. You are advised to use foreign keys that reference only keys that are both UNIQUE (or PRIMARY) and NOT NULL. When creating MyISAM tables, you can use the DATA DIRECTORY='directory' ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
This compression algorithm is mature, robust, and efficient in both CPU utilization and in reduction of data size. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB compression ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
However, you can add a unique key that uses both c1 and c2. This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
Reuse restrictions can be established based on number of password changes, time elapsed, or both. The examples use ALTER USER, which is preferred over SET PASSWORD, but the principles described here are the same for both statements. Failed-login ...