Search Results
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The insert_id and timestamp options are not propagated to the data provider. The remote table that a ...
https://dev.mysql.com/doc/refman/8.4/en/fixed-point-types.html
In MySQL, NUMERIC is implemented as DECIMAL, so the following remarks about DECIMAL apply equally to NUMERIC. The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve exact precision, for ...
https://dev.mysql.com/doc/refman/8.4/en/general-installation-issues.html
For binary distributions, see the instructions at Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries” or the corresponding section for your platform if available. To build MySQL from source, use the instructions in Section 2.8, ... The immediately following sections contain the information necessary to choose, download, and verify your ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
You can see this using EXPLAIN: mysql> EXPLAIN SELECT * FROM t1 WHERE f1 + 1 > 9\G *************************** 1. That is also apparent in the rewritten query available in the extended EXPLAIN information displayed by SHOW WARNINGS: mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
In some cases, MySQL is able to do much better than that and avoid creation of temporary tables by using index access. With this access method, MySQL uses the property of some index types that the keys are ordered (for example, BTREE). If the GROUP ... The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-securing.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied ...When a member joins the group, distributed recovery is carried out using a combination of a remote cloning operation, if available and appropriate, and an asynchronous replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; To check that the plugin was ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-offline-upgrade.html
See Section 20.8.3.2, “Upgrading a Group Replication Member” for how to remove members from a group and shutdown MySQL. See Chapter 3, Upgrading MySQL for how to perform an upgrade. If you have a requirement to allow members at earlier releases ... To perform an offline upgrade of a Group Replication group, you remove each member from the group, perform an upgrade of the member and then restart the group as ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. PRTYPE The InnoDB “precise type”, a binary value with bits representing ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-keywords-table.html
This table provides applications a runtime source of MySQL keyword information. The KEYWORDS table lists the words considered keywords by MySQL and, for each one, indicates whether it is reserved. Reserved keywords may require special treatment in ...