Debian Codegraph @

mysql-test/suite/binlog/r/binlog_stm_cache_stat.result

raw
1 drop table if exists t1, t2;
2 create table t1 (a int) engine=innodb;
3 create table t2 (a int) engine=myisam;
4 set @save_binlog_stmt_cache_size=@@global.binlog_stmt_cache_size;
5 set @save_binlog_cache_size=@@global.binlog_cache_size;
6 set @@global.binlog_stmt_cache_size=32768;
7 set @@global.binlog_cache_size=32768;
8 **** Preparing the enviroment to check commit and its effect on status variables.
9 **** Expected: binlog_cache_use = 0, binlog_cache_disk_use = 0.
10 **** Expected: binlog_stmt_cache_use = 0, binlog_stmt_cache_disk_use = 0.
11 flush global status;
12 **** Transactional changes which are long enough so they will be flushed to disk...
13 **** Expected: binlog_cache_use = 1, binlog_cache_disk_use = 1.
14 **** Expected: binlog_stmt_cache_use = 0, binlog_stmt_cache_disk_use = 0.
15 **** Transactional changes which should not be flushed to disk and so should not
16 **** increase either binlog_cache_disk_use or binlog_stmt_cache_disk_use.
17 **** Expected: binlog_cache_use = 2, binlog_cache_disk_use = 1.
18 **** Expected: binlog_stmt_cache_use = 0, binlog_stmt_cache_disk_use = 0.
19 begin;
20 insert into t1 values( 1 );
21 commit;
22 **** Non-Transactional changes which should not be flushed to disk and so should not
23 **** increase either binlog_cache_disk_use or binlog_stmt_cache_disk_use.
24 **** Expected: binlog_cache_use = 2, binlog_cache_disk_use = 1.
25 **** Expected: binlog_stmt_cache_use = 1, binlog_stmt_cache_disk_use = 0.
26 begin;
27 insert into t2 values( 1 );
28 commit;
29 **** Mixed changes which should not be flushed to disk and so should not
30 **** increase either binlog_cache_disk_use or binlog_stmt_cache_disk_use.
31 **** Expected: binlog_cache_use = 3, binlog_cache_disk_use = 1.
32 **** Expected: binlog_stmt_cache_use = 2, binlog_stmt_cache_disk_use = 0.
33 begin;
34 insert into t1 values( 1 );
35 insert into t2 values( 1 );
36 commit;
37 **** Preparing the enviroment to check abort and its effect on the status variables.
38 **** Expected: binlog_cache_use = 0, binlog_cache_disk_use = 0.
39 **** Expected: binlog_stmt_cache_use = 0, binlog_stmt_cache_disk_use = 0.
40 flush global status;
41 **** Transactional changes which are long enough so they will be flushed to disk...
42 **** Expected: binlog_cache_use = 1, binlog_cache_disk_use = 1.
43 **** Expected: binlog_stmt_cache_use = 0, binlog_stmt_cache_disk_use = 0.
44 **** Transactional changes which should not be flushed to disk and so should not
45 **** increase either binlog_cache_disk_use or binlog_stmt_cache_disk_use.
46 **** Expected: binlog_cache_use = 2, binlog_cache_disk_use = 1.
47 **** Expected: binlog_stmt_cache_use = 0, binlog_stmt_cache_disk_use = 0.
48 begin;
49 insert into t1 values( 1 );
50 rollback;
51 **** Non-Transactional changes which should not be flushed to disk and so should not
52 **** increase either binlog_cache_disk_use or binlog_stmt_cache_disk_use.
53 **** Expected: binlog_cache_use = 2, binlog_cache_disk_use = 1.
54 **** Expected: binlog_stmt_cache_use = 1, binlog_stmt_cache_disk_use = 0.
55 begin;
56 insert into t2 values( 1 );
57 rollback;
58 Warnings:
59 Warning 1196 Some non-transactional changed tables couldn't be rolled back
60 **** Mixed changes which should not be flushed to disk and so should not
61 **** increase either binlog_cache_disk_use or binlog_stmt_cache_disk_use.
62 **** Expected: binlog_cache_use = 3, binlog_cache_disk_use = 1.
63 **** Expected: binlog_stmt_cache_use = 2, binlog_stmt_cache_disk_use = 0.
64 begin;
65 insert into t1 values( 1 );
66 insert into t2 values( 1 );
67 rollback;
68 Warnings:
69 Warning 1196 Some non-transactional changed tables couldn't be rolled back
70 drop table t1, t2;
71 set @@global.binlog_stmt_cache_size=@save_binlog_stmt_cache_size;
72 set @@global.binlog_cache_size=@save_binlog_cache_size;