oceanbase

1
alter system minor freeze;
2
--disable_query_log
3
--disable_result_log
4

5
let $__i__=180;
6
let $__j__ = 10;
7
while($__i__ > 0)
8
{
9
  sleep 1;
10
  dec $__i__;
11
  dec $__j__;
12

13
  if ($TENANT == 'mysql') {
14
    let $__memstore_cnt__ = query_get_value(select count(*) as cnt from oceanbase.__all_virtual_memstore_info where tablet_id >= 200000, cnt, 1);
15
  }
16
  if ($TENANT == 'oracle') {
17
    select count(*) into @cnt from SYS.gv$ob_memstore_info where tablet_id >= 200000;
18
    let $__memstore_cnt__ = query_get_value(select @cnt as RES from dual, RES, 1);
19
    # --echo $__memstore_cnt__
20
  }
21

22
  if ($__memstore_cnt__ == 0)
23
  {
24
    let $__i__ = -5;
25
  }
26
  if ($__j__ == 0)
27
  {
28
   alter system minor freeze;
29
   let $__j__ = 10;
30
  }
31
}
32

33
if ($__i__ != -5)
34
{
35
  --echo minor freeze failed
36
}
37

38
--enable_query_log
39
--enable_result_log
40