event store benchmark results

gistfile1.txt

mysql: set up event store tables on database event_store_tests
mariadb: set up event store tables on database event_store_tests
postgres: set up event store tables on database event_store_tests
arangodb: set up event store tables on database _system

test 1 create 10 streams with 100 events in each stream, using 1 event per commit

test 1 using mysql took 9.0940508842468 seconds
test 1 using mysql writes 109.9619974342 events per second

test 1 using mariadb took 16.8031001091 seconds
test 1 using mariadb writes 59.512827603664 events per second

test 1 using postgres took 4.5961301326752 seconds
test 1 using postgres writes 217.5743443143 events per second

test 1 using arangodb took 1.2434499263763 seconds
test 1 using arangodb writes 804.21412940543 events per second

test 2 create 10 streams with 100 events in each stream, using 5 events per commit

test 2 using mysql took 2.2770571708679 seconds
test 2 using mysql writes 439.16332571432 events per second

test 2 using mariadb took 3.4162888526917 seconds
test 2 using mariadb writes 292.7152951988 events per second

test 2 using postgres took 1.1834828853607 seconds
test 2 using postgres writes 844.96363434542 events per second

test 2 using arangodb took 0.84084296226501 seconds
test 2 using arangodb writes 1189.2827137499 events per second

test 3 create one stream with 2500 events using a single commit

test 3 using mysql took 0.74085307121277 seconds
test 3 using mysql writes 3374.4882718884 events per second

test 3 using mariadb took 0.66708397865295 seconds
test 3 using mariadb writes 3747.6540885426 events per second

test 3 using postgres took 0.21832013130188 seconds
test 3 using postgres writes 11451.074095147 events per second

test 3 using arangodb took 0.26161789894104 seconds
test 3 using arangodb writes 9555.9210975982 events per second

test 4 load one stream with 2500 events

test 4 using mysql took 0.021610975265503 seconds
test 4 using mysql loads 115681.96110014 events per second

test 4 using mariadb took 0.0096771717071533 seconds
test 4 using mariadb loads 258339.94431989 events per second

test 4 using postgres took 0.013469934463501 seconds
test 4 using postgres loads 185598.52735543 events per second

test 4 using arangodb took 0.033054113388062 seconds
test 4 using arangodb loads 75633.551886554 events per second

test 5 project 1 stream with 2500 events

test 5 using mysql took 0.19454193115234 seconds
test 5 using mysql loads 12850.700027452 events per second

test 5 using mariadb took 0.22444796562195 seconds
test 5 using mariadb loads 11138.439116935 events per second

test 5 using postgres took 0.14403295516968 seconds
test 5 using postgres loads 17357.138837115 events per second

test 5 using arangodb took 0.1021831035614 seconds
test 5 using arangodb loads 24465.8844062 events per second

test 6 project 10 stream with 100 events

test 6 using mysql took 0.19079518318176 seconds
test 6 using mysql loads 5241.222463396 events per second

test 6 using mariadb took 0.21265411376953 seconds
test 6 using mariadb loads 4702.4719262369 events per second

test 6 using postgres took 0.16301703453064 seconds
test 6 using postgres loads 6134.3282490643 events per second

test 6 using arangodb took 0.14921498298645 seconds
test 6 using arangodb loads 6701.7398654317 events per second

test 7 real world test

mysql: destroying event-store tables on database event_store_tests
mysql: set up event store tables on database event_store_tests
mariadb: destroying event-store tables on database event_store_tests
mariadb: set up event store tables on database event_store_tests
postgres: destroying event-store tables on database event_store_tests
postgres: set up event store tables on database event_store_tests
arangodb: destroying event-store tables on database _system
arangodb: set up event store tables on database _system

starting benchmarks for mysql

