tcp.sim 2.1 KB
Newer Older
S
slguan 已提交
1 2
system sh/stop_dnodes.sh

S
slguan 已提交
3
system sh/deploy.sh -n dnode1 -i 1
H
hjxilinx 已提交
4
system sh/cfg.sh -n dnode1 -c walLevel -v 0
S
slguan 已提交
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
system sh/cfg.sh -n dnode1 -c tables    -v 30000

system sh/cfg.sh -n dnode1 -c dDebugFlag      -v 131
system sh/cfg.sh -n dnode1 -c mDebugFlag      -v 131
system sh/cfg.sh -n dnode1 -c sdbDebugFlag    -v 131
system sh/cfg.sh -n dnode1 -c rpcDebugFlag   -v 131
system sh/cfg.sh -n dnode1 -c cDebugFlag      -v 131
system sh/cfg.sh -n dnode1 -c gcDebugFlag     -v 131
system sh/cfg.sh -n dnode1 -c adminDebugFlag  -v 131
system sh/cfg.sh -n dnode1 -c httpDebugFlag   -v 135
system sh/cfg.sh -n dnode1 -c debugFlag       -v 131

system sh/exec.sh -n dnode1 -s start

sql connect
print ======================== dnode1 start

$dbPrefix = db
$tbPrefix = tb
$mtPrefix = mt
$tbNum = 22000
$rowNum = 10

print =============== step1
$i = 0
$db = $dbPrefix
$mt = $mtPrefix

sql create database $db
sql use $db
sql create table $mt (ts timestamp, tbcol int, tbcol2 float) TAGS(tgcol int)

$i = 0
while $i < $tbNum
  $tb = $tbPrefix . $i
  sql create table $tb using $mt tags( $i )
  
  $i = $i + 1
endw 

print =============== step2
$i = 0
while $i < $tbNum
  $tb = $tbPrefix . $i
  sql insert into $tb values (now, $i , $i ) 
  
  $i = $i + 1000
endw 

$i = 0
while $i < 100
	print =============== step3 $i
	sql select count(*) from $mt
	print ===> $data00 $data01
	if $rows != 1 then 
	  return -1
	endi
	if $data00 != 22 then 
	  return -1
	endi

	print =============== step4 $i
	sql select * from $mt
	print ===> $data00 $data01
	if $rows != 22 then 
	  return -1
	endi
	
	$i = $i + 1
endw 

print =============== step3
$i = 0
while $i < $tbNum
  $tb = $tbPrefix . $i
  sql insert into $tb values (now, $i , $i ) 
  
  $i = $i + 1000
endw 

$i = 0
while $i < 100
	print =============== step5 $i
	sql select count(*) from $mt where tgcol < 20200
	print ===> $data00 $data01
	if $rows != 1 then 
	  return -1
	endi
	if $data00 != 42 then 
	  return -1
	endi

	print =============== step6 $i
	sql select * from $mt where tgcol < 20200
	print ===> $data00 $data01
	if $rows != 42 then 
	  return -1
	endi
	
	$i = $i + 1
endw 
system sh/stop_dnodes.sh
sleep 10000