blob: cd6bec48d4e8e0c56d46ebceeb22067b194fdafe (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
SELECT @@GLOBAL.innodb_open_files;
@@GLOBAL.innodb_open_files
10
CREATE TABLE t0 (a INT) ENGINE=InnoDB;
FLUSH TABLE t0 WITH READ LOCK;
UNLOCK TABLES;
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
CREATE TABLE t2 (a INT) ENGINE=InnoDB;
CREATE TABLE t3 (a INT) ENGINE=InnoDB;
CREATE TABLE t4 (a INT) ENGINE=InnoDB;
CREATE TABLE t5 (a INT) ENGINE=InnoDB;
CREATE TABLE t6 (a INT) ENGINE=InnoDB;
CREATE TABLE t7 (a INT) ENGINE=InnoDB;
FLUSH TABLE t0 WITH READ LOCK;
UNLOCK TABLES;
DROP TABLE t0, t1, t2, t3, t4, t5, t6, t7;
|
