Debian Codegraph @

mysql-test/suite/maria/group_commit.test

raw
1 # Test different ways of syncing (mostly syntax)
2 --source include/have_maria.inc
3
4 --disable_warnings
5 drop table if exists t1;
6 --enable_warnings
7
8 create table t1 (a int);
9
10 SET GLOBAL aria_group_commit="NONE";
11 SET GLOBAL aria_group_commit_interval= 0;
12 --disable_query_log
13 let $num = 5000;
14 while ($num)
15 {
16 insert into t1 values (1);
17 dec $num;
18 }
19 --enable_query_log
20 SET GLOBAL aria_group_commit="NONE";
21 SET GLOBAL aria_group_commit_interval= 100;
22 --disable_query_log
23 let $num = 5000;
24 while ($num)
25 {
26 insert into t1 values (1);
27 dec $num;
28 }
29 --enable_query_log
30 SET GLOBAL aria_group_commit="HARD";
31 SET GLOBAL aria_group_commit_interval= 0;
32 --disable_query_log
33 let $num = 5000;
34 while ($num)
35 {
36 insert into t1 values (1);
37 dec $num;
38 }
39 --enable_query_log
40 SET GLOBAL aria_group_commit="HARD";
41 SET GLOBAL aria_group_commit_interval= 100;
42 --disable_query_log
43 let $num = 5000;
44 while ($num)
45 {
46 insert into t1 values (1);
47 dec $num;
48 }
49 --enable_query_log
50 SET GLOBAL aria_group_commit="SOFT";
51 SET GLOBAL aria_group_commit_interval= 0;
52 --disable_query_log
53 let $num = 5000;
54 while ($num)
55 {
56 insert into t1 values (1);
57 dec $num;
58 }
59 --enable_query_log
60 SET GLOBAL aria_group_commit="SOFT";
61 SET GLOBAL aria_group_commit_interval= 100;
62 --disable_query_log
63 let $num = 5000;
64 while ($num)
65 {
66 insert into t1 values (1);
67 dec $num;
68 }
69 --enable_query_log
70 SET GLOBAL aria_group_commit="NONE";
71 SET GLOBAL aria_group_commit_interval= 0;
72 drop table t1;