PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/charset-general.html
In real life, most character sets have many characters: not just A and B but whole alphabets, sometimes multiple alphabets or eastern writing systems with thousands of characters, along with many special symbols and punctuation marks. A character ...A collation is a set of rules for comparing characters in a character ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...In cases where you have additional software safeguards, ultra-reliable hardware, or an application that can tolerate a small amount of data loss or inconsistency, you can adjust MySQL settings to trade some of the ACID reliability for greater performance or ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
You want to use a column containing date or time values, or containing values arising from some other series. Partition the table by RANGE COLUMNS, using a DATE or DATETIME column as the partitioning column. Ranges should be contiguous but not ... A ...
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, ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html
Note Before proceeding with the installation, be sure to stop all running MySQL server instances by using either the MySQL Manager Application (on macOS Server), the preference pane, or mysqladmin shutdown on the command line. Double-click the file ... The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the ...