PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/mysql-nutshell.html
These InnoDB enhancements were added: The current maximum auto-increment counter value is written to the redo log each time the value changes, and saved to an engine-private system table on each checkpoint. These changes make the current maximum ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/innodb-parameters.html
innodb_autoinc_lock_mode Command-Line Format --innodb-autoinc-lock-mode=# System Variable innodb_autoinc_lock_mode Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 2 Valid Values 012 The lock mode to use for generating ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
You can declare an auto-increment column so that ascending values are filled in automatically as rows are inserted: # The value of ID can act like a pointer between related items in different tables. CREATE TABLE t6 (id INT AUTO_INCREMENT, a INT, b ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Statement-based replication requires the consecutive auto-increment lock mode to ensure that auto-increment values are assigned in a predictable and repeatable order for a given sequence of SQL statements, whereas row-based replication is not ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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 ...