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/innodb-memcached-internals.html
containers Table Column Constraints You must supply a value for db_schema, db_name, key_columns, value_columns and unique_idx_name_on_key. A pre-check is performed at plugin load time to enforce column constraints. InnoDB API for the InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-truncate-table-reclaim-space.html
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE TABLE operation fails. A foreign key constraint between two columns in the same table, however, is permitted. To ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
In this case, the first such index places the same constraint on table rows as an explicit primary key and that index cannot be made invisible. MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
The keyring functions are subject to these constraints: To use any keyring function, the keyring_udf plugin must be enabled. (This constraint rules out the use of the keyring functions for manipulation of instance-wide keys, such as those created by ... MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
Dropping a FOREIGN KEY constraint does not work in replication because the constraint may have another name on the replica. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
The following examples use HEX() to display the INET6_ATON() result in printable form: mysql> SELECT HEX(INET6_ATON('fdfe::5a55:caff:fefa:9089')); -> 'FDFE0000000000005A55CAFFFEFA9089' mysql> SELECT HEX(INET6_ATON('10.0.5.9')); -> '0A000509' ...The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
Deferring constraints in this way is currently supported only by NDB. This section discusses known problems or issues when using replication with NDB Cluster. A loss of connection can occur either between the source cluster SQL node and the replica ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
If you have UNIQUE constraints on secondary keys, you can speed up table imports by temporarily turning off the uniqueness checks during the import session: SET unique_checks=0; ... If you have FOREIGN KEY constraints in your tables, you can speed ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
This can happen, for example, on a multiple-row insert that has one row violating a key constraint, or if a long update statement is killed after updating some of the rows. For example, since MyISAM ignores foreign key constraints, an INSERT or ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
This value is incremented if you are querying an index column with a range constraint or if you are doing an index scan. These variables provide information about instrumentation that could not be loaded or created due to memory constraints. The ...