| 1 |
--source include/have_innodb.inc |
| 2 |
|
| 3 |
SELECT @@GLOBAL.innodb_open_files; |
| 4 |
|
| 5 |
CREATE TABLE t0 (a INT) ENGINE=InnoDB; |
| 6 |
# Ensure that the created table t0 is clean. |
| 7 |
FLUSH TABLE t0 WITH READ LOCK; |
| 8 |
UNLOCK TABLES; |
| 9 |
CREATE TABLE t1 (a INT) ENGINE=InnoDB; |
| 10 |
CREATE TABLE t2 (a INT) ENGINE=InnoDB; |
| 11 |
CREATE TABLE t3 (a INT) ENGINE=InnoDB; |
| 12 |
CREATE TABLE t4 (a INT) ENGINE=InnoDB; |
| 13 |
CREATE TABLE t5 (a INT) ENGINE=InnoDB; |
| 14 |
CREATE TABLE t6 (a INT) ENGINE=InnoDB; |
| 15 |
CREATE TABLE t7 (a INT) ENGINE=InnoDB; |
| 16 |
# Now, the data file for t0 should not be open anymore. |
| 17 |
FLUSH TABLE t0 WITH READ LOCK; |
| 18 |
UNLOCK TABLES; |
| 19 |
DROP TABLE t0, t1, t2, t3, t4, t5, t6, t7; |