|
| 1 | +package main |
| 2 | + |
| 3 | +import ( |
| 4 | +"fmt" |
| 5 | +"flag" |
| 6 | +"os" |
| 7 | +"sync" |
| 8 | +"time" |
| 9 | +"github.com/jackc/pgx" |
| 10 | +) |
| 11 | + |
| 12 | +typeConnStrings []string |
| 13 | + |
| 14 | +varbackendinterface{ |
| 15 | +prepare(connstrs []string) |
| 16 | +writer(idint,cCommitschanint,cAbortschanint,wg*sync.WaitGroup) |
| 17 | +reader(wg*sync.WaitGroup,cFetcheschanint,inconsistency*bool) |
| 18 | +} |
| 19 | + |
| 20 | +varcfgstruct { |
| 21 | +ConnStrsConnStrings |
| 22 | +Backendstring |
| 23 | +Verbosebool |
| 24 | +UseDtmbool |
| 25 | +Initbool |
| 26 | +Parallelbool |
| 27 | +Isolationstring |
| 28 | +AccountsNumint |
| 29 | +ReadersNumint |
| 30 | +IterNumint |
| 31 | + |
| 32 | +Writersstruct { |
| 33 | +Numint |
| 34 | +StartIdint |
| 35 | + } |
| 36 | +} |
| 37 | + |
| 38 | +// The first method of flag.Value interface |
| 39 | +func (c*ConnStrings)String()string { |
| 40 | +iflen(*c)>0 { |
| 41 | +return (*c)[0] |
| 42 | + }else { |
| 43 | +return"" |
| 44 | + } |
| 45 | +} |
| 46 | + |
| 47 | +// The second method of flag.Value interface |
| 48 | +func (c*ConnStrings)Set(valuestring)error { |
| 49 | +*c=append(*c,value) |
| 50 | +returnnil |
| 51 | +} |
| 52 | + |
| 53 | +funcappend_with_comma(s*string,xstring) { |
| 54 | +iflen(*s)>0 { |
| 55 | +*s=*s+", "+x |
| 56 | + }else { |
| 57 | +*s=x |
| 58 | + } |
| 59 | +} |
| 60 | + |
| 61 | +funcdump_cfg() { |
| 62 | +fmt.Printf("Connections: %d\n",len(cfg.ConnStrs)) |
| 63 | +for_,cs:=rangecfg.ConnStrs { |
| 64 | +fmt.Printf(" %s\n",cs) |
| 65 | + } |
| 66 | +fmt.Printf("Isolation: %s\n",cfg.Isolation) |
| 67 | +fmt.Printf( |
| 68 | +"Accounts: %d × $%d\n", |
| 69 | +cfg.AccountsNum,0, |
| 70 | + ) |
| 71 | +fmt.Printf("Readers: %d\n",cfg.ReadersNum) |
| 72 | + |
| 73 | +fmt.Printf( |
| 74 | +"Writers: %d × %d updates\n", |
| 75 | +cfg.Writers.Num,cfg.IterNum, |
| 76 | + ) |
| 77 | +} |
| 78 | + |
| 79 | +funcinit() { |
| 80 | +flag.StringVar(&cfg.Backend,"b","transfers", |
| 81 | +"Backend to use. Default to 'transfers'") |
| 82 | +flag.Var(&cfg.ConnStrs,"C", |
| 83 | +"Connection string (repeat for multiple connections)") |
| 84 | +flag.BoolVar(&cfg.Init,"i",false, |
| 85 | +"Init database") |
| 86 | +flag.BoolVar(&cfg.UseDtm,"g",false, |
| 87 | +"Use DTM to keep global consistency") |
| 88 | +flag.IntVar(&cfg.AccountsNum,"a",100000, |
| 89 | +"The number of bank accounts") |
| 90 | +flag.IntVar(&cfg.Writers.StartId,"s",0, |
| 91 | +"StartID. Script will update rows starting from this value") |
| 92 | +flag.IntVar(&cfg.IterNum,"n",10000, |
| 93 | +"The number updates each writer (reader in case of Reades backend) performs") |
| 94 | +flag.IntVar(&cfg.ReadersNum,"r",1, |
| 95 | +"The number of readers") |
| 96 | +flag.IntVar(&cfg.Writers.Num,"w",8, |
| 97 | +"The number of writers") |
| 98 | +flag.BoolVar(&cfg.Verbose,"v",false, |
| 99 | +"Show progress and other stuff for mortals") |
| 100 | +flag.BoolVar(&cfg.Parallel,"p",false, |
| 101 | +"Use parallel execs") |
| 102 | +repread:=flag.Bool("l",false, |
| 103 | +"Use 'repeatable read' isolation level instead of 'read committed'") |
| 104 | +flag.Parse() |
| 105 | + |
| 106 | +iflen(cfg.ConnStrs)==0 { |
| 107 | +flag.PrintDefaults() |
| 108 | +os.Exit(1) |
| 109 | + } |
| 110 | + |
| 111 | +ifcfg.AccountsNum<2 { |
| 112 | +fmt.Println( |
| 113 | +"There should be at least 2 accounts (to avoid deadlocks)", |
| 114 | + ) |
| 115 | +os.Exit(1) |
| 116 | + } |
| 117 | + |
| 118 | +if*repread { |
| 119 | +cfg.Isolation="repeatable read" |
| 120 | + }else { |
| 121 | +cfg.Isolation="read committed" |
| 122 | + } |
| 123 | + |
| 124 | +dump_cfg() |
| 125 | +} |
| 126 | + |
| 127 | +funcmain() { |
| 128 | +iflen(cfg.ConnStrs)<2 { |
| 129 | +fmt.Println("ERROR: This test needs at leas two connections") |
| 130 | +os.Exit(1) |
| 131 | + } |
| 132 | + |
| 133 | +// switch cfg.Backend { |
| 134 | +// case "transfers": |
| 135 | +// backend = new(Transfers) |
| 136 | +// case "fdw": |
| 137 | +// backend = new(TransfersFDW) |
| 138 | +// case "readers": |
| 139 | +// backend = new(Readers) |
| 140 | +// case "pgshard": |
| 141 | +// backend = new(TransfersPgShard) |
| 142 | +// default: |
| 143 | +// fmt.Println("No backend named: '%s'\n", cfg.Backend) |
| 144 | +// return |
| 145 | +// } |
| 146 | +backend=new(TransfersTS) |
| 147 | + |
| 148 | +start:=time.Now() |
| 149 | + |
| 150 | +if (cfg.Init){ |
| 151 | +backend.prepare(cfg.ConnStrs) |
| 152 | +fmt.Printf("database prepared in %0.2f seconds\n",time.Since(start).Seconds()) |
| 153 | +return |
| 154 | + } |
| 155 | + |
| 156 | +varwriterWg sync.WaitGroup |
| 157 | +varreaderWg sync.WaitGroup |
| 158 | + |
| 159 | +cCommits:=make(chanint) |
| 160 | +cFetches:=make(chanint) |
| 161 | +cAborts:=make(chanint) |
| 162 | + |
| 163 | +goprogress(cfg.Writers.Num*cfg.IterNum,cCommits,cAborts) |
| 164 | + |
| 165 | +start=time.Now() |
| 166 | +writerWg.Add(cfg.Writers.Num) |
| 167 | +fori:=0;i<cfg.Writers.Num;i++ { |
| 168 | +gobackend.writer(i,cCommits,cAborts,&writerWg) |
| 169 | + } |
| 170 | +running=true |
| 171 | + |
| 172 | +inconsistency:=false |
| 173 | +readerWg.Add(cfg.ReadersNum) |
| 174 | +fori:=0;i<cfg.ReadersNum;i++ { |
| 175 | +gobackend.reader(&readerWg,cFetches,&inconsistency) |
| 176 | + } |
| 177 | + |
| 178 | +writerWg.Wait() |
| 179 | +running=false |
| 180 | +readerWg.Wait() |
| 181 | + |
| 182 | +fmt.Printf("writers finished in %0.2f seconds\n", |
| 183 | +time.Since(start).Seconds()) |
| 184 | +fmt.Printf("TPS = %0.2f\n", |
| 185 | +float64(cfg.Writers.Num*cfg.IterNum)/time.Since(start).Seconds()) |
| 186 | + |
| 187 | +ifinconsistency { |
| 188 | +fmt.Printf("INCONSISTENCY DETECTED\n") |
| 189 | + } |
| 190 | +fmt.Printf("done.\n") |
| 191 | +} |
| 192 | + |
| 193 | +varrunning=false |
| 194 | + |
| 195 | +funcasyncCommit(conn*pgx.Conn,wg*sync.WaitGroup) { |
| 196 | +exec(conn,"commit") |
| 197 | +wg.Done() |
| 198 | +} |
| 199 | + |
| 200 | +funccommit(conns...*pgx.Conn) { |
| 201 | +varwg sync.WaitGroup |
| 202 | +wg.Add(len(conns)) |
| 203 | +for_,conn:=rangeconns { |
| 204 | +goasyncCommit(conn,&wg) |
| 205 | + } |
| 206 | +wg.Wait() |
| 207 | +} |
| 208 | + |
| 209 | +funcparallel_exec(conns []*pgx.Conn,requests []string)bool { |
| 210 | +varwg sync.WaitGroup |
| 211 | +state:=true |
| 212 | +wg.Add(len(conns)) |
| 213 | +fori:=rangeconns { |
| 214 | +ifcfg.Parallel { |
| 215 | +gofunc(jint) { |
| 216 | +_,err:=conns[j].Exec(requests[j]) |
| 217 | +iferr!=nil { |
| 218 | +state=false |
| 219 | + } |
| 220 | +wg.Done() |
| 221 | + }(i) |
| 222 | + }else { |
| 223 | +_,err:=conns[i].Exec(requests[i]) |
| 224 | +iferr!=nil { |
| 225 | +state=false |
| 226 | + } |
| 227 | +wg.Done() |
| 228 | + } |
| 229 | + } |
| 230 | +wg.Wait() |
| 231 | +returnstate |
| 232 | +} |
| 233 | + |
| 234 | +funcprogress(totalint,cCommitschanint,cAbortschanint) { |
| 235 | +commits:=0 |
| 236 | +aborts:=0 |
| 237 | +start:=time.Now() |
| 238 | +fornewcommits:=rangecCommits { |
| 239 | +newaborts:=<-cAborts |
| 240 | +commits+=newcommits |
| 241 | +aborts+=newaborts |
| 242 | +iftime.Since(start).Seconds()>1 { |
| 243 | +ifcfg.Verbose { |
| 244 | +fmt.Printf( |
| 245 | +"progress %0.2f%%: %d commits, %d aborts\n", |
| 246 | +float32(commits)*100.0/float32(total),commits,aborts, |
| 247 | + ) |
| 248 | + } |
| 249 | +start=time.Now() |
| 250 | + } |
| 251 | + } |
| 252 | +} |
| 253 | + |
| 254 | +funcexec(conn*pgx.Conn,stmtstring,arguments...interface{}) { |
| 255 | +varerrerror |
| 256 | +// fmt.Println(stmt) |
| 257 | +_,err=conn.Exec(stmt,arguments... ) |
| 258 | +checkErr(err) |
| 259 | +} |
| 260 | + |
| 261 | +funcexecUpdate(conn*pgx.Conn,stmtstring,arguments...interface{})bool { |
| 262 | +varerrerror |
| 263 | +// fmt.Println(stmt) |
| 264 | +_,err=conn.Exec(stmt,arguments... ) |
| 265 | +//if err != nil { |
| 266 | +// fmt.Println(err) |
| 267 | +//} |
| 268 | +returnerr==nil |
| 269 | +} |
| 270 | + |
| 271 | +funcexecQuery(conn*pgx.Conn,stmtstring,arguments...interface{})int32 { |
| 272 | +varerrerror |
| 273 | +varresultint32 |
| 274 | +err=conn.QueryRow(stmt,arguments...).Scan(&result) |
| 275 | +checkErr(err) |
| 276 | +returnresult |
| 277 | +} |
| 278 | + |
| 279 | +funcexecQuery64(conn*pgx.Conn,stmtstring,arguments...interface{})int64 { |
| 280 | +varerrerror |
| 281 | +varresultint64 |
| 282 | +err=conn.QueryRow(stmt,arguments...).Scan(&result) |
| 283 | +checkErr(err) |
| 284 | +returnresult |
| 285 | +} |
| 286 | + |
| 287 | +funccheckErr(errerror) { |
| 288 | +iferr!=nil { |
| 289 | +panic(err) |
| 290 | + } |
| 291 | +} |
| 292 | + |
| 293 | +// vim: expandtab ts=4 sts=4 sw=4 |