PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-auto-increment-handling.html
InnoDB AUTO_INCREMENT Lock Modes InnoDB AUTO_INCREMENT Lock Mode Usage Implications InnoDB AUTO_INCREMENT Counter Initialization Notes InnoDB AUTO_INCREMENT Lock Modes This section describes the AUTO_INCREMENT lock modes used to generate ... InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/glossary.html
auto-increment A property of a table column (specified by the AUTO_INCREMENT keyword) that automatically adds an ascending sequence of values in the column. The values from such a column can be used as lookup keys in various contexts, and because ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-operations.html
INNODB_COLUMNS.DEFAULT_VALUE INNODB_COLUMNS.HAS_DEFAULT INNODB_TABLES.INSTANT_COLS Concurrent DML is not permitted when adding an auto-increment column. Dropping a column default value ALTER TABLE tbl ALTER COLUMN col DROP DEFAULT, ... Online ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html
This includes operations on blob tables, implicit unlock operations, and auto-increment operations, as well as user-visible primary key operations. This includes operations on blob tables, implicit unlock operations, and auto-increment operations, ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-api-statistics.html
Includes all execute() calls as well as implicit executes for blob operations and auto-increment not visible to clients. This count includes blob-part table operations, implicit unlocking operations, and auto-increment operations, as well as primary ... A number of types of statistical counters relating to actions performed by or affecting Ndb objects are ...
https://dev.mysql.com/doc/refman/9.7/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-recovery.html
The current maximum auto-increment counter value is written to the redo log each time the value changes, which makes it crash-safe. For more information about how InnoDB handles auto-increment values, see Section 17.6.1.6, “AUTO_INCREMENT Handling ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-locking.html
It allows you to choose how to trade off between predictable sequences of auto-increment values and maximum concurrency for insert operations. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-index-types.html
If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment column. Auto-increment column values are unique and are added automatically as new rows are inserted. Each InnoDB table has a ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-system-variables.html
group_replication_auto_increment_increment Command-Line Format --group-replication-auto-increment-increment=# System Variable group_replication_auto_increment_increment Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 7 ...