Movatterモバイル変換

Many DDL operations on tables and indexes (CREATE,ALTER, andDROP statements) can be performed online. SeeSection 14.13, “InnoDB and Online DDL” for details.

Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated indexes by creating the table without secondary indexes, then adding secondary indexes after the data is loaded.

UseTRUNCATE TABLE to empty a table, notDELETE FROMtbl_name. Foreign key constraints can make aTRUNCATE statement work like a regularDELETE statement, in which case a sequence of commands likeDROP TABLE andCREATE TABLE might be fastest.

Because the primary key is integral to the storage layout of eachInnoDB table, and changing the definition of the primary key involves reorganizing the whole table, always set up the primary key as part of theCREATE TABLE statement, and plan ahead so that you do not need toALTER orDROP the primary key afterward.