Writer 140428045186816 started
Writer 140428030506752 started
Writer 140428015826688 started
Writer 140428001146624 started
Writer 140427780945664 started
Writer 140427772552960 started
Writer 140427757876992 started
Writer 140427743196928 started
Writer 140427728516864 started
Writer 140427311183616 started
Writer 140427296503552 started
Writer 140427281823488 started
Writer 140427267143424 started
Writer 140427042748160 started
Writer 140427034355456 started
Writer 140427025962752 started
Writer 140427011290880 started
Writer 140426996610816 started
Writer 140426572986112 started
Writer 140426564593408 started
Writer 140426552014592 started
Writer 140426537334528 started
Writer 140426522654464 started
Writer 140426170332928 started
Writer 140426157750016 started
Writer 140426143069952 started
Writer 140426128389888 started
Writer 140426113709824 started
Writer 140425763485440 started
Writer 140425748805376 started
Writer 140425734125312 started
Writer 140425719445248 started
Writer 140425499244288 started
Writer 140425490851584 started
Writer 140425476175616 started
Writer 140425461495552 started
Writer 140425446815488 started
Writer 140425432135424 started
Writer 140425417455360 started
Writer 140425402775296 started
Writer 140425388095232 started
Writer 140425358735104 started
Writer 140425373415168 started
Writer 140425344055040 started
Writer 140425329374976 started
Writer 140425314694912 started
Writer 140425300014848 started
Writer 140425285334784 started
Writer 140425255974656 started
Writer 140425270654720 started
Projection 140425241294592 started
Projection 140425226614528 started
Projection 140425211934464 started
Projection 140425197254400 started
Projection 140425182574336 started
Projection 140425167894272 started
Writer 140425358735104 wrote 250 events
Writer 140425358735104 used 171.90653014183 seconds, avg 1.4542786698896 events/second
Writer 140425763485440 wrote 250 events
Writer 140425763485440 used 172.29638385773 seconds, avg 1.4509880846161 events/second
Writer 140428030506752 wrote 250 events
Writer 140428030506752 used 174.33182001114 seconds, avg 1.4340468652483 events/second
Writer 140426996610816 wrote 250 events
Writer 140426996610816 used 180.12678718567 seconds, avg 1.3879112813038 events/second
Writer 140427034355456 wrote 250 events
Writer 140427034355456 used 181.12749195099 seconds, avg 1.3802432601874 events/second
Writer 140428045186816 wrote 250 events
Writer 140428045186816 used 184.88314390182 seconds, avg 1.3522054781411 events/second
Writer 140425388095232 wrote 250 events
Writer 140425388095232 used 184.69342684746 seconds, avg 1.3535944633616 events/second
Writer 140426157750016 wrote 250 events
Writer 140426157750016 used 185.96617913246 seconds, avg 1.3443304646375 events/second
Writer 140425285334784 wrote 250 events
Writer 140425285334784 used 187.01904606819 seconds, avg 1.3367622456423 events/second
Writer 140425748805376 wrote 250 events
Writer 140425748805376 used 187.58422613144 seconds, avg 1.3327346608815 events/second
Writer 140427267143424 wrote 250 events
Writer 140427267143424 used 190.52449083328 seconds, avg 1.3121672647259 events/second
Writer 140428001146624 wrote 250 events
Writer 140428001146624 used 190.74707818031 seconds, avg 1.3106360652281 events/second
Writer 140425432135424 wrote 250 events
Writer 140425432135424 used 191.94845890999 seconds, avg 1.3024329625758 events/second
Writer 140427025962752 wrote 250 events
Writer 140427025962752 used 192.88456296921 seconds, avg 1.2961120172168 events/second
Writer 140425476175616 wrote 250 events
Writer 140425476175616 used 193.2528989315 seconds, avg 1.2936416549622 events/second
Writer 140425373415168 wrote 250 events
Writer 140425373415168 used 193.44642305374 seconds, avg 1.2923474937066 events/second
Writer 140427743196928 wrote 250 events
Writer 140427743196928 used 196.06806993484 seconds, avg 1.2750673788092 events/second
Writer 140425314694912 wrote 250 events
Writer 140425314694912 used 196.13861989975 seconds, avg 1.2746087442023 events/second
Writer 140427296503552 wrote 250 events
Writer 140427296503552 used 197.2418179512 seconds, avg 1.2674796987617 events/second
Writer 140425461495552 wrote 250 events
Writer 140425461495552 used 197.23911690712 seconds, avg 1.2674970559604 events/second
Writer 140426170332928 wrote 250 events
Writer 140426170332928 used 197.94440603256 seconds, avg 1.2629808793832 events/second
Writer 140425329374976 wrote 250 events
Writer 140425329374976 used 198.80121207237 seconds, avg 1.257537604494 events/second
Writer 140426564593408 wrote 250 events
Writer 140426564593408 used 199.33144402504 seconds, avg 1.2541924894127 events/second
Writer 140425490851584 wrote 250 events
Writer 140425490851584 used 199.25009918213 seconds, avg 1.2547045197277 events/second
Writer 140425734125312 wrote 250 events
Writer 140425734125312 used 199.59436702728 seconds, avg 1.252540358345 events/second
Writer 140425417455360 wrote 250 events
Writer 140425417455360 used 200.62458491325 seconds, avg 1.246108497162 events/second
Writer 140426143069952 wrote 250 events
Writer 140426143069952 used 200.88767910004 seconds, avg 1.2444765210091 events/second
Writer 140425300014848 wrote 250 events
Writer 140425300014848 used 201.57418513298 seconds, avg 1.2402381774981 events/second
Writer 140427281823488 wrote 250 events
Writer 140427281823488 used 202.04932999611 seconds, avg 1.2373215986651 events/second
Writer 140427311183616 wrote 250 events
Writer 140427311183616 used 202.97911500931 seconds, avg 1.2316538082676 events/second
Writer 140425344055040 wrote 250 events
Writer 140425344055040 used 203.49301195145 seconds, avg 1.2285434158282 events/second
Writer 140426522654464 wrote 250 events
Writer 140426522654464 used 203.89493584633 seconds, avg 1.2261216737056 events/second
Writer 140427011290880 wrote 250 events
Writer 140427011290880 used 204.15315198898 seconds, avg 1.2245708555775 events/second
Writer 140426128389888 wrote 250 events
Writer 140426128389888 used 204.54967498779 seconds, avg 1.222197004297 events/second
Writer 140426113709824 wrote 250 events
Writer 140426113709824 used 204.66095709801 seconds, avg 1.2215324483227 events/second
Writer 140428015826688 wrote 250 events
Writer 140428015826688 used 204.96211695671 seconds, avg 1.2197375969375 events/second
Writer 140426537334528 wrote 250 events
Writer 140426537334528 used 204.86330103874 seconds, avg 1.2203259379908 events/second
Writer 140427757876992 wrote 250 events
Writer 140427757876992 used 205.43946409225 seconds, avg 1.2169034859229 events/second
Writer 140427728516864 wrote 250 events
Writer 140427728516864 used 206.16009402275 seconds, avg 1.2126498155963 events/second
Writer 140427772552960 wrote 250 events
Writer 140427772552960 used 206.20059514046 seconds, avg 1.212411631643 events/second
Writer 140427780945664 wrote 250 events
Writer 140427780945664 used 207.42367196083 seconds, avg 1.2052626281113 events/second
Writer 140425402775296 wrote 250 events
Writer 140425402775296 used 207.17487597466 seconds, avg 1.2067100261259 events/second
Writer 140425499244288 wrote 250 events
Writer 140425499244288 used 207.85501813889 seconds, avg 1.2027614355356 events/second
Writer 140425446815488 wrote 250 events
Writer 140425446815488 used 208.05092597008 seconds, avg 1.2016288744418 events/second
Writer 140426552014592 wrote 250 events
Writer 140426552014592 used 208.16070199013 seconds, avg 1.2009951811743 events/second
Writer 140426572986112 wrote 250 events
Writer 140426572986112 used 208.20310282707 seconds, avg 1.200750596919 events/second
Writer 140425719445248 wrote 250 events
Writer 140425719445248 used 208.57579803467 seconds, avg 1.1986050268327 events/second
Writer 140425255974656 wrote 250 events
Writer 140425255974656 used 209.15841221809 seconds, avg 1.1952662928963 events/second
Writer 140427042748160 wrote 250 events
Writer 140427042748160 used 209.72630310059 seconds, avg 1.1920297850294 events/second
Writer 140425270654720 wrote 250 events
Writer 140425270654720 used 209.4846739769 seconds, avg 1.1934047262454 events/second
Projection 140425211934464 read 2500 events
projection 140425211934464 used 210.44271183014 seconds, avg 11.879717659302 events/second
Projection 140425226614528 read 2500 events
projection 140425226614528 used 210.50798606873 seconds, avg 11.876034000837 events/second
Projection 140425197254400 read 2500 events
projection 140425197254400 used 210.51243400574 seconds, avg 11.875783070998 events/second
Projection 140425241294592 read 2500 events
projection 140425241294592 used 210.58533716202 seconds, avg 11.871671758782 events/second
Projection 140425182574336 read 2500 events
projection 140425182574336 used 210.64019918442 seconds, avg 11.86857973777 events/second
Projection 140425167894272 read 12500 events
projection 140425167894272 used 212.49691987038 seconds, avg 58.824382055161 events/second

