Debian Codegraph @

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

raw
1 set @old_innodb_limit_optimistic_insert_debug = @@innodb_limit_optimistic_insert_debug;
2 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB STATS_PERSISTENT=0;
3 set global innodb_limit_optimistic_insert_debug = 2;
4 insert into t1 values (1);
5 connect con5,localhost,root;
6 begin;
7 insert into t1 values (5);
8 connect con4,localhost,root;
9 begin;
10 insert into t1 values (4);
11 connection default;
12 insert into t1 values (3);
13 connect con2,localhost,root;
14 begin;
15 insert into t1 values (2);
16 connection default;
17 analyze table t1;
18 Table Op Msg_type Msg_text
19 test.t1 analyze status Engine-independent statistics collected
20 test.t1 analyze status OK
21 select CLUST_INDEX_SIZE from information_schema.INNODB_SYS_TABLESTATS where NAME = 'test/t1';
22 CLUST_INDEX_SIZE
23 10
24 connection con4;
25 rollback;
26 disconnect con4;
27 connection default;
28 analyze table t1;
29 Table Op Msg_type Msg_text
30 test.t1 analyze status Engine-independent statistics collected
31 test.t1 analyze status OK
32 select CLUST_INDEX_SIZE from information_schema.INNODB_SYS_TABLESTATS where NAME = 'test/t1';
33 CLUST_INDEX_SIZE
34 8
35 connection con5;
36 rollback;
37 disconnect con5;
38 connection default;
39 analyze table t1;
40 Table Op Msg_type Msg_text
41 test.t1 analyze status Engine-independent statistics collected
42 test.t1 analyze status OK
43 select CLUST_INDEX_SIZE from information_schema.INNODB_SYS_TABLESTATS where NAME = 'test/t1';
44 CLUST_INDEX_SIZE
45 4
46 set global innodb_limit_optimistic_insert_debug = 10000;
47 connection con2;
48 rollback;
49 disconnect con2;
50 connection default;
51 analyze table t1;
52 Table Op Msg_type Msg_text
53 test.t1 analyze status Engine-independent statistics collected
54 test.t1 analyze status OK
55 select CLUST_INDEX_SIZE from information_schema.INNODB_SYS_TABLESTATS where NAME = 'test/t1';
56 CLUST_INDEX_SIZE
57 2
58 begin;
59 insert into t1 values (2);
60 rollback;
61 analyze table t1;
62 Table Op Msg_type Msg_text
63 test.t1 analyze status Engine-independent statistics collected
64 test.t1 analyze status OK
65 select CLUST_INDEX_SIZE from information_schema.INNODB_SYS_TABLESTATS where NAME = 'test/t1';
66 CLUST_INDEX_SIZE
67 1
68 begin;
69 insert into t1 values (2);
70 rollback;
71 analyze table t1;
72 Table Op Msg_type Msg_text
73 test.t1 analyze status Engine-independent statistics collected
74 test.t1 analyze status OK
75 select CLUST_INDEX_SIZE from information_schema.INNODB_SYS_TABLESTATS where NAME = 'test/t1';
76 CLUST_INDEX_SIZE
77 1
78 drop table t1;
79 set global innodb_limit_optimistic_insert_debug = @old_innodb_limit_optimistic_insert_debug;