Skip to content

Instantly share code, notes, and snippets.

@yoku0825

yoku0825/gist:af3aef5572a9240dfc725d182c515ac7

Created November 15, 2021 09:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yoku0825/af3aef5572a9240dfc725d182c515ac7 to your computer and use it in GitHub Desktop.
Save yoku0825/af3aef5572a9240dfc725d182c515ac7 to your computer and use it in GitHub Desktop.
Download ZIP
innodb_file_per_tableを途中で跨がせる
Raw
gistfile1.txt
$ ll /usr/mysql/5.7.36/data/d1/
total 220
-rw-r----- 1 yoku0825 yoku0825 67 Nov 15 17:50 db.opt
-rw-r----- 1 yoku0825 yoku0825 8586 Nov 15 17:57 t1.frm
-rw-r----- 1 yoku0825 yoku0825 98304 Nov 15 17:57 t1.ibd <--- innodb_file_per_table= ON
-rw-r----- 1 yoku0825 yoku0825 8586 Nov 15 17:56 t3.frm
-rw-r----- 1 yoku0825 yoku0825 98304 Nov 15 17:56 t3.ibd
mysql57 11> SET GLOBAL innodb_file_per_table= 0;
Query OK, 0 rows affected (0.00 sec)
mysql57 11> ALTER TABLE t1 Engine = InnoDB;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql57 11> ^DBye
$ ll /usr/mysql/5.7.36/data/d1/
total 220
-rw-r----- 1 yoku0825 yoku0825 67 Nov 15 17:50 db.opt
-rw-r----- 1 yoku0825 yoku0825 8586 Nov 15 17:58 t1.frm
-rw-r----- 1 yoku0825 yoku0825 98304 Nov 15 17:58 t1.ibd <--- innodb_file_per_table= ON のまま
-rw-r----- 1 yoku0825 yoku0825 8586 Nov 15 17:56 t3.frm
-rw-r----- 1 yoku0825 yoku0825 98304 Nov 15 17:56 t3.ibd
mysql57 12> ALTER TABLE t1 Engine = InnoDB, ALGORITHM= COPY;
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql57 12> ^DBye
$ ll /usr/mysql/5.7.36/data/d1/
total 124
-rw-r----- 1 yoku0825 yoku0825 67 Nov 15 17:50 db.opt
-rw-r----- 1 yoku0825 yoku0825 8586 Nov 15 17:58 t1.frm <--- innodb_file_per_table= OFF
-rw-r----- 1 yoku0825 yoku0825 8586 Nov 15 17:56 t3.frm
-rw-r----- 1 yoku0825 yoku0825 98304 Nov 15 17:56 t3.ibd
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment