Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-context.html
update(Object instance, Function(Object error) callback); update(Function constructor, keys, values, Function(Object error) callback); update(String tableName, keys, values, Function(Object error) callback); Update an instance in the database with ...It contains functions that are executed immediately if called from a session, or when the batch is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-nodes-table.html
The rpd_nodes table is updated after the node has successfully joined the cluster. If additional nodes fail while node recovery is in progress, the newly failed nodes are not detected and their status is not updated in the ... The rpd_nodes ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations. In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked row-by-row. Use of an ...For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
For example, you can have two BEFORE UPDATE triggers for a table. In an UPDATE trigger, you can use OLD.col_name to refer to the columns of a row before it is updated and NEW.col_name to refer to the columns of the row after it is updated. In a ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-unattended-installation-cmdline-options-server.html
--help Display the list of valid options --installdir Installation directory --installer-language Language selection --mode Installation mode --mysql_installation_type MySQL server to be used by the MySQL Enterprise Monitor --optionfile Installation ... The following options let you customize the installation process for MySQL Enterprise Service ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-22.html
(Bug #30340510, WL #14002) For enhanced security of the existing AllowLoadLocalInfile connection string option, a single folder that is safe to upload files from now can be specified with the new AllowLoadLocalInfileInPath option (see Options for ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. The system variables are also not modified when Group Replication is in single-primary mode, where only ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-system-variables.html
For this to be safe, it must be assumed that the Vault server is not malicious and that no man-in-the-middle attack is possible. The directory should have a restrictive mode and be accessible only to the account used to run the MySQL server. These ...