done.
mysql avg writes 59.572890797728 events/second
mysql avg reads 117.62669305421 events/second

starting benchmarks for mariadb

Writer 140425167894272 started
Writer 140425182574336 started
Writer 140425197254400 started
Writer 140425211934464 started
Writer 140428028409600 started
Writer 140428013729536 started
Writer 140427999049472 started
Writer 140427780945664 started
Writer 140427768362752 started
Writer 140427753682688 started
Writer 140427739002624 started
Writer 140427724322560 started
Writer 140427306989312 started
Writer 140427292309248 started
Writer 140427277629184 started
Writer 140427262949120 started
Writer 140427042748160 started
Writer 140427034355456 started
Writer 140427019679488 started
Writer 140427004999424 started
Writer 140426990319360 started
Writer 140426572986112 started
Writer 140426558306048 started
Writer 140426543625984 started
Writer 140426528945920 started
Writer 140426170332928 started
Writer 140426161940224 started
Writer 140426153547520 started
Writer 140426138875648 started
Writer 140426124195584 started
Writer 140425767679744 started
Writer 140425759287040 started
Writer 140425746708224 started
Writer 140425732028160 started
Writer 140425717348096 started
Writer 140425499244288 started
Writer 140425486661376 started
Writer 140425471981312 started
Writer 140425457301248 started
Writer 140425442621184 started
Writer 140425427941120 started
Writer 140425413261056 started
Writer 140425398580992 started
Writer 140425383900928 started
Writer 140425369220864 started
Writer 140425354540800 started
Writer 140425339860736 started
Writer 140425325180672 started
Writer 140425310500608 started
Writer 140425295820544 started
Projection 140425281140480 started
Projection 140425266460416 started
Projection 140425251780352 started
Projection 140425237100288 started
Projection 140425222420224 started
Projection 140425159501568 started
Writer 140425295820544 wrote 250 events
Writer 140425295820544 used 182.90585494041 seconds, avg 1.3668233861701 events/second
Writer 140425499244288 wrote 250 events
Writer 140425499244288 used 185.81258797646 seconds, avg 1.3454416771359 events/second
Writer 140427739002624 wrote 250 events
Writer 140427739002624 used 190.32280898094 seconds, avg 1.3135577461188 events/second
Writer 140426170332928 wrote 250 events
Writer 140426170332928 used 190.63529396057 seconds, avg 1.3114045925394 events/second
Writer 140426161940224 wrote 250 events
Writer 140426161940224 used 191.17618703842 seconds, avg 1.307694247243 events/second
Writer 140427753682688 wrote 250 events
Writer 140427753682688 used 194.36041092873 seconds, avg 1.2862701761403 events/second
Writer 140425325180672 wrote 250 events
Writer 140425325180672 used 195.61762309074 seconds, avg 1.2780034643608 events/second
Writer 140427306989312 wrote 250 events
Writer 140427306989312 used 196.35673308372 seconds, avg 1.2731929079987 events/second
Writer 140426153547520 wrote 250 events
Writer 140426153547520 used 197.22033500671 seconds, avg 1.2676177636119 events/second
Writer 140425471981312 wrote 250 events
Writer 140425471981312 used 197.33389496803 seconds, avg 1.2668882861735 events/second
Writer 140427042748160 wrote 250 events
Writer 140427042748160 used 198.18039488792 seconds, avg 1.2614769495307 events/second
Writer 140426990319360 wrote 250 events
Writer 140426990319360 used 198.65469479561 seconds, avg 1.258465098231 events/second
Writer 140425413261056 wrote 250 events
Writer 140425413261056 used 198.42892313004 seconds, avg 1.2598969749796 events/second
Writer 140425369220864 wrote 250 events
Writer 140425369220864 used 198.37987017632 seconds, avg 1.2602085069307 events/second
Writer 140428028409600 wrote 250 events
Writer 140428028409600 used 199.3659799099 seconds, avg 1.2539752274334 events/second
Writer 140425732028160 wrote 250 events
Writer 140425732028160 used 199.54129695892 seconds, avg 1.2528734843869 events/second
Writer 140425717348096 wrote 250 events
Writer 140425717348096 used 199.8351418972 seconds, avg 1.2510312131617 events/second
Writer 140427019679488 wrote 250 events
Writer 140427019679488 used 200.53638315201 seconds, avg 1.2466565720919 events/second
Writer 140425746708224 wrote 250 events
Writer 140425746708224 used 200.31137108803 seconds, avg 1.2480569557389 events/second
Writer 140425759287040 wrote 250 events
Writer 140425759287040 used 200.97069096565 seconds, avg 1.2439624842745 events/second
Writer 140427999049472 wrote 250 events
Writer 140427999049472 used 201.84606814384 seconds, avg 1.2385675990569 events/second
Writer 140427768362752 wrote 250 events
Writer 140427768362752 used 201.82068490982 seconds, avg 1.2387233752165 events/second
Writer 140426543625984 wrote 250 events
Writer 140426543625984 used 203.0628349781 seconds, avg 1.2311460146164 events/second
Writer 140427262949120 wrote 250 events
Writer 140427262949120 used 203.32641196251 seconds, avg 1.2295500500255 events/second
Writer 140425427941120 wrote 250 events
Writer 140425427941120 used 202.91433310509 seconds, avg 1.2320470228711 events/second
Writer 140425767679744 wrote 250 events
Writer 140425767679744 used 203.3602809906 seconds, avg 1.2293452722538 events/second
Writer 140427292309248 wrote 250 events
Writer 140427292309248 used 203.64944005013 seconds, avg 1.2275997416858 events/second
Writer 140425457301248 wrote 250 events
Writer 140425457301248 used 203.27300310135 seconds, avg 1.229873107524 events/second
Writer 140426124195584 wrote 250 events
Writer 140426124195584 used 204.00789809227 seconds, avg 1.225442751667 events/second
Writer 140425486661376 wrote 250 events
Writer 140425486661376 used 203.96746897697 seconds, avg 1.2256856510203 events/second
Writer 140425354540800 wrote 250 events
Writer 140425354540800 used 203.88265419006 seconds, avg 1.226195533863 events/second
Writer 140426138875648 wrote 250 events
Writer 140426138875648 used 204.39891982079 seconds, avg 1.2230984401444 events/second
Writer 140425197254400 wrote 250 events
Writer 140425197254400 used 204.89109492302 seconds, avg 1.2201603983518 events/second
Writer 140425383900928 wrote 250 events
Writer 140425383900928 used 204.28599214554 seconds, avg 1.2237745592556 events/second
Writer 140427004999424 wrote 250 events
Writer 140427004999424 used 205.03297400475 seconds, avg 1.2193160695909 events/second
Writer 140425182574336 wrote 250 events
Writer 140425182574336 used 205.44674515724 seconds, avg 1.2168603586718 events/second
Writer 140425398580992 wrote 250 events
Writer 140425398580992 used 205.63933610916 seconds, avg 1.2157207114659 events/second
Writer 140426528945920 wrote 250 events
Writer 140426528945920 used 206.49059891701 seconds, avg 1.2107088715476 events/second
Writer 140425211934464 wrote 250 events
Writer 140425211934464 used 206.97688817978 seconds, avg 1.207864328228 events/second
Writer 140425310500608 wrote 250 events
Writer 140425310500608 used 206.19903087616 seconds, avg 1.2124208292237 events/second
Writer 140428013729536 wrote 250 events
Writer 140428013729536 used 207.30675506592 seconds, avg 1.2059423723096 events/second
Writer 140427034355456 wrote 250 events
Writer 140427034355456 used 207.65683817863 seconds, avg 1.2039093062996 events/second
Writer 140427277629184 wrote 250 events
Writer 140426558306048 wrote 250 events
Writer 140427277629184 used 207.83526301384 seconds, avg 1.2028757602282 events/second
Writer 140426558306048 used 207.68942403793 seconds, avg 1.2037204164731 events/second
Writer 140427780945664 wrote 250 events
Writer 140426572986112 wrote 250 events
Writer 140426572986112 used 208.03542399406 seconds, avg 1.2017184150673 events/second
Writer 140427780945664 used 208.27432203293 seconds, avg 1.2003400013972 events/second
Writer 140425167894272 wrote 250 events
Writer 140425167894272 used 208.51213788986 seconds, avg 1.1989709689325 events/second
Writer 140425442621184 wrote 250 events
Writer 140425442621184 used 207.82077503204 seconds, avg 1.2029596173022 events/second
Writer 140427724322560 wrote 250 events
Writer 140427724322560 used 208.9191801548 seconds, avg 1.1966349849485 events/second
Writer 140425339860736 wrote 250 events
Writer 140425339860736 used 208.6711499691 seconds, avg 1.198057326262 events/second
Error 22001. 
Error-Info: Data too long for column 'position' at row 1
#0 /home/sasa/code/event-store-benchmarks/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(827): Prooph\EventStore\Pdo\Exception\RuntimeException::fromStatementErrorInfo(Array)
#1 /home/sasa/code/event-store-benchmarks/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(583): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->persist()
#2 /home/sasa/code/event-store-benchmarks/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(488): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->handleStreamWithSingleHandler('blog-c2006fd8-c...', Object(Prooph\EventStore\Pdo\PdoStreamIterator))
#3 /home/sasa/code/event-store-benchmarks/src/AllProjector.php(48): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->run()
#4 [internal function]: Prooph\EventStoreBenchmarks\AllProjector->run()
#5 {main}Projection 140425237100288 read 2500 events
projection 140425237100288 used 209.63512301445 seconds, avg 11.925482543437 events/second
Projection 140425251780352 read 2500 events
projection 140425251780352 used 209.73382997513 seconds, avg 11.919870057665 events/second
Projection 140425281140480 read 2500 events
projection 140425281140480 used 209.80582690239 seconds, avg 11.915779637346 events/second
Projection 140425222420224 read 2500 events
projection 140425222420224 used 209.90343403816 seconds, avg 11.910238684068 events/second
Projection 140425266460416 read 2500 events
projection 140425266460416 used 209.98513793945 seconds, avg 11.905604484832 events/second

