Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-next-key-locking.html
To prevent phantoms, InnoDB uses an algorithm called next-key locking that combines index-row locking with gap locking. In addition, a next-key lock on an index record also affects the “gap” before the index record. That is, a next-key lock is ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/key-valuepair-reference.html
This result type enables the return of a two-column result set as key-value pair. Unlike the default attributes, which are taken from the column name, the key is the attribute name and the value is the attribute value. Important The key value must ... It is possible to return more than one row, using the result type ...
https://dev.mysql.com/doc/workbench/en/wb-keys.html
The following tables list keyboard shortcuts for MySQL Workbench commands.
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files.html
SSL certificate and key files enable MySQL to support encrypted connections using SSL. RSA key files enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password (deprecated) or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-secretsfile-reader.html
ndb_secretsfile_reader gets the encryption key from an NDB encryption secrets file, given the password. Usage ndb_secretsfile_reader options file The options must include one of --filesystem-password or --filesystem-password-from-stdin, and the ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
foreign_key_checks System Variable foreign_key_checks Scope Global, Session Dynamic Yes SET_VAR Hint Applies Yes Type Boolean Default Value ON If set to 1 (the default), foreign key constraints are checked. If set to 0, foreign key constraints are ...admin_ssl_key Command-Line Format --admin-ssl-key=file_name System Variable admin_ssl_key Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value NULL The admin_ssl_key system variable is like ssl_key, except that it applies to the administrative connection interface rather than the main connection ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-schema-error.html
The following list enumerates all NDB errors of type SE (Schema error).
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
Having a table without primary key uses an autoincremented hidden key, i.e. The following list enumerates all NDB errors of type AE (Application error). NDB error code 5002 MySQL error DMEC Error message The process has wrong type. NDB error code ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
Dictionary::createForeignKey() Description Creates a ForeignKey object, given a reference to this object and an Object ID. Signature int createForeignKey ( const ForeignKey&, ObjectId* = 0, int flags = 0 ) Parameters A reference to the ForeignKey ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Support for foreign key constraints in NDB 8.4 is comparable to that provided by InnoDB, subject to the following restrictions: Every column referenced as a foreign key requires an explicit unique key, if it is not the table's primary key. (Bug ...