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/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Transactions are executed optimistically and then, at commit time, are checked for conflicts. MySQL Group Replication is designed to be deployed in a cluster environment where server instances are very close to each other. Bi-directional ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. Consider the following stored procedure, which adds .0001 to a variable 1,000 times. That is, for two numbers X1 and X2 that have scale S1 and S2, the scale of the ...These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
To configure that setting explicitly at startup, use these lines in the server my.cnf file: [mysqld] protocol_compression_algorithms=zlib,zstd,uncompressed To set and persist the protocol_compression_algorithms system variable to that value at ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition can work with keyring_aws on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Debian, Ubuntu, macOS, and Windows. MySQL Enterprise Edition does not support the use of keyring_aws on these platforms: EL6 Generic Linux (glibc2.12) SLES 12 (with versions after MySQL Server 5.7) Solaris The discussion here assumes that you are familiar with AWS in general and KMS in ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. For subpartitions not ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
From MySQL 8.0.27, Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-schema.html
Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain metadata required to execute SQL queries, whereas system tables contain auxiliary data such as time zone and help information.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
This causes no additional overhead, because the MySQL optimizer notices that the two MATCH() calls are identical and invokes the full-text search code only once. | 1.5219271183014 | | 6 | When configured properly, MySQL ... The MySQL FULLTEXT ... By ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
By default, MySQL (8.0.18 and later) employs hash joins whenever possible. Note MySQL 8.0.18 supported setting a hash_join flag in optimizer_switch, as well as the optimizer hints HASH_JOIN and NO_HASH_JOIN. In MySQL 8.0.19 and later, none of these ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...