MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 20 of 34 total results

https://dev.mysql.com/doc/refman/8.0/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 ...

17.20.6.2 Adapting a memcached Application for the InnoDB memcached Plugin

https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html

This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). Primary key values are included in secondary indexes, which takes up unnecessary space if the ...

17.7.1 InnoDB Locking

https://dev.mysql.com/doc/refman/8.0/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 ...

20.9.1 Group Replication System Variables

https://dev.mysql.com/doc/refman/8.0/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 ...

17.6.2.1 Clustered and Secondary Indexes

https://dev.mysql.com/doc/refman/8.0/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 ...

17.6.1.5 Converting Tables from MyISAM to InnoDB

https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html

Consider using an auto-increment column if there is not another stable, unique, non-null, numeric column to use. An auto-increment column is also a good choice if there is any doubt whether the value of the primary key column could ever change. If ...

25.5.13 ndb_import — Import CSV Data Into NDB

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html

ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. ndb_import requires a connection to an NDB management server (ndb_mgmd) to function; it does not require a connection to a MySQL ...

15.1.9 ALTER TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

To reset the current auto-increment value: ALTER TABLE t1 AUTO_INCREMENT = 13; You cannot reset the counter to a value less than or equal to the value that is currently in use. ALTER TABLE tbl_name [alter_option [, alter_option] ...] ...

14.4.2 Comparison Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html

See Obtaining Auto-Increment Values, and the description for the FLAG_AUTO_IS_NULL option at Connector/ODBC Connection Parameters. Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less ...

7.3 The mysql System Schema

https://dev.mysql.com/doc/refman/8.0/en/system-schema.html

innodb_dynamic_metadata: Used by the InnoDB storage engine to store fast-changing table metadata such as auto-increment counter values and index tree corruption flags. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational ...

Displaying 11 to 20 of 34 total results