done.
mariadb avg writes 59.67114437551 events/second
mariadb avg reads 119.03224114374 events/second

starting benchmarks for postgres

Writer 140425159501568 started
Writer 140425222420224 started
Writer 140425237100288 started
Writer 140425251780352 started
Writer 140428028409600 started
Writer 140428013729536 started
Writer 140427780945664 started
Writer 140427999049472 started
Writer 140427768362752 started
Writer 140427753682688 started
Writer 140427739002624 started
Writer 140427724322560 started
Writer 140427306989312 started
Writer 140427292309248 started
Writer 140427277629184 started
Writer 140427262949120 started
Writer 140427042748160 started
Writer 140427034355456 started
Writer 140427019679488 started
Writer 140427004999424 started
Writer 140426990319360 started
Writer 140426572986112 started
Writer 140426558306048 started
Writer 140426543625984 started
Writer 140426528945920 started
Writer 140426170332928 started
Writer 140426161940224 started
Writer 140426153547520 started
Writer 140426138875648 started
Writer 140426124195584 started
Writer 140425767679744 started
Writer 140425759287040 started
Writer 140425746708224 started
Writer 140425732028160 started
Writer 140425717348096 started
Writer 140425499244288 started
Writer 140425486661376 started
Writer 140425471981312 started
Writer 140425457301248 started
Writer 140425442621184 started
Writer 140425427941120 started
Writer 140425413261056 started
Writer 140425398580992 started
Writer 140425383900928 started
Writer 140425369220864 started
Writer 140425354540800 started
Writer 140425339860736 started
Writer 140425325180672 started
Writer 140425310500608 started
Writer 140425295820544 started
Projection 140425281140480 started
Projection 140425266460416 started
Projection 140425214027520 started
Projection 140425205634816 started
Projection 140425197242112 started
Projection 140425182574336 started
Writer 140425159501568 wrote 250 events
Writer 140425159501568 used 5.6546890735626 seconds, avg 44.211095738018 events/second
Writer 140428028409600 wrote 250 events
Writer 140428028409600 used 5.626767873764 seconds, avg 44.430480447874 events/second
Writer 140425251780352 wrote 250 events
Writer 140425251780352 used 5.7314960956573 seconds, avg 43.618628683952 events/second
Writer 140427753682688 wrote 250 events
Writer 140427753682688 used 5.6731078624725 seconds, avg 44.067556277881 events/second
Writer 140425237100288 wrote 250 events
Writer 140425237100288 used 5.8674440383911 seconds, avg 42.607990526068 events/second
Writer 140425222420224 wrote 250 events
Writer 140425222420224 used 5.9064748287201 seconds, avg 42.326431120028 events/second
Writer 140427739002624 wrote 250 events
Writer 140427739002624 used 5.7462930679321 seconds, avg 43.50630868362 events/second
Writer 140427292309248 wrote 250 events
Writer 140427292309248 used 5.6777279376984 seconds, avg 44.031697669076 events/second
Writer 140427999049472 wrote 250 events
Writer 140427999049472 used 5.9350430965424 seconds, avg 42.122693286868 events/second
Writer 140427780945664 wrote 250 events
Writer 140427780945664 used 5.954528093338 seconds, avg 41.984855236421 events/second
Writer 140427768362752 wrote 250 events
Writer 140427768362752 used 5.960128068924 seconds, avg 41.945407398794 events/second
Writer 140428013729536 wrote 250 events
Writer 140428013729536 used 6.0309159755707 seconds, avg 41.453072968131 events/second
Writer 140427724322560 wrote 250 events
Writer 140427724322560 used 5.9956798553467 seconds, avg 41.696689288215 events/second
Writer 140427262949120 wrote 250 events
Writer 140427262949120 used 5.8440937995911 seconds, avg 42.778231933494 events/second
Writer 140427306989312 wrote 250 events
Writer 140427306989312 used 6.0489161014557 seconds, avg 41.329718549053 events/second
Writer 140427042748160 wrote 250 events
Writer 140427042748160 used 5.9478099346161 seconds, avg 42.03227788854 events/second
Writer 140427019679488 wrote 250 events
Writer 140427019679488 used 5.9325890541077 seconds, avg 42.140117530457 events/second
Writer 140427277629184 wrote 250 events
Writer 140427277629184 used 6.1147100925446 seconds, avg 40.885012734261 events/second
Writer 140426543625984 wrote 250 events
Writer 140426543625984 used 5.8107731342316 seconds, avg 43.023534773236 events/second
Writer 140426572986112 wrote 250 events
Writer 140426572986112 used 5.9393410682678 seconds, avg 42.092211429931 events/second
Writer 140426161940224 wrote 250 events
Writer 140426161940224 used 5.8813931941986 seconds, avg 42.506935303458 events/second
Writer 140426990319360 wrote 250 events
Writer 140426990319360 used 6.0871818065643 seconds, avg 41.069908529823 events/second
Writer 140427004999424 wrote 250 events
Writer 140427004999424 used 6.1245670318604 seconds, avg 40.819211986657 events/second
Writer 140426528945920 wrote 250 events
Writer 140426528945920 used 5.9949038028717 seconds, avg 41.702087009343 events/second
Writer 140426170332928 wrote 250 events
Writer 140426170332928 used 6.093887090683 seconds, avg 41.024718095323 events/second
Writer 140426138875648 wrote 250 events
Writer 140426138875648 used 6.02858710289 seconds, avg 41.469086492945 events/second
Writer 140425767679744 wrote 250 events
Writer 140425767679744 used 5.9555809497833 seconds, avg 41.977432950365 events/second
Writer 140426124195584 wrote 250 events
Writer 140426124195584 used 6.0373969078064 seconds, avg 41.408574559136 events/second
Writer 140427034355456 wrote 250 events
Writer 140427034355456 used 6.4373271465302 seconds, avg 38.835994242541 events/second
Writer 140426558306048 wrote 250 events
Writer 140426558306048 used 6.3017249107361 seconds, avg 39.671677761446 events/second
Writer 140425732028160 wrote 250 events
Writer 140425732028160 used 6.0282599925995 seconds, avg 41.471336721858 events/second
Writer 140425759287040 wrote 250 events
Writer 140425759287040 used 6.188845872879 seconds, avg 40.395253838128 events/second
Writer 140425471981312 wrote 250 events
Writer 140425471981312 used 6.0138080120087 seconds, avg 41.570997860389 events/second
Writer 140425413261056 wrote 250 events
Writer 140425413261056 used 5.9020059108734 seconds, avg 42.35848011257 events/second
Writer 140425499244288 wrote 250 events
Writer 140425499244288 used 6.1045100688934 seconds, avg 40.95332748715 events/second
Writer 140425717348096 wrote 250 events
Writer 140425717348096 used 6.1374051570892 seconds, avg 40.733827016655 events/second
Writer 140425746708224 wrote 250 events
Writer 140425746708224 used 6.2744829654694 seconds, avg 39.843920427521 events/second
Writer 140426153547520 wrote 250 events
Writer 140426153547520 used 6.4356520175934 seconds, avg 38.846102821682 events/second
Writer 140425442621184 wrote 250 events
Writer 140425442621184 used 6.1026530265808 seconds, avg 40.965789618236 events/second
Writer 140425457301248 wrote 250 events
Writer 140425457301248 used 6.1675398349762 seconds, avg 40.534801021024 events/second
Writer 140425486661376 wrote 250 events
Writer 140425486661376 used 6.2235448360443 seconds, avg 40.170032768479 events/second
Writer 140425398580992 wrote 250 events
Writer 140425398580992 used 6.1408879756927 seconds, avg 40.710724733877 events/second
Writer 140425339860736 wrote 250 events
Writer 140425339860736 used 6.038162946701 seconds, avg 41.403321209903 events/second
Writer 140425383900928 wrote 250 events
Writer 140425383900928 used 6.149108171463 seconds, avg 40.656302187073 events/second
Writer 140425369220864 wrote 250 events
Writer 140425369220864 used 6.1386210918427 seconds, avg 40.72575848218 events/second
Writer 140425310500608 wrote 250 events
Writer 140425310500608 used 6.07266497612 seconds, avg 41.168086990324 events/second
Writer 140425295820544 wrote 250 events
Writer 140425295820544 used 6.0054650306702 seconds, avg 41.628749601112 events/second
Writer 140425427941120 wrote 250 events
Writer 140425427941120 used 6.4450249671936 seconds, avg 38.789609236977 events/second
Writer 140425325180672 wrote 250 events
Writer 140425325180672 used 6.1800668239594 seconds, avg 40.452637021784 events/second
Writer 140425354540800 wrote 250 events
Writer 140425354540800 used 6.3717880249023 seconds, avg 39.235454635802 events/second
Projection 140425266460416 read 2500 events
projection 140425266460416 used 6.6631469726562 seconds, avg 375.19808736912 events/second
Projection 140425197242112 read 2500 events
projection 140425197242112 used 10.864008903503 seconds, avg 230.11763173296 events/second
Projection 140425214027520 read 2500 events
projection 140425214027520 used 6.6944379806519 seconds, avg 373.4443439801 events/second
Projection 140425281140480 read 2500 events
projection 140425281140480 used 6.8080699443817 seconds, avg 367.21126845401 events/second
Projection 140425205634816 read 2500 events
projection 140425205634816 used 6.7402908802032 seconds, avg 370.9038740958 events/second
Projection 140425182574336 read 12500 events
projection 140425182574336 used 13.417448997498 seconds, avg 931.62269536715 events/second

