# ls -lh
total 11G
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:27 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 04:36 city_sample.ibd
-rw-r----- 1 mysql mysql 588M Jun 2 04:38 #sql-ib1304-1434569684.ibd
#
実行完了
# ls -lh
total 16G
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:27 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 04:36 city_sample.ibd
-rw-r----- 1 mysql mysql 5.2G Jun 2 04:48 #sql-ib1304-1434569684.ibd
# ls -lh
total 11G
-rw-r----- 1 mysql mysql 5.2G Jun 2 04:48 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 04:36 city_sample.ibd
# ls -lh
total 11G
-rw-r----- 1 mysql mysql 5.2G Jun 2 04:48 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 05:40 city_sample.ibd
#
実行完了
# ls -lh
total 14G
-rw-r----- 1 mysql mysql 5.2G Jun 2 04:48 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 05:40 city_sample.ibd
-rw-r----- 1 mysql mysql 3.6G Jun 2 05:51 #sql-ib1365-1434569688.ibd
# ls -lh
total 11G
-rw-r----- 1 mysql mysql 5.2G Jun 2 05:56 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 05:40 city_sample.ibd
#
ALTER TABLE中の一時テーブル処理 (ALGORITHM=COPY)
# ls -lh
total 11G
-rw-r----- 1 mysql mysql 5.2G Jun 2 05:56 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 05:40 city_sample.ibd
# /usr/local/mysql/bin/mysql -u root -p -e "alter table shell.city_sample1 engine=InnoDB, ALGORITHM=COPY;"
Enter password:
# ls -lh
total 11G
-rw-r----- 1 mysql mysql 5.0G Jun 7 10:03 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 05:40 city_sample.ibd
実行開始直後
# ls -lh
total 11G
-rw-r----- 1 mysql mysql 5.2G Jun 2 05:56 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 05:40 city_sample.ibd
-rw-r----- 1 mysql mysql 48M Jun 7 09:55 #sql-6822_1d.ibd
実行完了
# ls -lh
total 11G
-rw-r----- 1 mysql mysql 5.0G Jun 7 10:03 city_sample1.ibd
-rw-r----- 1 mysql mysql 5.0G Apr 21 23:25 city_sample1_old.ibd
-rw-r----- 1 mysql mysql 276M Jun 2 05:40 city_sample.ibd