Data is reorganized substantially, making it an expensive operation. 

For additional information about the ROW_FORMAT  option, see Table Options. 

•Changing the KEY_BLOCK_SIZE 

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. 

•Setting persistent table statistics options 

ALTER TABLE tbl_name 

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” . 

•Specifying a character set 

ALTER TABLE tbl_name  CHARACTER SET = charset_name , ALGORITHM=INPLACE, LOCK=NONE; 

Rebuilds the table if the new character encoding is different. 

•Converting a character set 

ALTER TABLE tbl_name  CONVERT TO CHARACTER SET charset_name , ALGORITHM=COPY; 

Rebuilds the table if the new character encoding is different. 

•Optimizing a table 

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. 

•Rebuilding a table with the FORCE  option 

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. 

•Performing a "null" rebuild 

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. 

•Renaming a table 

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 

