Online DDL Operations Data is reorganized substantially, making it an expensive operation. For additional information about the  ROW_FORMAT  option, see Table Options. ALTER TABLE  tbl_name  KEY_BLOCK_SIZE =  value , ALGORITHM=INPLACE, LOCK=NONE; Data is reorganized substantially, making it an expensive operation. For additional information about the  KEY_BLOCK_SIZE  option, see Table Options. Only modifies table metadata. Persistent statistics include  STATS_PERSISTENT ,  STATS_AUTO_RECALC , and  STATS_SAMPLE_PAGES . For more information, see Section 15.8.10.1, “Configuring Persistent Optimizer Statistics Parameters” . ALTER TABLE  tbl_name  CHARACTER SET =  charset_name , ALGORITHM=INPLACE, LOCK=NONE; Rebuilds the table if the new character encoding is different. ALTER TABLE  tbl_name  CONVERT TO CHARACTER SET  charset_name , ALGORITHM=COPY; Rebuilds the table if the new character encoding is different. OPTIMIZE TABLE  tbl_name ; In-place operation is not supported for tables with  FULLTEXT  indexes. The operation uses the  INPLACE algorithm, but  ALGORITHM  and  LOCK  syntax is not permitted. ALTER TABLE  tbl_name  FORCE, ALGORITHM=INPLACE, LOCK=NONE; Uses  ALGORITHM=INPLACE  as of MySQL 5.6.17.  ALGORITHM=INPLACE  is not supported for tables with  FULLTEXT  indexes. ALTER TABLE  tbl_name  ENGINE=InnoDB, ALGORITHM=INPLACE, LOCK=NONE; Uses  ALGORITHM=INPLACE  as of MySQL 5.6.17.  ALGORITHM=INPLACE  is not supported for tables with  FULLTEXT  indexes. ALTER TABLE  old_tbl_name  RENAME TO  new_tbl_name , ALGORITHM=INSTANT; Renaming a table can be performed instantly or in place. MySQL renames files that correspond to the table  tbl_name  without making a copy. (You can also use the  RENAME TABLE  statement to rename 3186 •Renaming a table •Performing a "null" rebuild •Rebuilding a table with the  FORCE  option •Optimizing a table •Converting a character set •Specifying a character set •Setting persistent table statistics options •Changing the  KEY_BLOCK_SIZE ALTER TABLE  tbl_name