Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new replica server; you might copy individual tables to another instance to develop and test an application, or to a data ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial product. Both files should be readable only by the appropriate user that runs the server, typically mysql. The manifest file must be named ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If you combine LIMIT ... If ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr DROP PARTITION p2; Query OK, 0 rows affected (0.03 sec) Note The NDBCLUSTER storage engine does not support ALTER TABLE ... You can see that this is the case by ...
https://dev.mysql.com/doc/refman/8.4/en/preface.html
This is the Reference Manual for the MySQL Database System, for the 8.4.6 LTS release. This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 8.4 and previous ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). binlog_gtid_simple_recovery Command-Line Format --binlog-gtid-simple-recovery[={OFF|ON}] System Variable ...For ...
https://dev.mysql.com/doc/refman/8.4/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. (MySQL Enterprise Edition only) MySQL Enterprise Audit, implemented using a server plugin, ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-troubleshooting.html
File Contexts If a MySQL directory or file has an incorrect SELinux context, access may be denied. This issue can occur if MySQL is configured to read from or write to a non-default directory or file. For example, if you configure MySQL to use a ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
This is not supported in MySQL.) MySQL supports UNION, INTERSECT, and EXCEPT. Limitations of Set Operations Set operations in MySQL are subject to some limitations, which are described in the next few paragraphs. These two UNION variants containing ... Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple query blocks into a single ...