Debian Codegraph @

mysql-test/suite/innodb/r/create_drop_temp_table_perf_1.result

raw
1 set global innodb_file_per_table = 0;
2 DROP TABLE IF EXISTS t1,t2;
3 select @@global.innodb_change_buffering;
4 @@global.innodb_change_buffering
5 all
6 create temporary table t1
7 (keyc int, c1 char(100), c2 char(100),
8 primary key(keyc)) engine = innodb;
9 create index idx on t1(keyc, c1(20));
10 create procedure populate_t1(IN `rows` INT)
11 begin
12 declare i int default 1;
13 while (i <= `rows`) DO
14 insert into t1 values (i, 'a', 'b');
15 set i = i + 1;
16 end while;
17 end|
18 set autocommit=0;
19 select count(*) from t1;
20 count(*)
21 0
22 call populate_t1(1000);
23 select count(*) from t1;
24 count(*)
25 1000
26 select * from t1 limit 10;
27 keyc c1 c2
28 1 a b
29 2 a b
30 3 a b
31 4 a b
32 5 a b
33 6 a b
34 7 a b
35 8 a b
36 9 a b
37 10 a b
38 commit;
39 update t1 set keyc = -1 * keyc where keyc%50 = 0;
40 select count(*) from t1 where keyc < 0;
41 count(*)
42 20
43 drop table t1;
44 set @@global.innodb_change_buffering = none ;
45 select @@global.innodb_change_buffering;
46 @@global.innodb_change_buffering
47 none
48 create temporary table t1
49 (keyc int, c1 char(100), c2 char(100),
50 primary key(keyc)) engine = innodb;
51 create index idx on t1(keyc, c1(20));
52 set autocommit=0;
53 select count(*) from t1;
54 count(*)
55 0
56 CALL populate_t1(1000);
57 select count(*) from t1;
58 count(*)
59 1000
60 select * from t1 limit 10;
61 keyc c1 c2
62 1 a b
63 2 a b
64 3 a b
65 4 a b
66 5 a b
67 6 a b
68 7 a b
69 8 a b
70 9 a b
71 10 a b
72 commit;
73 update t1 set keyc = -1 * keyc where keyc%50 = 0;
74 select count(*) from t1 where keyc < 0;
75 count(*)
76 20
77 drop table t1;
78 drop procedure if exists populate_t1;
79 set global innodb_change_buffering = all;
80 set global innodb_file_per_table = default;