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/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...If you want ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
You may use a different tool but our examples are based on Gpg4win, and utilize its bundled Kleopatra GUI. Type "Mysql Release Engineering" into the search box and press Search. The Fingerprint and Key-ID must be "3A79BD29" for MySQL 8.0.28 and ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
What data types and data lengths does InnoDB data-at-rest encryption support? A.17.7. InnoDB data-at-rest encryption provides the benefit of encryption without the overhead associated with traditional database encryption solutions, which would ...Is ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally dependent on X. A UNIQUE index over a NOT NULL column could be used instead of a primary key and the same functional ... The following discussion provides several examples of the ways in which MySQL detects functional ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-dedicated-server.html
When the server is started with --innodb-dedicated-server, InnoDB automatically calculates values for and sets the following system variables: innodb_buffer_pool_size innodb_redo_log_capacity (MySQL 8.0.30 and later) innodb_log_file_size (prior to ...You should consider using --innodb-dedicated-server only if the MySQL instance resides on a dedicated server where it can use all available system resources—for example, if you run MySQL Server in a Docker container or dedicated VM that runs MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... It can be useful when inserting all columns from the source table into the target table, and no ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components, and the keyring_file and keyring_encrypted_file plugins are not intended as a regulatory compliance solution. Security standards such ... The component_keyring_file keyring component stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html
Table 14.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-using-management-client.html
In NDB 8.0.22 and later, START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. This function has the form shown here: key = KDF(random_salt, password) The key so generated is then used to encrypt the backup data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-example.html
To support NDB Cluster, you should update my.cnf as shown in the following example. You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf ...Note The options shown here should not be confused with those that are used in config.ini global configuration ...