PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
Undo logs in the rollback segment are divided into insert and update undo logs. Otherwise, InnoDB cannot discard data from the update undo logs, and the rollback segment may grow too big, filling up the undo tablespace in which it resides. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-installation.html
Note Only one keyring component or plugin should be enabled at a time. Enabling multiple keyring components or plugins is unsupported and results may not be as anticipated. For example, the InnoDB storage engine uses the keyring for tablespace ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-management.html
Managing an NDB Cluster involves a number of tasks, the first of which is to configure and start NDB Cluster. This is covered in Section 25.4, “Configuration of NDB Cluster”, and Section 25.5, “NDB Cluster Programs”. For information about ...The next few sections cover the management of a running NDB ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-different-number-nodes.html
The files created by the backup on each data node are listed here, where N is the node ID and B is the backup ID. For this example, copy the backup files from nodes 2 and 4 from the original cluster to node 3 in the target cluster. When performing a ... It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23). It contains values that define how the replica connects to the source ... This table shows the configuration parameters used by the replica for connecting to the ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
The B-tree data structure lets the index quickly find a specific value, a set of values, or a range of values, corresponding to operators such as =, >, ≤, BETWEEN, IN, and so on, in a WHERE clause. The maximum number of indexes per table and the ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
TLS is sometimes referred to as SSL (Secure Sockets Layer) but MySQL does not actually use the SSL protocol for encrypted connections because its encryption is weak (see Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”). By ...
https://dev.mysql.com/doc/refman/8.0/en/error-interfaces.html
Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and Elements”. For lists of server-side, ...For error checking from within programs, use error code numbers or symbols, not error message ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
All other servers that join the group learn about the primary server and are automatically set to read-only mode. In single-primary mode, Group Replication enforces that only a single server writes to the group, so compared to multi-primary mode, ...