done.
postgres avg writes 1611.3160432265 events/second
postgres avg reads 2656.0452819732 events/second

starting benchmarks for arangodb

Writer 140425182574336 started
Writer 140425197242112 started
Writer 140425205634816 started
Writer 140425214027520 started
Writer 140428028409600 started
Writer 140428013729536 started
Writer 140427999049472 started
Writer 140427780945664 started
Writer 140427768362752 started
Writer 140427753682688 started
Writer 140427739002624 started
Writer 140427724322560 started
Writer 140427306989312 started
Writer 140427292309248 started
Writer 140427277629184 started
Writer 140427262949120 started
Writer 140427042748160 started
Writer 140427034355456 started
Writer 140427019679488 started
Writer 140427004999424 started
Writer 140426990319360 started
Writer 140426572986112 started
Writer 140426558306048 started
Writer 140426543625984 started
Writer 140426528945920 started
Writer 140426170332928 started
Writer 140426161940224 started
Writer 140426153547520 started
Writer 140426138875648 started
Writer 140426124195584 started
Writer 140425767679744 started
Writer 140425759287040 started
Writer 140425746708224 started
Writer 140425732028160 started
Writer 140425717348096 started
Writer 140425499244288 started
Writer 140425486661376 started
Writer 140425471981312 started
Writer 140425457301248 started
Writer 140425442621184 started
Writer 140425427941120 started
Writer 140425413261056 started
Writer 140425398580992 started
Writer 140425383900928 started
Writer 140425369220864 started
Writer 140425354540800 started
Writer 140425339860736 started
Writer 140425325180672 started
Writer 140425310500608 started
Writer 140425295820544 started
Projection 140425281140480 started
Projection 140425266460416 started
Projection 140425251780352 started
Projection 140425237100288 started
Projection 140425222420224 started
Projection 140425174181632 started
Writer 140427306989312 wrote 250 events
Writer 140427306989312 used 39.089928150177 seconds, avg 6.3955093250502 events/second
Writer 140427292309248 wrote 250 events
Writer 140427292309248 used 39.598783016205 seconds, avg 6.3133253337026 events/second
Writer 140428028409600 wrote 250 events
Writer 140428028409600 used 40.480870962143 seconds, avg 6.1757564513322 events/second
Writer 140425486661376 wrote 250 events
Writer 140425486661376 used 40.132525920868 seconds, avg 6.2293612042497 events/second
Writer 140428013729536 wrote 250 events
Writer 140428013729536 used 41.364096879959 seconds, avg 6.0438887551568 events/second
Writer 140427034355456 wrote 250 events
Writer 140427034355456 used 41.327007055283 seconds, avg 6.049312975062 events/second
Writer 140425759287040 wrote 250 events
Writer 140425759287040 used 41.178871870041 seconds, avg 6.0710745255235 events/second
Writer 140426528945920 wrote 250 events
Writer 140426528945920 used 41.293058156967 seconds, avg 6.0542863899708 events/second
Writer 140425499244288 wrote 250 events
Writer 140425499244288 used 41.160826921463 seconds, avg 6.0737360907985 events/second
Writer 140426138875648 wrote 250 events
Writer 140426138875648 used 41.284377813339 seconds, avg 6.055559348147 events/second
Writer 140426543625984 wrote 250 events
Writer 140426543625984 used 41.559437990189 seconds, avg 6.0154807689897 events/second
Writer 140427768362752 wrote 250 events
Writer 140427768362752 used 41.956696033478 seconds, avg 5.9585244700994 events/second
Writer 140425354540800 wrote 250 events
Writer 140425354540800 used 41.6912150383 seconds, avg 5.9964671159221 events/second
Writer 140425369220864 wrote 250 events
Writer 140425369220864 used 41.821133136749 seconds, avg 5.9778389835238 events/second
Writer 140425339860736 wrote 250 events
Writer 140425339860736 used 41.807463169098 seconds, avg 5.9797935834765 events/second
Writer 140426161940224 wrote 250 events
Writer 140426161940224 used 42.109371185303 seconds, avg 5.9369207604614 events/second
Writer 140427277629184 wrote 250 events
Writer 140427277629184 used 42.354255199432 seconds, avg 5.9025946465788 events/second
Writer 140425471981312 wrote 250 events
Writer 140425471981312 used 42.132918119431 seconds, avg 5.9336027780309 events/second
Writer 140427019679488 wrote 250 events
Writer 140427019679488 used 42.512114048004 seconds, avg 5.8806767341117 events/second
Writer 140425427941120 wrote 250 events
Writer 140425427941120 used 42.206743955612 seconds, avg 5.9232240293854 events/second
Writer 140427004999424 wrote 250 events
Writer 140427004999424 used 42.514839887619 seconds, avg 5.8802996944322 events/second
Writer 140426124195584 wrote 250 events
Writer 140426124195584 used 42.369293928146 seconds, avg 5.9004995557389 events/second
Writer 140425325180672 wrote 250 events
Writer 140425325180672 used 42.162719011307 seconds, avg 5.9294088678901 events/second
Writer 140425413261056 wrote 250 events
Writer 140425413261056 used 42.617571115494 seconds, avg 5.8661250150202 events/second
Writer 140425398580992 wrote 250 events
Writer 140425398580992 used 42.603106975555 seconds, avg 5.8681166174909 events/second
Writer 140427724322560 wrote 250 events
Writer 140427724322560 used 43.155282020569 seconds, avg 5.7930336286725 events/second
Writer 140427042748160 wrote 250 events
Writer 140427042748160 used 43.061310052872 seconds, avg 5.8056756678569 events/second
Writer 140425732028160 wrote 250 events
Writer 140425732028160 used 42.920810937881 seconds, avg 5.8246802550357 events/second
Writer 140425205634816 wrote 250 events
Writer 140425205634816 used 43.511267900467 seconds, avg 5.7456381315268 events/second
Writer 140425383900928 wrote 250 events
Writer 140425383900928 used 43.164093017578 seconds, avg 5.7918511087026 events/second
Writer 140427753682688 wrote 250 events
Writer 140427753682688 used 43.844779968262 seconds, avg 5.7019330506612 events/second
Writer 140426558306048 wrote 250 events
Writer 140426558306048 used 43.688838005066 seconds, avg 5.7222854032193 events/second
Writer 140426170332928 wrote 250 events
Writer 140426170332928 used 43.635822057724 seconds, avg 5.7292377732517 events/second
Writer 140426153547520 wrote 250 events
Writer 140426153547520 used 43.667011976242 seconds, avg 5.7251455660859 events/second
Writer 140425442621184 wrote 250 events
Writer 140425442621184 used 43.635095119476 seconds, avg 5.729333219407 events/second
Writer 140426572986112 wrote 250 events
Writer 140426572986112 used 43.900778055191 seconds, avg 5.6946598915788 events/second
Writer 140427780945664 wrote 250 events
Writer 140427780945664 used 44.316076040268 seconds, avg 5.6412936870321 events/second
Writer 140425197242112 wrote 250 events
Writer 140425197242112 used 44.412967920303 seconds, avg 5.628986570963 events/second
Writer 140425310500608 wrote 250 events
Writer 140425310500608 used 43.710537910461 seconds, avg 5.7194445996549 events/second
Writer 140425214027520 wrote 250 events
Writer 140425214027520 used 44.455543994904 seconds, avg 5.6235955638887 events/second
Writer 140426990319360 wrote 250 events
Writer 140426990319360 used 44.09797000885 seconds, avg 5.6691952021789 events/second
Writer 140427262949120 wrote 250 events
Writer 140427262949120 used 44.290491819382 seconds, avg 5.6445523571856 events/second
Writer 140425767679744 wrote 250 events
Writer 140425767679744 used 44.027677059174 seconds, avg 5.6782464281274 events/second
Writer 140427739002624 wrote 250 events
Writer 140427739002624 used 44.464016914368 seconds, avg 5.6225239496798 events/second
Writer 140425182574336 wrote 250 events
Writer 140425182574336 used 44.637111186981 seconds, avg 5.6007208654873 events/second
Writer 140425717348096 wrote 250 events
Writer 140425717348096 used 44.064300060272 seconds, avg 5.6735270878703 events/second
Writer 140425295820544 wrote 250 events
Writer 140425295820544 used 43.921452045441 seconds, avg 5.6919793940636 events/second
Writer 140425457301248 wrote 250 events
Writer 140425457301248 used 44.077114105225 seconds, avg 5.6718776869824 events/second
Writer 140427999049472 wrote 250 events
Writer 140427999049472 used 44.637211799622 seconds, avg 5.6007082414166 events/second
Writer 140425746708224 wrote 250 events
Writer 140425746708224 used 44.220118999481 seconds, avg 5.6535352155641 events/second
Projection 140425222420224 read 2500 events
projection 140425222420224 used 44.589893102646 seconds, avg 56.066517007453 events/second
Projection 140425251780352 read 2500 events
projection 140425251780352 used 44.665822982788 seconds, avg 55.971206462789 events/second
Projection 140425266460416 read 2500 events
projection 140425266460416 used 44.738929986954 seconds, avg 55.879745016902 events/second
Projection 140425237100288 read 2500 events
projection 140425237100288 used 44.800142049789 seconds, avg 55.803394489722 events/second
Projection 140425281140480 read 2500 events
projection 140425281140480 used 44.860484838486 seconds, avg 55.728332161387 events/second
Projection 140425174181632 read 12500 events
projection 140425174181632 used 46.698714017868 seconds, avg 267.67332383537 events/second

done.
arangodb avg writes 279.17872206671 events/second
arangodb avg reads 533.85542323559 events/second

all finished
mysql: destroying event-store tables on database event_store_tests
mariadb: destroying event-store tables on database event_store_tests
postgres: destroying event-store tables on database event_store_tests
arangodb: destroying event-store tables on database _system