57 lines
1.5 KiB
Plaintext
57 lines
1.5 KiB
Plaintext
#
|
|
# RQG SPJ
|
|
#
|
|
--source include/have_ndb.inc
|
|
--source include/not_windows.inc
|
|
--source suite/ndb/include/have_ndb_rqg.inc
|
|
|
|
# Remember all SPJ conters when test started.
|
|
--disable_query_log
|
|
create temporary table spj_counts_at_startup
|
|
select counter_name, sum(val) as val
|
|
from ndbinfo.counters
|
|
where block_name='DBSPJ'
|
|
group by counter_name;
|
|
--enable_query_log
|
|
|
|
##
|
|
# Load simple.zz
|
|
# -o => with "oj-extensions"
|
|
--echo Calling: $LOAD_RQG -d simple.zz -o
|
|
--exec bash -c "$LOAD_RQG -d simple.zz -o"
|
|
|
|
##
|
|
# run spj_test.yy for 1800 seconds
|
|
#
|
|
# If you want to reproduce an "run"
|
|
# add -s <seed value> to command below
|
|
#
|
|
# NOTE: CluB get unhappy if a testcase doesnt print for 1800 seconds
|
|
# So call program several times instead
|
|
# (having --exec print as it goes would also be nice...instead of
|
|
# just at the end)
|
|
#
|
|
let $cmd = $RUN_RQG -g spj_test.yy -t 600;
|
|
--echo Calling: $cmd (3 times)
|
|
--exec bash -c "$cmd"
|
|
--exec bash -c "$cmd"
|
|
--exec bash -c "$cmd"
|
|
|
|
drop database spj_innodb;
|
|
drop database spj_ndb;
|
|
|
|
--disable_query_log
|
|
create temporary table spj_counts_at_end
|
|
select counter_name, sum(val) as val
|
|
from ndbinfo.counters
|
|
where block_name='DBSPJ'
|
|
group by counter_name;
|
|
|
|
select spj_counts_at_end.counter_name,
|
|
spj_counts_at_end.val - spj_counts_at_startup.val
|
|
from spj_counts_at_startup, spj_counts_at_end
|
|
where spj_counts_at_startup.counter_name = spj_counts_at_end.counter_name;
|
|
--enable_query_log
|
|
|
|
exit;
|