#start mysqld with --skip-grant-tables --open_files_limit=16 --table_cache=1 --max_connections=1

set global table_open_cache=100;

connect (addconroot, localhost, root,,);
connection addconroot;

show global status like '%open_files%';
--disable_query_log
--disable_warnings
drop table if exists t0;
create table t0(id int)engine=myisam;
drop table if exists t1;
create table t1(id int)engine=myisam;
drop table if exists t2;
create table t2(id int)engine=myisam;
drop table if exists t3;
create table t3(id int)engine=myisam;
drop table if exists t4;
create table t4(id int)engine=myisam;
drop table if exists t5;
create table t5(id int)engine=myisam;
drop table if exists t6;
create table t6(id int)engine=myisam;
drop table if exists t7;
create table t7(id int)engine=myisam;
drop table if exists t8;
create table t8(id int)engine=myisam;
drop table if exists t9;
create table t9(id int)engine=myisam;
drop table if exists t10;
create table t10(id int)engine=myisam;
drop table if exists t11;
create table t11(id int)engine=myisam;
drop table if exists t12;
create table t12(id int)engine=myisam;
drop table if exists t13;
create table t13(id int)engine=myisam;
drop table if exists t14;
create table t14(id int)engine=myisam;
drop table if exists t15;
create table t15(id int)engine=myisam;
drop table if exists t16;
create table t16(id int)engine=myisam;
drop table if exists t17;
create table t17(id int)engine=myisam;
drop table if exists t18;
create table t18(id int)engine=myisam;
drop table if exists t19;
create table t19(id int)engine=myisam;
drop table if exists t20;
create table t20(id int)engine=myisam;
drop table if exists t21;
create table t21(id int)engine=myisam;
drop table if exists t22;
create table t22(id int)engine=myisam;
drop table if exists t23;
create table t23(id int)engine=myisam;
drop table if exists t24;
create table t24(id int)engine=myisam;
drop table if exists t25;
create table t25(id int)engine=myisam;
drop table if exists t26;
create table t26(id int)engine=myisam;
drop table if exists t27;
create table t27(id int)engine=myisam;
drop table if exists t28;
create table t28(id int)engine=myisam;
drop table if exists t29;
create table t29(id int)engine=myisam;
drop table if exists t30;
create table t30(id int)engine=myisam;
drop table if exists t31;
create table t31(id int)engine=myisam;
drop table if exists t32;
create table t32(id int)engine=myisam;
drop table if exists t33;
create table t33(id int)engine=myisam;
drop table if exists t34;
create table t34(id int)engine=myisam;
drop table if exists t35;
create table t35(id int)engine=myisam;
drop table if exists t36;
create table t36(id int)engine=myisam;
drop table if exists t37;
create table t37(id int)engine=myisam;
drop table if exists t38;
create table t38(id int)engine=myisam;
drop table if exists t39;
create table t39(id int)engine=myisam;
drop table if exists t40;
create table t40(id int)engine=myisam;
drop table if exists t41;
create table t41(id int)engine=myisam;
drop table if exists t42;
create table t42(id int)engine=myisam;
drop table if exists t43;
create table t43(id int)engine=myisam;
drop table if exists t44;
create table t44(id int)engine=myisam;
drop table if exists t45;
create table t45(id int)engine=myisam;
drop table if exists t46;
create table t46(id int)engine=myisam;
drop table if exists t47;
create table t47(id int)engine=myisam;
drop table if exists t48;
create table t48(id int)engine=myisam;
drop table if exists t49;
create table t49(id int)engine=myisam;
drop table if exists t50;
create table t50(id int)engine=myisam;
drop table if exists t51;
create table t51(id int)engine=myisam;
drop table if exists t52;
create table t52(id int)engine=myisam;
drop table if exists t53;
create table t53(id int)engine=myisam;
drop table if exists t54;
create table t54(id int)engine=myisam;
drop table if exists t55;
create table t55(id int)engine=myisam;
drop table if exists t56;
create table t56(id int)engine=myisam;
drop table if exists t57;
create table t57(id int)engine=myisam;
drop table if exists t58;
create table t58(id int)engine=myisam;
drop table if exists t59;
create table t59(id int)engine=myisam;
drop table if exists t60;
create table t60(id int)engine=myisam;
drop table if exists t61;
create table t61(id int)engine=myisam;
drop table if exists t62;
create table t62(id int)engine=myisam;
drop table if exists t63;
create table t63(id int)engine=myisam;
drop table if exists t64;
create table t64(id int)engine=myisam;
drop table if exists t65;
create table t65(id int)engine=myisam;
drop table if exists t66;
create table t66(id int)engine=myisam;
drop table if exists t67;
create table t67(id int)engine=myisam;
drop table if exists t68;
create table t68(id int)engine=myisam;
drop table if exists t69;
create table t69(id int)engine=myisam;
drop table if exists t70;
create table t70(id int)engine=myisam;
drop table if exists t71;
create table t71(id int)engine=myisam;
drop table if exists t72;
create table t72(id int)engine=myisam;
drop table if exists t73;
create table t73(id int)engine=myisam;
drop table if exists t74;
create table t74(id int)engine=myisam;
drop table if exists t75;
create table t75(id int)engine=myisam;
drop table if exists t76;
create table t76(id int)engine=myisam;
drop table if exists t77;
create table t77(id int)engine=myisam;
drop table if exists t78;
create table t78(id int)engine=myisam;
drop table if exists t79;
create table t79(id int)engine=myisam;
drop table if exists t80;
create table t80(id int)engine=myisam;
drop table if exists t81;
create table t81(id int)engine=myisam;
drop table if exists t82;
create table t82(id int)engine=myisam;
drop table if exists t83;
create table t83(id int)engine=myisam;
drop table if exists t84;
create table t84(id int)engine=myisam;
drop table if exists t85;
create table t85(id int)engine=myisam;
drop table if exists t86;
create table t86(id int)engine=myisam;
drop table if exists t87;
create table t87(id int)engine=myisam;
drop table if exists t88;
create table t88(id int)engine=myisam;
drop table if exists t89;
create table t89(id int)engine=myisam;
drop table if exists t90;
create table t90(id int)engine=myisam;
drop table if exists t91;
create table t91(id int)engine=myisam;
drop table if exists t92;
create table t92(id int)engine=myisam;
drop table if exists t93;
create table t93(id int)engine=myisam;
drop table if exists t94;
create table t94(id int)engine=myisam;
drop table if exists t95;
create table t95(id int)engine=myisam;
drop table if exists t96;
create table t96(id int)engine=myisam;
drop table if exists t97;
create table t97(id int)engine=myisam;
drop table if exists t98;
create table t98(id int)engine=myisam;
drop table if exists t99;
create table t99(id int)engine=myisam;
--disable_result_log
show table status;
--enable_result_log
--enable_warnings
--enable_query_log
show global status like '%open_files%';
show global status where variable_name in ('open_files');
show table status like 't9%';
drop table if exists t90;
drop table if exists t91;
drop table if exists t92;
drop table if exists t93;
drop table if exists t94;
drop table if exists t95;
drop table if exists t96;
drop table if exists t97;
drop table if exists t98;
drop table if exists t99;
show table status like 't9%';
#create table t99(id int)engine=myisam;
show global status like '%open_files%';
show global status where variable_name in ('open_files');