1# test of group commit switching
2
3query:
4  select | insert | update| delete |
5  select | insert | update| delete |
6  select | insert | update| delete |
7  select | insert | update| delete |
8  select | insert | update| delete |
9  select | insert | update| delete |
10  select | insert | update| delete |
11  select | insert | update| delete |
12  select | insert | update| delete |
13  select | insert | update| delete |
14  select | insert | update| delete |
15  select | insert | update| delete |
16  select | insert | update| delete |
17  select | insert | update| delete |
18  select | insert | update| delete |
19  select | insert | update| delete |
20  select | insert | update| delete |
21  select | insert | update| delete |
22  select | insert | update| delete |
23  select | insert | update| delete |
24  select | insert | update| delete |
25  select | insert | update| delete |
26  select | insert | update| delete |
27  select | insert | update| delete |
28  select | insert | update| delete |
29  select | insert | update| delete |
30  select | insert | update| delete |
31  select | insert | update| delete |
32  select | insert | update| delete |
33  select | insert | update| delete |
34  select | insert | update| delete |
35  select | insert | update| delete |
36  select | insert | update| delete |
37  select | insert | update| delete |
38  select | insert | update| delete |
39  select | insert | update| delete |
40  select | insert | update| delete |
41  select | insert | update| delete |
42  select | insert | update| delete |
43  select | insert | update| delete |
44  select | insert | update| delete |
45  select | insert | update| delete |
46  select | insert | update| delete |
47  select | insert | update| delete |
48  select | insert | update| delete |
49  select | insert | update| delete |
50  select | insert | update| delete |
51  select | insert | update| delete |
52  select | insert | update| delete |
53  select | insert | update| delete |
54  select | insert | update| delete |
55  select | insert | update| delete |
56  select | insert | update| delete |
57  select | insert | update| delete |
58  select | insert | update| delete |
59  select | insert | update| delete |
60  select | insert | update| delete |
61  select | insert | update| delete |
62  select | insert | update| delete |
63  select | insert | update| delete |
64  select | insert | update| delete |
65  select | insert | update| delete |
66  select | insert | update| delete |
67  select | insert | update| delete |
68  select | insert | update| delete |
69  select | insert | update| delete |
70  select | insert | update| delete |
71  select | insert | update| delete |
72  select | insert | update| delete |
73  select | insert | update| delete |
74  select | insert | update| delete |
75  select | insert | update| delete |
76  select | insert | update| delete |
77  select | insert | update| delete |
78  select | insert | update| delete |
79  select | insert | update| delete |
80  select | insert | update| delete |
81  select | insert | update| delete |
82  select | insert | update| delete |
83  select | insert | update| delete |
84  select | insert | update| delete |
85  select | insert | update| delete |
86  select | insert | update| delete |
87  select | insert | update| delete |
88  select | insert | update| delete |
89  select | insert | update| delete |
90  select | insert | update| delete |
91  select | insert | update| delete |
92  select | insert | update| delete |
93  select | insert | update| delete |
94  select | insert | update| delete |
95  select | insert | update| delete |
96  select | insert | update| delete |
97  select | insert | update| delete |
98  select | insert | update| delete |
99  select | insert | update| delete |
100  select | insert | update| delete |
101  select | insert | update| delete |
102  select | insert | update| delete |
103  select | insert | update| delete |
104  select | insert | update| delete |
105  select | insert | update| delete |
106  select | insert | update| delete |
107  select | insert | update| delete |
108  select | insert | update| delete |
109  select | insert | update| delete |
110  select | insert | update| delete |
111  select | insert | update| delete |
112  select | insert | update| delete |
113  select | insert | update| delete |
114  select | insert | update| delete |
115  select | insert | update| delete |
116  select | insert | update| delete |
117  select | insert | update| delete |
118  select | insert | update| delete |
119  select | insert | update| delete |
120  select | insert | update| delete |
121  select | insert | update| delete |
122  select | insert | update| delete |
123  select | insert | update| delete |
124  change_group_commit | change_interval;
125
126
127select:
128	SELECT select_item FROM join where order_by limit;
129
130select_item:
131	* | X . _field ;
132
133join:
134	_table AS X |
135	_table AS X LEFT JOIN _table AS Y ON ( X . _field = Y . _field ) ;
136
137where:
138	|
139	WHERE X . _field < value |
140	WHERE X . _field > value |
141	WHERE X . _field = value ;
142
143where_delete:
144	|
145	WHERE _field < value |
146	WHERE _field > value |
147	WHERE _field = value ;
148
149order_by:
150	| ORDER BY X . _field ;
151
152limit:
153	| LIMIT _digit ;
154
155insert:
156	INSERT INTO _table ( _field , _field ) VALUES ( value , value ) ;
157
158update:
159	UPDATE _table AS X SET _field = value where order_by limit ;
160
161delete:
162	DELETE FROM _table where_delete LIMIT _digit ;
163
164value:
165	' _letter ' | _digit | _date | _datetime | _time | _english ;
166
167change_group_commit:
168        SET GLOBAL MARIA_GROUP_COMMIT=none_soft_hard;
169
170none_soft_hard:
171        NONE | SOFT | HARD;
172
173change_interval:
174     set_interval | set_interval | set_interval | set_interval |
175     drop_interval;
176
177set_interval:
178        SET GLOBAL MARIA_GROUP_COMMIT_INTERVAL=_tinyint_unsigned;
179
180drop_interval:
181        SET GLOBAL MARIA_GROUP_COMMIT_INTERVAL=0;
182