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/storage-engines.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 3. InnoDB stores user data in clustered indexes ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
If the table has a foreign key relationship, foreign_key_checks must be disabled before executing DISCARD TABLESPACE. Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... IMPORT TABLESPACE does ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html
--get-server-public-key Command-Line Format --get-server-public-key Type Boolean Request from the server the public key required for RSA key pair-based password exchange. For that plugin, the server does not send the public key unless requested. If ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html
--get-server-public-key Command-Line Format --get-server-public-key Type Boolean Request from the server the public key required for RSA key pair-based password exchange. For that plugin, the server does not send the public key unless requested. If ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Foreign key referential actions (ON UPDATE, ON DELETE) are prohibited on columns used in CHECK constraints. Likewise, CHECK constraints are prohibited on columns used in foreign key referential actions. Prior to MySQL 8.0.16, CREATE TABLE permits ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online log. This is ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
One additional repository, the applier worker metadata repository, is created primarily for internal use, and holds status information about worker threads on a multithreaded replica. A replica server creates two replication metadata repositories, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to converting between the ucs2 character set and character sets such as utf16 or utf32. For example, the differences in maximum index key ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
Examples: utf8mb4_unicode_520_ci is based on UCA 5.2.0 weight keys (http://www.unicode.org/Public/UCA/5.2.0/allkeys.txt), utf8mb4_0900_ai_ci is based on UCA 9.0.0 weight keys (http://www.unicode.org/Public/UCA/9.0.0/allkeys.txt). This section ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
For ANALYZE TABLE operations that update the key distribution, failure may occur even if the operation updates the table itself (for example, if it is a MyISAM table). row *************************** id: 1 select_type: SIMPLE table: cs partitions: ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...