MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 11 to 20 of 29 total results

17.6.1.5 Converting Tables from MyISAM to InnoDB

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

17.6.1.1 Creating InnoDB Tables

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

10.3.2 Primary Key Optimization

https://dev.mysql.com/doc/refman/9.7/en/primary-key-optimization.html

If your table is big and important, but does not have an obvious column or set of columns to use as a primary key, you might create a separate column with auto-increment values to use as the primary key. The primary key for a table represents the ...

10.5.5 Bulk Data Loading for InnoDB Tables

https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-bulk-data-loading.html

When doing bulk inserts into tables with auto-increment columns, set innodb_autoinc_lock_mode to 2 (interleaved) instead of 1 (consecutive). These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, ...

19.5.1.1 Replication and AUTO_INCREMENT

https://dev.mysql.com/doc/refman/9.7/en/replication-features-auto-increment.html

(Bug #11754117, Bug #45670) This issue does not affect tables using the InnoDB storage engine, since an InnoDB table with an AUTO_INCREMENT column requires at least one key where the auto-increment column is the only or leftmost column.

19.1.6.4 Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html

minimal: Log only those columns in the before image that are required to identify the row to be changed; log only those columns in the after image where a value was specified by the SQL statement, or generated by auto-increment. Startup Options ...

7.1.8 Server System Variables

https://dev.mysql.com/doc/refman/9.7/en/server-system-variables.html

The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the command line or in an option file. Most of them can be changed dynamically at runtime using the SET ...

7.3 The mysql System Schema

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

25.4.2.5 NDB Cluster mysqld Option and Variable Reference

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-option-tables.html

The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB Cluster. For a reference to all command-line options, system variables, and status ...

17.7.3 Locks Set by Different SQL Statements in InnoDB

https://dev.mysql.com/doc/refman/9.7/en/innodb-locks-set.html

With innodb_autoinc_lock_mode=0, InnoDB uses a special AUTO-INC table lock mode where the lock is obtained and held to the end of the current SQL statement (not to the end of the entire transaction) while accessing the auto-increment counter. A ...

Displaying 11 to 20 of 29 total results