--source include/have_debug.inc connect(con1,localhost,root,,); connect(con2,localhost,root,,); connection con1; set global table_definition_cache=400; set global table_open_cache= 1024; use test; SET SESSION innodb_strict_mode = OFF; CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="zlibX"; SHOW WARNINGS; SHOW CREATE TABLE t1; SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1'; insert into t1 values(1); commit; connection con2; use test; select * from t1; connection con1; select sleep(10); #### #Flush tables, so table can be evicted by master thread. #### flush tables; #### #Create 1000 tables, try the best to evict t_bug since table_def_size. #### --disable_query_log let $loop=1000; while ($loop > 1) { eval create table t_$loop(id int)engine=innodb; dec $loop; } select sleep(20); SET SESSION innodb_strict_mode = ON; DROP TABLE t1; let $loop=1000; while($loop > 1) { eval drop table t_$loop; dec $loop; } --enable_query_log set global table_definition_cache=default; set global table_open_cache= default; disconnect con1; disconnect con2;