Debian Codegraph @

mysql-test/suite/ndb_big/rqg_spj.test

raw
1 #
2 # RQG SPJ
3 #
4 --source include/have_ndb.inc
5 --source include/not_windows.inc
6 --source suite/ndb/include/have_ndb_rqg.inc
7
8 # Remember all SPJ conters when test started.
9 --disable_query_log
10 create temporary table spj_counts_at_startup
11 select counter_name, sum(val) as val
12 from ndbinfo.counters
13 where block_name='DBSPJ'
14 group by counter_name;
15 --enable_query_log
16
17 ##
18 # Load simple.zz
19 # -o => with "oj-extensions"
20 --echo Calling: $LOAD_RQG -d simple.zz -o
21 --exec bash -c "$LOAD_RQG -d simple.zz -o"
22
23 ##
24 # run spj_test.yy for 1800 seconds
25 #
26 # If you want to reproduce an "run"
27 # add -s <seed value> to command below
28 #
29 # NOTE: CluB get unhappy if a testcase doesnt print for 1800 seconds
30 # So call program several times instead
31 # (having --exec print as it goes would also be nice...instead of
32 # just at the end)
33 #
34 let $cmd = $RUN_RQG -g spj_test.yy -t 600;
35 --echo Calling: $cmd (3 times)
36 --exec bash -c "$cmd"
37 --exec bash -c "$cmd"
38 --exec bash -c "$cmd"
39
40 drop database spj_innodb;
41 drop database spj_ndb;
42
43 --disable_query_log
44 create temporary table spj_counts_at_end
45 select counter_name, sum(val) as val
46 from ndbinfo.counters
47 where block_name='DBSPJ'
48 group by counter_name;
49
50 select spj_counts_at_end.counter_name,
51 spj_counts_at_end.val - spj_counts_at_startup.val
52 from spj_counts_at_startup, spj_counts_at_end
53 where spj_counts_at_startup.counter_name = spj_counts_at_end.counter_name;
54 --enable_query_log
55
56 exit;