| 1 |
SET GLOBAL innodb_file_per_table=0; |
| 2 |
Warnings: |
| 3 |
Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release |
| 4 |
CREATE TABLE t(a INT)ENGINE=InnoDB; |
| 5 |
SET GLOBAL innodb_file_per_table=1; |
| 6 |
Warnings: |
| 7 |
Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release |
| 8 |
CREATE TABLE ibd4(a INT UNIQUE)ENGINE=InnoDB; |
| 9 |
CREATE TABLE ibd4f(a INT UNIQUE)ENGINE=InnoDB; |
| 10 |
CREATE TABLE ibd5(a INT UNIQUE, b INT UNIQUE)ENGINE=InnoDB; |
| 11 |
# Kill the server |
| 12 |
DROP TABLE t,ibd4,ibd4f,ibd5; |