ddl transaction

MySQL Online DDL Improvement and Application, mysqlddlThis article analyzes the implementation principle and precautions of Online DDL. For any DDL operation, the performer must perform a pre-test or clearly understand whether the impact of this

MySQL 8.0 begins to support atomic data definition language (DDL) statements. This feature is known as Atomic DDL. The Atomic DDL statement updates the data dictionary associated with the DDL operation, and the storage engine operations and binary

This paper briefly analyzes the implementation principle of the online DDL and the considerations of the use process.     any DDL operation, the performer needs to pre-test or clearly understand whether this operation will affect the database within

MySQL 8.0 begins to support atomic data definition language (DDL) statements. This feature is known as Atomic DDL. The Atomic DDL statement updates the data dictionary associated with the DDL operation, and the storage engine operations and binary

1. Online DDLIn MySQL 5.1 (with InnoDB Plugin) and 5.5, a new feature called Fast Index Creation (FIC), is to add or remove the two-level index , you can not copy the original table. For the previous version of the addition of the index to remove

A database is a shared resource that can be used by multiple users. These user programs can be executed serially, with only one user program running at a time, and access to the database is performed, and other user programs must wait until the end

MySQL 5.5 DDLPrior to MySQL version 5.5, all DDL operations were done using copy table, which was not allowed to be written, read only, and introduced the FIC (Fast index creation) feature in MySQL version 5.5.FCI 操作流程：（1）对表加共享S锁，允许其他会话读操作，但禁止写操作，（2）

During the development process, the oracleDDL statement and DML statement must be processed in one transaction. The method either succeeds or fails. For this problem, sqls During the development process, if the oracle DDL statement and DML statement

Oracle lock 3: DDL lock, oracle lock 3ddlWhen an ongoing DDL operation is executed or a schema object (Note) is referenced, the Data dcictionary (DDL) Lock is used to protect the definition of the schema object, only a single schema object is locked

I. Start with the question During the development process, if the Oracle DDL statement and DML statement need to be processed in one transaction, the method either succeeds or fails. SQL server and other databases can solve this problem because it