PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
The locks are normally next-key locks that also block inserts into the “gap” immediately before the record. For example, in a UNION, scanned (and locked) rows from a table might be inserted into a temporary table before evaluating whether they ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
This comes into play when the main MySQL thread gets very many connection requests in a very short time. Otherwise, MySQL acquires a normal write lock and inserts the row into the hole. It is an unsupported combination that could result in a hang ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each row inserted into the table. In the example, the trigger body is a simple SET that accumulates into ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
It is possible to use IGNORE with ON DUPLICATE KEY UPDATE in an INSERT statement, but this may not behave as you expect when inserting multiple rows into a table that has multiple unique keys. For example: INSERT INTO t1 (a,b,c) VALUES ... If you ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. --num-slices=# Command-Line Format --num-slices=# Introduced 5.7.29-ndb-7.6.13 Type Integer Default Value 1 Minimum Value 1 Maximum ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
Therefore, these functions should not be used to insert into a source table because the content on the replica would differ. For example, do not issue a statement such as INSERT INTO mytable VALUES(GET_LOCK(...)). For a two-row insert, you can do ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-reference.html
Note The rules table is loaded into the plugin by the flush_rewrite_rules stored procedure. Load operations (performed by invoking the flush_rewrite_rules() stored procedure) load the rule from the table into the Rewriter in-memory cache only if ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... In this lock mode, all “INSERT-like” statements ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...