Spracherkennung für: .test vermutete Sprache: SQL {SQL[180] Lisp[73] Masm[73]} [Methode: maximale Elemente, drei Dimensionen]
--source include/have_innodb.inc
SELECT @@GLOBAL.innodb_open_files;
CREATE TABLE t0 (a INT) ENGINE=InnoDB;
# Ensure that the created table t0 is clean.
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;
# Now, the data file for t0 should not be open anymore.
FLUSH TABLE t0 WITH READ LOCK;
UNLOCK TABLES;
DROP TABLE t0, t1, t2, t3, t4, t5, t6, t7;
[Dauer der Verarbeitung: 0.12 Sekunden, vorverarbeitet 2026-10-08]