MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 21 to 30 of 34 total results

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

19.1.6.4 Binary Logging Options and Variables

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

19.5.1.1 Replication and AUTO_INCREMENT

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

10.3.2 Primary Key Optimization

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

25.2.4 What is New in MySQL NDB Cluster 8.0

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html

In addition, two new options are provided for ndb_desc, also beginning in NDB 8.0.21: --auto-inc (short form -a): Includes the next auto-increment value in the output, if the table has an AUTO_INCREMENT column. The following sections describe ...

15.1.20 CREATE TABLE Statement

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

To set the first auto-increment value for engines that do not support the AUTO_INCREMENT table option, insert a “dummy” row with a value one less than the desired value after creating the table, and then delete the dummy row. | {FULLTEXT | ...

25.4.2.5 NDB Cluster mysqld Option and Variable Reference

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

15.2.2 DELETE Statement

https://dev.mysql.com/doc/refman/8.0/en/delete.html

Auto-Increment Columns If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value is not reused for a MyISAM or InnoDB table. DELETE is a DML statement that removes rows from a table. A DELETE statement can start ...

A.1 MySQL 8.0 FAQ: General

https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html

With the auto_increment_increment and auto_increment_offset system variables, you can set each server to generate auto-increment values that don't conflict with other servers. Why did MySQL version numbering skip versions 6 and 7 and go straight to ...

Displaying 21 to 30 of 34 total results