Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/en/replication-options-replica.html
There must be no cross-database constraints, as such constraints may be violated on the replica. This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
The standard SQL way to obtain foreign key information is by using the INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS and KEY_COLUMN_USAGE tables; these tables are now implemented as views on the foreign_keys, foreign_key_column_usage, and other data ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
TRUNCATE TABLE fails for an InnoDB table or NDB table if there are any FOREIGN KEY constraints from other tables that reference the table. Foreign key constraints between columns of the same table are permitted. Logically, TRUNCATE TABLE is similar ...