Skip to content

Instantly share code, notes, and snippets.

@sandrokeil
Created October 2, 2017 11:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sandrokeil/c3e9b94ddadc9e2dfebe462a8f4e0d85 to your computer and use it in GitHub Desktop.
Save sandrokeil/c3e9b94ddadc9e2dfebe462a8f4e0d85 to your computer and use it in GitHub Desktop.
prooph-event-store-benchmarks

prooph Event Store benchmark

They were running a notebook with Intel(R) Core(TM) i7-Q720 CPU @ 1.6GHz (x8), 20 GB RAM, SAMSUNG SSD 850

ArangoDB event store

arangodb: recreating test-database _system

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

test 1 using arangodb took 1.3396980762482 seconds test 1 using arangodb writes 746.4368410534 events per second

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

test 2 using arangodb took 0.52354621887207 seconds test 2 using arangodb writes 1910.0510402967 events per second

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

test 3 using arangodb took 0.52139210700989 seconds test 3 using arangodb writes 4794.8558606634 events per second

test 4 load one stream with 2500 events

test 4 using arangodb took 0.02816104888916 seconds test 4 using arangodb loads 88775.102441668 events per second

test 5 project 1 stream with 2500 events

test 5 using arangodb took 0.24293899536133 seconds test 5 using arangodb loads 10290.649289472 events per second

test 6 project 10 stream with 100 events

test 6 using arangodb took 0.22559595108032 seconds test 6 using arangodb loads 4432.7036687106 events per second

test 7 real world test

arangodb: recreating test-database _system

starting benchmarks for arangodb

Writer 139838480693992 started
Writer 139838480210664 started
Writer 139838479727336 started
Writer 139838479567592 started
Writer 139838454446824 started
Writer 139838365629160 started
Writer 139838365145832 started
Writer 139838364662504 started
Writer 139838364179176 started
Writer 139838364019432 started
Writer 139838314912488 started
Writer 139838314494696 started
Writer 139838313945832 started
Writer 139838294588136 started
Writer 139838294104808 started
Writer 139838293621480 started
Writer 139838293138152 started
Writer 139838292654824 started
Writer 139838272809704 started
Writer 139838273293032 started
Writer 139838272326376 started
Writer 139838271843048 started
Writer 139838271683304 started
Writer 139838254029544 started
Writer 139838253546216 started
Writer 139838253062888 started
Writer 139838235802344 started
Writer 139838235319016 started
Writer 139838234835688 started
Writer 139838234352360 started
Writer 139838233869032 started
Writer 139838212410088 started
Writer 139838211926760 started
Writer 139838211443432 started
Writer 139838210894568 started
Writer 139838193601256 started
Writer 139838193117928 started
Writer 139838192634600 started
Writer 139838192151272 started
Writer 139838191991528 started
Writer 139838173919976 started
Writer 139838174403304 started
Writer 139838154078952 started
Writer 139838173436648 started
Writer 139838153595624 started
Writer 139838153112296 started
Writer 139838152080104 started
Writer 139838152563432 started
Writer 139838132718312 started
Writer 139838132234984 started
Projection 139838131751656 started
Projection 139838131268328 started
Projection 139838131108584 started
Projection 139838113520360 started
Projection 139838113037032 started
Projection 139838112553704 started
Writer 139838480210664 wrote 250
Writer 139838480210664 used 15.714018106461 seconds, avg 15.909361838982 events/second
Writer 139838365629160 wrote 250
Writer 139838365629160 used 15.716776132584 seconds, avg 15.906570017353 events/second
Writer 139838234835688 wrote 250
Writer 139838234835688 used 15.643503904343 seconds, avg 15.981074414575 events/second
Writer 139838152080104 wrote 250
Writer 139838152080104 used 15.503380060196 seconds, avg 16.125515792641 events/second
Writer 139838294588136 wrote 250
Writer 139838294588136 used 15.922046899796 seconds, avg 15.701498781743 events/second
Writer 139838364019432 wrote 250
Writer 139838364019432 used 16.330537080765 seconds, avg 15.308743292618 events/second
Writer 139838293621480 wrote 250
Writer 139838293621480 used 16.350661039352 seconds, avg 15.289901698672 events/second
Writer 139838292654824 wrote 250
Writer 139838292654824 used 16.426971912384 seconds, avg 15.218873042056 events/second
Writer 139838364179176 wrote 250
Writer 139838364179176 used 16.493287086487 seconds, avg 15.157681952 events/second
Writer 139838364662504 wrote 250
Writer 139838364662504 used 16.634790182114 seconds, avg 15.028743811197 events/second
Writer 139838191991528 wrote 250
Writer 139838191991528 used 16.484979867935 seconds, avg 15.165320309931 events/second
Writer 139838272326376 wrote 250
Writer 139838272326376 used 16.721050024033 seconds, avg 14.951214166615 events/second
Writer 139838253546216 wrote 250
Writer 139838253546216 used 17.024264097214 seconds, avg 14.68492256537 events/second
Writer 139838271843048 wrote 250
Writer 139838271843048 used 17.09640789032 seconds, avg 14.622954810382 events/second
Writer 139838293138152 wrote 250
Writer 139838293138152 used 17.176203966141 seconds, avg 14.555020451132 events/second
Writer 139838212410088 wrote 250
Writer 139838212410088 used 17.124200105667 seconds, avg 14.599222063357 events/second
Writer 139838174403304 wrote 250
Writer 139838174403304 used 16.992333889008 seconds, avg 14.712516928691 events/second
Writer 139838272809704 wrote 250
Writer 139838272809704 used 17.253857135773 seconds, avg 14.489513737869 events/second
Writer 139838253062888 wrote 250
Writer 139838253062888 used 17.235818147659 seconds, avg 14.50467844684 events/second
Writer 139838254029544 wrote 250
Writer 139838254029544 used 17.549117803574 seconds, avg 14.245730343727 events/second
Writer 139838132718312 wrote 250
Writer 139838132718312 used 17.30489897728 seconds, avg 14.446776044647 events/second
Writer 139838235802344 wrote 250
Writer 139838235802344 used 17.564815044403 seconds, avg 14.232999286813 events/second
Writer 139838153595624 wrote 250
Writer 139838153595624 used 17.409134864807 seconds, avg 14.360277058074 events/second
Writer 139838154078952 wrote 250
Writer 139838154078952 used 17.472311973572 seconds, avg 14.308352573955 events/second
Writer 139838235319016 wrote 250
Writer 139838235319016 used 17.688719034195 seconds, avg 14.133301541887 events/second
Writer 139838173436648 wrote 250
Writer 139838173436648 used 17.529226064682 seconds, avg 14.261896051629 events/second
Writer 139838273293032 wrote 250
Writer 139838273293032 used 17.860373020172 seconds, avg 13.997468010194 events/second
Writer 139838153112296 wrote 250
Writer 139838153112296 used 17.588855028152 seconds, avg 14.213545998296 events/second
Writer 139838233869032 wrote 250
Writer 139838233869032 used 17.791824817657 seconds, avg 14.051397344689 events/second
Writer 139838480693992 wrote 250
Writer 139838480693992 used 18.04233789444 seconds, avg 13.85629741903 events/second
Writer 139838294104808 wrote 250
Writer 139838294104808 used 17.984333992004 seconds, avg 13.900987387754 events/second
Writer 139838313945832 wrote 250
Writer 139838313945832 used 17.999629974365 seconds, avg 13.889174408365 events/second
Writer 139838192151272 wrote 250
Writer 139838192151272 used 17.781584978104 seconds, avg 14.059489089856 events/second
Writer 139838193601256 wrote 250
Writer 139838193601256 used 17.844261169434 seconds, avg 14.01010653376 events/second
Writer 139838132234984 wrote 250
Writer 139838132234984 used 17.67991399765 seconds, avg 14.14034027729 events/second
Writer 139838152563432 wrote 250
Writer 139838152563432 used 17.709275960922 seconds, avg 14.116895606103 events/second
Writer 139838271683304 wrote 250
Writer 139838271683304 used 18.018373012543 seconds, avg 13.874726637415 events/second
Writer 139838454446824 wrote 250
Writer 139838454446824 used 18.155168056488 seconds, avg 13.77018374174 events/second
Writer 139838211443432 wrote 250
Writer 139838211443432 used 17.899361848831 seconds, avg 13.966978382323 events/second
Writer 139838234352360 wrote 250
Writer 139838234352360 used 17.961499214172 seconds, avg 13.918659963682 events/second
Writer 139838193117928 wrote 250
Writer 139838193117928 used 17.956639051437 seconds, avg 13.922427202767 events/second
Writer 139838192634600 wrote 250
Writer 139838192634600 used 17.944910049438 seconds, avg 13.931527063175 events/second
Writer 139838211926760 wrote 250
Writer 139838211926760 used 18.008630037308 seconds, avg 13.882233100579 events/second
Writer 139838365145832 wrote 250
Writer 139838365145832 used 18.247192144394 seconds, avg 13.700738065435 events/second
Writer 139838479727336 wrote 250
Writer 139838479727336 used 18.275813102722 seconds, avg 13.679281933714 events/second
Writer 139838173919976 wrote 250
Writer 139838173919976 used 18.02557682991 seconds, avg 13.869181683283 events/second
Writer 139838314912488 wrote 250
Writer 139838314912488 used 18.351651906967 seconds, avg 13.622751851842 events/second
Writer 139838479567592 wrote 250
Writer 139838479567592 used 18.422726869583 seconds, avg 13.570195214301 events/second
Writer 139838210894568 wrote 250
Writer 139838210894568 used 18.179378986359 seconds, avg 13.751844889069 events/second
Writer 139838314494696 wrote 250
Writer 139838314494696 used 19.302628993988 seconds, avg 12.951603643103 events/second
Projection 139838131108584 read 2500 events
projection 139838131108584 used 18.997730016708 seconds, avg 131.59466935267 events/second
Projection 139838113037032 read 2500 events
projection 139838113037032 used 18.990937948227 seconds, avg 131.64173390569 events/second
Projection 139838113520360 read 2500 events
projection 139838113520360 used 19.217695951462 seconds, avg 130.08843548749 events/second
Projection 139838131751656 read 2500 events
projection 139838131751656 used 19.300546169281 seconds, avg 129.53001319616 events/second
Projection 139838131268328 read 2500 events
projection 139838131268328 used 19.511069059372 seconds, avg 128.13239461111 events/second
Projection 139838112553704 read 12500 events
projection 139838112553704 used 23.16006398201 seconds, avg 539.72217044433 events/second

done. arangodb avg writes 644.66076671138 events/second arangodb avg reads 1076.5332012142 events/second

all finished

Postgres event store

postgres: recreating test-database event_store_tests

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

test 1 using postgres took 1.9946980476379 seconds test 1 using postgres writes 501.32901126773 events per second

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

test 2 using postgres took 0.5756938457489 seconds test 2 using postgres writes 1737.0343757959 events per second

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

test 3 using postgres took 0.4593608379364 seconds test 3 using postgres writes 5442.3446526935 events per second

test 4 load one stream with 2500 events

test 4 using postgres took 0.01310396194458 seconds test 4 using postgres loads 190781.99483279 events per second

test 5 project 1 stream with 2500 events

test 5 using postgres took 0.23191595077515 seconds test 5 using postgres loads 10779.767375397 events per second

test 6 project 10 stream with 100 events

test 6 using postgres took 0.24017286300659 seconds test 6 using postgres loads 4163.6677328219 events per second

test 7 real world test

postgres: recreating test-database event_store_tests

starting benchmarks for postgres

Writer 140409750510312 started
Writer 140409750026984 started
Writer 140409749543656 started
Writer 140409749383912 started
Writer 140409724586728 started
Writer 140409634425576 started
Writer 140409610832616 started
Writer 140409609865960 started
Writer 140409610349288 started
Writer 140409609382632 started
Writer 140409609222888 started
Writer 140409600023272 started
Writer 140409599539944 started
Writer 140409599056616 started
Writer 140409590184680 started
Writer 140409589701352 started
Writer 140409589218024 started
Writer 140409588251368 started
Writer 140409588734696 started
Writer 140409577278184 started
Writer 140409576794856 started
Writer 140409575828200 started
Writer 140409575668456 started
Writer 140409576311528 started
Writer 140409566468840 started
Writer 140409565985512 started
Writer 140409556146920 started
Writer 140409565502184 started
Writer 140409556630248 started
Writer 140409555663592 started
Writer 140409555180264 started
Writer 140409554696936 started
Writer 140409543723752 started
Writer 140409543240424 started
Writer 140409542757096 started
Writer 140409542273768 started
Writer 140409542114024 started
Writer 140409532914408 started
Writer 140409532431080 started
Writer 140409531947752 started
Writer 140409523075816 started
Writer 140409522592488 started
Writer 140409522109160 started
Writer 140409521625832 started
Writer 140409521142504 started
Writer 140409510169320 started
Writer 140409508719336 started
Writer 140409509685992 started
Projection 140409499359976 started
Writer 140409509202664 started
Writer 140409508559592 started
Projection 140409498876648 started
Projection 140409498327784 started
Projection 140409488939752 started
Projection 140409498168040 started
Projection 140409488456424 started
Projection 140409488456424 read 12500 events
projection 140409488456424 used 20.895166873932 seconds, avg 598.22446383975 events/second
Writer 140409609382632 wrote 250
Writer 140409609382632 used 26.411859035492 seconds, avg 9.4654450360368 events/second
Writer 140409750026984 wrote 250
Writer 140409750026984 used 26.474369049072 seconds, avg 9.4430956800748 events/second
Writer 140409610349288 wrote 250
Writer 140409610349288 used 26.514410972595 seconds, avg 9.428834766814 events/second
Writer 140409724586728 wrote 250
Writer 140409724586728 used 26.54341006279 seconds, avg 9.4185336175198 events/second
Writer 140409599056616 wrote 250
Writer 140409599056616 used 26.491761922836 seconds, avg 9.4368959198783 events/second
Writer 140409749543656 wrote 250
Writer 140409749543656 used 26.757525920868 seconds, avg 9.3431657597696 events/second
Writer 140409590184680 wrote 250
Writer 140409590184680 used 26.780716180801 seconds, avg 9.335075220252 events/second
Writer 140409749383912 wrote 250
Writer 140409749383912 used 26.864041090012 seconds, avg 9.306120369692 events/second
Writer 140409599539944 wrote 250
Writer 140409575668456 wrote 250
Writer 140409575668456 used 26.836011886597 seconds, avg 9.3158402618261 events/second
Writer 140409599539944 used 26.911760807037 seconds, avg 9.2896188321734 events/second
Writer 140409750510312 wrote 250
Writer 140409750510312 used 27.021796941757 seconds, avg 9.2517903431385 events/second
Writer 140409610832616 wrote 250
Writer 140409610832616 used 27.005463838577 seconds, avg 9.2573858939936 events/second
Writer 140409609222888 wrote 250
Writer 140409609222888 used 27.210253953934 seconds, avg 9.1877128535163 events/second
Writer 140409565985512 wrote 250
Writer 140409565985512 used 27.119480848312 seconds, avg 9.2184655524317 events/second
Writer 140409521625832 wrote 250
Writer 140409521625832 used 27.033359050751 seconds, avg 9.2478333724886 events/second
Writer 140409589701352 wrote 250
Writer 140409589701352 used 27.223842144012 seconds, avg 9.1831270060088 events/second
Writer 140409509202664 wrote 250
Writer 140409556630248 wrote 250
Writer 140409509202664 used 27.011827945709 seconds, avg 9.2552048125907 events/second
Writer 140409556630248 used 27.147075891495 seconds, avg 9.2090949684318 events/second
Writer 140409634425576 wrote 250
Writer 140409634425576 used 27.311866998672 seconds, avg 9.1535302223078 events/second
Writer 140409577278184 wrote 250
Writer 140409577278184 used 27.223093986511 seconds, avg 9.1833793808989 events/second
Writer 140409588734696 wrote 250
Writer 140409588734696 used 27.237892866135 seconds, avg 9.1783898713703 events/second
Writer 140409508719336 wrote 250
Writer 140409508719336 used 27.047116041183 seconds, avg 9.2431296415979 events/second
Writer 140409542273768 wrote 250
Writer 140409542273768 used 27.129871845245 seconds, avg 9.2149347931333 events/second
Writer 140409576311528 wrote 250
Writer 140409576311528 used 27.21234703064 seconds, avg 9.1870061674031 events/second
Writer 140409575828200 wrote 250
Writer 140409575828200 used 27.229616880417 seconds, avg 9.1811794891538 events/second
Writer 140409600023272 wrote 250
Writer 140409600023272 used 27.304499149323 seconds, avg 9.1560002120091 events/second
Writer 140409609865960 wrote 250
Writer 140409609865960 used 27.387631177902 seconds, avg 9.1282082183768 events/second
Writer 140409566468840 wrote 250
Writer 140409566468840 used 27.2965259552 seconds, avg 9.1586746390477 events/second
Writer 140409556146920 wrote 250
Writer 140409556146920 used 27.270303964615 seconds, avg 9.1674812398275 events/second
Writer 140409565502184 wrote 250
Writer 140409565502184 used 27.292443037033 seconds, avg 9.1600447662664 events/second
Writer 140409576794856 wrote 250
Writer 140409576794856 used 27.455327033997 seconds, avg 9.1057010426588 events/second
Writer 140409521142504 wrote 250
Writer 140409521142504 used 27.305341005325 seconds, avg 9.1557179216785 events/second
Writer 140409543723752 wrote 250
Writer 140409543723752 used 27.408404111862 seconds, avg 9.1212899145705 events/second
Writer 140409532431080 wrote 250
Writer 140409532431080 used 27.359894990921 seconds, avg 9.1374619706311 events/second
Writer 140409588251368 wrote 250
Writer 140409588251368 used 27.546324014664 seconds, avg 9.0756211197878 events/second
Writer 140409531947752 wrote 250
Writer 140409531947752 used 27.404883861542 seconds, avg 9.1224615752097 events/second
Writer 140409555180264 wrote 250
Writer 140409555180264 used 27.474968194962 seconds, avg 9.0991916069204 events/second
Writer 140409532914408 wrote 250
Writer 140409532914408 used 27.445258140564 seconds, avg 9.1090416683129 events/second
Writer 140409542757096 wrote 250
Writer 140409542757096 used 27.464158058167 seconds, avg 9.1027731296377 events/second
Writer 140409555663592 wrote 250
Writer 140409555663592 used 27.523423910141 seconds, avg 9.0831722396241 events/second
Writer 140409542114024 wrote 250
Writer 140409542114024 used 27.47816991806 seconds, avg 9.0981313801282 events/second
Writer 140409508559592 wrote 250
Writer 140409508559592 used 27.398202896118 seconds, avg 9.124686058713 events/second
Writer 140409522592488 wrote 250
Writer 140409522592488 used 27.462081193924 seconds, avg 9.1034615415569 events/second
Writer 140409589218024 wrote 250
Writer 140409589218024 used 27.628232002258 seconds, avg 9.0487150961945 events/second
Writer 140409522109160 wrote 250
Writer 140409522109160 used 27.45671081543 seconds, avg 9.1052421275279 events/second
Writer 140409523075816 wrote 250
Writer 140409523075816 used 27.48525595665 seconds, avg 9.0957857694432 events/second
Writer 140409510169320 wrote 250
Writer 140409510169320 used 27.456933021545 seconds, avg 9.1051684397462 events/second
Writer 140409543240424 wrote 250
Writer 140409543240424 used 27.541982889175 seconds, avg 9.0770516053968 events/second
Writer 140409554696936 wrote 250
Writer 140409554696936 used 27.565555095673 seconds, avg 9.069289522098 events/second
Writer 140409509685992 wrote 250
Writer 140409509685992 used 27.452444076538 seconds, avg 9.1066572908042 events/second
Projection 140409488939752 read 2500 events
projection 140409488939752 used 28.091485023499 seconds, avg 88.994939139342 events/second
Projection 140409498876648 read 2500 events
projection 140409498876648 used 28.132570981979 seconds, avg 88.864967286545 events/second
Projection 140409499359976 read 2500 events
projection 140409499359976 used 28.190065145493 seconds, avg 88.683725528734 events/second
Projection 140409498327784 read 2500 events
projection 140409498327784 used 28.298795938492 seconds, avg 88.342981285628 events/second
Projection 140409498168040 read 2500 events
projection 140409498168040 used 28.318161964417 seconds, avg 88.282565907399 events/second

done. postgres avg writes 449.93216149826 events/second postgres avg reads 881.39861307249 events/second

all finished

MariaDB event store

mariadb: recreating test-database event_store_tests

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

test 1 using mariadb took 2.4901359081268 seconds test 1 using mariadb writes 401.58450658713 events per second

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

test 2 using mariadb took 0.64930009841919 seconds test 2 using mariadb writes 1540.1198959228 events per second

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

test 3 using mariadb took 0.45750403404236 seconds test 3 using mariadb writes 5464.4326912504 events per second

test 4 load one stream with 2500 events

test 4 using mariadb took 0.0175940990448 seconds test 4 using mariadb loads 142093.09573819 events per second

test 5 project 1 stream with 2500 events

test 5 using mariadb took 0.24222898483276 seconds test 5 using mariadb loads 10320.812770305 events per second

test 6 project 10 stream with 100 events

test 6 using mariadb took 0.21984791755676 seconds test 6 using mariadb loads 4548.5989183491 events per second

test 7 real world test

mariadb: recreating test-database event_store_tests

starting benchmarks for mariadb

Writer 139876212882152 started
Writer 139876212398824 started
Writer 139876211915496 started
Writer 139876211755752 started
Writer 139876186634984 started
Writer 139876186151656 started
Writer 139876097329896 started
Writer 139876096846568 started
Writer 139876096363240 started
Writer 139876095879912 started
Writer 139876061809384 started
Writer 139876061326056 started
Writer 139876060842728 started
Writer 139876060359400 started
Writer 139876060199656 started
Writer 139876051000040 started
Writer 139876050516712 started
Writer 139876050033384 started
Writer 139876041161448 started
Writer 139876040678120 started
Writer 139876040194792 started
Writer 139876039711464 started
Writer 139876039228136 started
Writer 139876028254952 started
Writer 139876027771624 started
Writer 139876027288296 started
Writer 139876026804968 started
Writer 139876026645224 started
Writer 139876017445608 started
Writer 139876016962280 started
Writer 139876016478952 started
Writer 139876007607016 started
Writer 139876007123688 started
Writer 139876006640360 started
Writer 139876006157032 started
Writer 139876005673704 started
Writer 139875994700520 started
Writer 139875994217192 started
Writer 139875993733864 started
Writer 139875993250536 started
Writer 139875993090792 started
Writer 139875983891176 started
Writer 139875983407848 started
Writer 139875982924520 started
Writer 139875974052584 started
Writer 139875973085928 started
Writer 139875973569256 started
Writer 139875972602600 started
Writer 139875963632360 started
Writer 139875963149032 started
Projection 139875962665704 started
Projection 139875962182376 started
Projection 139875961699048 started
Projection 139875950725864 started
Projection 139875950242536 started
Projection 139875949759208 started
Writer 139876016962280 wrote 250
Writer 139876016962280 used 47.054975032806 seconds, avg 5.3129344947203 events/second
Writer 139876212398824 wrote 250
Writer 139876212398824 used 48.015321969986 seconds, avg 5.2066713237136 events/second
Writer 139876026645224 wrote 250
Writer 139876026645224 used 48.240180969238 seconds, avg 5.1824017857524 events/second
Writer 139876041161448 wrote 250
Writer 139876041161448 used 48.674383163452 seconds, avg 5.1361719194362 events/second
Writer 139876060359400 wrote 250
Writer 139876060359400 used 49.029919147491 seconds, avg 5.0989274375092 events/second
Writer 139876211915496 wrote 250
Writer 139876211915496 used 49.332306861877 seconds, avg 5.0676730098992 events/second
Writer 139876186634984 wrote 250
Writer 139876186634984 used 49.890252113342 seconds, avg 5.0109989308541 events/second
Writer 139875983407848 wrote 250
Writer 139875983407848 used 49.773696899414 seconds, avg 5.0227332019403 events/second
Writer 139876050516712 wrote 250
Writer 139876050516712 used 50.310190916061 seconds, avg 4.9691721587204 events/second
Writer 139876097329896 wrote 250
Writer 139876097329896 used 50.428740024567 seconds, avg 4.9574905079566 events/second
Writer 139876005673704 wrote 250
Writer 139876005673704 used 50.358360052109 seconds, avg 4.9644190108913 events/second
Writer 139876017445608 wrote 250
Writer 139876017445608 used 50.531967878342 seconds, avg 4.9473632335453 events/second
Writer 139876039711464 wrote 250
Writer 139876039711464 used 50.793313980103 seconds, avg 4.9219076372519 events/second
Writer 139875973569256 wrote 250
Writer 139875973569256 used 50.676928043365 seconds, avg 4.9332114169602 events/second
Writer 139875994217192 wrote 250
Writer 139875994217192 used 50.722944021225 seconds, avg 4.9287359955958 events/second
Writer 139876026804968 wrote 250
Writer 139876026804968 used 51.075986146927 seconds, avg 4.8946680986411 events/second
Writer 139876095879912 wrote 250
Writer 139875983891176 wrote 250
Writer 139875983891176 used 51.078630924225 seconds, avg 4.8944146598384 events/second
Writer 139876095879912 used 51.230179786682 seconds, avg 4.8799360267908 events/second
Writer 139875963632360 wrote 250
Writer 139876050033384 wrote 250
Writer 139876050033384 used 51.23938703537 seconds, avg 4.8790591469689 events/second
Writer 139875963632360 used 51.092759132385 seconds, avg 4.8930612526176 events/second
Writer 139875982924520 wrote 250
Writer 139875982924520 used 51.386290073395 seconds, avg 4.8651109010385 events/second
Writer 139875973085928 wrote 250
Writer 139875973085928 used 51.410937070847 seconds, avg 4.8627785106404 events/second
Writer 139876096846568 wrote 250
Writer 139876096846568 used 51.729114770889 seconds, avg 4.8328683200411 events/second
Writer 139876027288296 wrote 250
Writer 139876027288296 used 51.794023990631 seconds, avg 4.8268116809233 events/second
Writer 139875993733864 wrote 250
Writer 139875993733864 used 51.767754793167 seconds, avg 4.8292610139043 events/second
Writer 139876060842728 wrote 250
Writer 139875974052584 wrote 250
Writer 139875974052584 used 51.95361495018 seconds, avg 4.8119846951888 events/second
Writer 139876060842728 used 52.102975845337 seconds, avg 4.7981904285487 events/second
Writer 139876186151656 wrote 250
Writer 139876006157032 wrote 250
Writer 139876006157032 used 52.02118396759 seconds, avg 4.8057345283751 events/second
Writer 139876186151656 used 52.15740609169 seconds, avg 4.7931831494939 events/second
Writer 139876007607016 wrote 250
Writer 139876007607016 used 52.171357154846 seconds, avg 4.7919014116883 events/second
Writer 139876096363240 wrote 250
Writer 139876096363240 used 52.2796459198 seconds, avg 4.7819757689927 events/second
Writer 139875994700520 wrote 250
Writer 139876061809384 wrote 250
Writer 139875994700520 used 52.148930072784 seconds, avg 4.7939622088329 events/second
Writer 139876061809384 used 52.270683050156 seconds, avg 4.7827957358069 events/second
Writer 139876061326056 wrote 250
Writer 139876061326056 used 52.393342018127 seconds, avg 4.7715986491853 events/second
Writer 139876051000040 wrote 250
Writer 139876051000040 used 52.394490003586 seconds, avg 4.7714941014387 events/second
Writer 139875993090792 wrote 250
Writer 139875993090792 used 52.346251010895 seconds, avg 4.7758912084834 events/second
Writer 139876007123688 wrote 250
Writer 139876007123688 used 52.417392969131 seconds, avg 4.769409271217 events/second
Writer 139876040678120 wrote 250
Writer 139876040678120 used 52.525329828262 seconds, avg 4.7596083797551 events/second
Writer 139876040194792 wrote 250
Writer 139876040194792 used 52.701426029205 seconds, avg 4.7437046553818 events/second
Writer 139876028254952 wrote 250
Writer 139876028254952 used 52.748369932175 seconds, avg 4.7394829512544 events/second
Writer 139875963149032 wrote 250
Writer 139875963149032 used 52.657070159912 seconds, avg 4.7477005317764 events/second
Writer 139875972602600 wrote 250
Writer 139875972602600 used 52.757292032242 seconds, avg 4.7386814290471 events/second
Writer 139875993250536 wrote 250
Writer 139875993250536 used 52.835916042328 seconds, avg 4.7316298973547 events/second
Writer 139876006640360 wrote 250
Writer 139876006640360 used 52.956591844559 seconds, avg 4.7208476091856 events/second
Writer 139876039228136 wrote 250
Writer 139876039228136 used 53.015503883362 seconds, avg 4.7156016954968 events/second
Writer 139876016478952 wrote 250
Writer 139876016478952 used 53.070001840591 seconds, avg 4.710759211031 events/second
Writer 139876212882152 wrote 250
Writer 139876212882152 used 53.300624847412 seconds, avg 4.6903765334027 events/second
Writer 139876027771624 wrote 250
Writer 139876027771624 used 53.189664125443 seconds, avg 4.7001612834103 events/second
Writer 139876211755752 wrote 250
Writer 139876211755752 used 53.322895050049 seconds, avg 4.6884176068338 events/second
Writer 139876060199656 wrote 250
Writer 139876060199656 used 53.386951208115 seconds, avg 4.6827922243666 events/second
Projection 139875950725864 read 2500 events
projection 139875950725864 used 54.061199188232 seconds, avg 46.243887252582 events/second
Projection 139875962665704 read 2500 events
projection 139875962665704 used 54.159124851227 seconds, avg 46.160273210976 events/second
Projection 139875961699048 read 2500 events
projection 139875961699048 used 54.151304006577 seconds, avg 46.166939944722 events/second
Projection 139875950242536 read 2500 events
projection 139875950242536 used 54.163459062576 seconds, avg 46.156579422147 events/second
Projection 139875962182376 read 2500 events
projection 139875962182376 used 54.199523925781 seconds, avg 46.12586640841 events/second
Class 'Prooph\EventStore\Pdo\Exception\RuntimeException' not found
#0 /app/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(583): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->persist()
#1 /app/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(488): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->handleStreamWithSingleHandler('blog-da7f61bd-d...', Object(Prooph\EventStore\Pdo\PdoStreamIterator))
#2 /app/src/AllProjector.php(48): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->run()
#3 [internal function]: Prooph\EventStoreBenchmarks\AllProjector->run()
#4 {main}

done. mariadb avg writes 233.81620465265 events/second mariadb avg reads 456.02123766388 events/second

all finished

MySql event store

mysql: recreating test-database event_store_tests

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

test 1 using mysql took 2.6763379573822 seconds test 1 using mysql writes 373.64488936895 events per second

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

test 2 using mysql took 0.72507095336914 seconds test 2 using mysql writes 1379.1753694633 events per second

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

test 3 using mysql took 0.56486916542053 seconds test 3 using mysql writes 4425.803625055 events per second

test 4 load one stream with 2500 events

test 4 using mysql took 0.052790880203247 seconds test 4 using mysql loads 47356.664453688 events per second

test 5 project 1 stream with 2500 events

test 5 using mysql took 0.30674004554749 seconds test 5 using mysql loads 8150.2237359908 events per second

test 6 project 10 stream with 100 events

test 6 using mysql took 0.21649885177612 seconds test 6 using mysql loads 4618.9621413516 events per second

test 7 real world test

mysql: recreating test-database event_store_tests

starting benchmarks for mysql

Writer 139906721880808 started
Writer 139906721397480 started
Writer 139906720914152 started
Writer 139906720754408 started
Writer 139906695633640 started
Writer 139906695473896 started
Writer 139906606373608 started
Writer 139906605890280 started
Writer 139906605406952 started
Writer 139906605247208 started
Writer 139906572950248 started
Writer 139906572466920 started
Writer 139906571983592 started
Writer 139906563111656 started
Writer 139906562628328 started
Writer 139906562145000 started
Writer 139906561661672 started
Writer 139906561178344 started
Writer 139906550205160 started
Writer 139906549238504 started
Writer 139906549721832 started
Writer 139906548755176 started
Writer 139906548595432 started
Writer 139906539395816 started
Writer 139906538912488 started
Writer 139906538429160 started
Writer 139906529557224 started
Writer 139906529073896 started
Writer 139906528590568 started
Writer 139906527623912 started
Writer 139906528107240 started
Writer 139906516650728 started
Writer 139906515684072 started
Writer 139906516167400 started
Writer 139906515200744 started
Writer 139906515041000 started
Writer 139906505358056 started
Writer 139906504874728 started
Writer 139906496002792 started
Writer 139906505841384 started
Writer 139906495519464 started
Writer 139906495036136 started
Writer 139906494552808 started
Writer 139906494069480 started
Writer 139906483096296 started
Writer 139906482612968 started
Writer 139906482129640 started
Writer 139906481646312 started
Writer 139906472676072 started
Writer 139906472192744 started
Projection 139906471709416 started
Projection 139906471226088 started
Projection 139906471066344 started
Projection 139906461866728 started
Projection 139906460900072 started
Projection 139906461383400 started
Writer 139906571983592 wrote 250
Writer 139906571983592 used 104.60701799393 seconds, avg 2.3898970145054 events/second
Writer 139906482612968 wrote 250
Writer 139906482612968 used 113.33866715431 seconds, avg 2.2057785421071 events/second
Writer 139906494069480 wrote 250
Writer 139906494069480 used 114.61375713348 seconds, avg 2.181239026209 events/second
Writer 139906721880808 wrote 250
Writer 139906721880808 used 115.07979798317 seconds, avg 2.172405620981 events/second
Writer 139906529073896 wrote 250
Writer 139906529073896 used 115.2223072052 seconds, avg 2.1697187468636 events/second
Writer 139906505358056 wrote 250
Writer 139906505358056 used 115.21001887321 seconds, avg 2.169950169656 events/second
Writer 139906482129640 wrote 250
Writer 139906482129640 used 115.37398195267 seconds, avg 2.1668663572916 events/second
Writer 139906516167400 wrote 250
Writer 139906516167400 used 116.0801820755 seconds, avg 2.1536837342088 events/second
Writer 139906515684072 wrote 250
Writer 139906515684072 used 116.17051911354 seconds, avg 2.1520089770423 events/second
Writer 139906516650728 wrote 250
Writer 139906516650728 used 116.24856305122 seconds, avg 2.1505642172096 events/second
Writer 139906495519464 wrote 250
Writer 139906495519464 used 116.45899009705 seconds, avg 2.146678412647 events/second
Writer 139906605247208 wrote 250
Writer 139906605247208 used 116.65433311462 seconds, avg 2.1430837014374 events/second
Writer 139906572950248 wrote 250
Writer 139906572950248 used 116.65413808823 seconds, avg 2.1430872843184 events/second
Writer 139906472676072 wrote 250
Writer 139906472676072 used 116.53968501091 seconds, avg 2.1451920002752 events/second
Writer 139906528107240 wrote 250
Writer 139906528107240 used 117.06192183495 seconds, avg 2.1356218664554 events/second
Writer 139906538912488 wrote 250
Writer 139906538912488 used 119.3428800106 seconds, avg 2.0948044824943 events/second
Writer 139906483096296 wrote 250
Writer 139906483096296 used 119.59938311577 seconds, avg 2.090311784953 events/second
Writer 139906495036136 wrote 250
Writer 139906495036136 used 120.31554818153 seconds, avg 2.0778694339887 events/second
Writer 139906472192744 wrote 250
Writer 139906472192744 used 120.64578795433 seconds, avg 2.0721817498895 events/second
Writer 139906563111656 wrote 250
Writer 139906563111656 used 121.48377513885 seconds, avg 2.0578879748695 events/second
Writer 139906515041000 wrote 250
Writer 139906515041000 used 121.61317491531 seconds, avg 2.0556983252356 events/second
Writer 139906504874728 wrote 250
Writer 139906504874728 used 121.61694693565 seconds, avg 2.0556345665565 events/second
Writer 139906562145000 wrote 250
Writer 139906562145000 used 122.11737704277 seconds, avg 2.0472106923197 events/second
Writer 139906527623912 wrote 250
Writer 139906527623912 used 122.10413599014 seconds, avg 2.0474326931905 events/second
Writer 139906562628328 wrote 250
Writer 139906562628328 used 124.47564601898 seconds, avg 2.0084250051763 events/second
Writer 139906561661672 wrote 250
Writer 139906605406952 wrote 250
Writer 139906561661672 used 125.35607600212 seconds, avg 1.9943189670022 events/second
Writer 139906605406952 used 125.39144086838 seconds, avg 1.9937564978013 events/second
Writer 139906529557224 wrote 250
Writer 139906529557224 used 126.37130403519 seconds, avg 1.9782972242685 events/second
Writer 139906572466920 wrote 250
Writer 139906572466920 used 126.45130681992 seconds, avg 1.9770456018777 events/second
Writer 139906605890280 wrote 250
Writer 139906605890280 used 126.50037097931 seconds, avg 1.9762787892606 events/second
Writer 139906695473896 wrote 250
Writer 139906695473896 used 126.50805902481 seconds, avg 1.9761586884435 events/second
Writer 139906549721832 wrote 250
Writer 139906549721832 used 126.73267507553 seconds, avg 1.9726562218544 events/second
Writer 139906481646312 wrote 250
Writer 139906481646312 used 127.0741379261 seconds, avg 1.9673554672894 events/second
Writer 139906720754408 wrote 250
Writer 139906720754408 used 127.81100702286 seconds, avg 1.9560130682273 events/second
Writer 139906515200744 wrote 250
Writer 139906515200744 used 128.51373100281 seconds, avg 1.9453174228872 events/second
Writer 139906695633640 wrote 250
Writer 139906695633640 used 128.69928598404 seconds, avg 1.9425127193868 events/second
Writer 139906494552808 wrote 250
Writer 139906494552808 used 128.51249718666 seconds, avg 1.9453360993903 events/second
Writer 139906561178344 wrote 250
Writer 139906561178344 used 128.64137816429 seconds, avg 1.9433871400283 events/second
Writer 139906548755176 wrote 250
Writer 139906548755176 used 130.3905749321 seconds, avg 1.9173164941576 events/second
Writer 139906606373608 wrote 250
Writer 139906606373608 used 130.55934810638 seconds, avg 1.9148379922692 events/second
Writer 139906528590568 wrote 250
Writer 139906528590568 used 130.45561003685 seconds, avg 1.9163606680417 events/second
Writer 139906548595432 wrote 250
Writer 139906548595432 used 130.51591515541 seconds, avg 1.9154752100716 events/second
Writer 139906549238504 wrote 250
Writer 139906549238504 used 130.63052201271 seconds, avg 1.9137946947473 events/second
Writer 139906496002792 wrote 250
Writer 139906496002792 used 130.64837598801 seconds, avg 1.9135331618891 events/second
Writer 139906505841384 wrote 250
Writer 139906505841384 used 130.95276093483 seconds, avg 1.9090853695281 events/second
Writer 139906538429160 wrote 250
Writer 139906720914152 wrote 250
Writer 139906538429160 used 131.03122711182 seconds, avg 1.907942141049 events/second
Writer 139906720914152 used 131.13969993591 seconds, avg 1.9063639776679 events/second
Writer 139906721397480 wrote 250
Writer 139906721397480 used 131.32527399063 seconds, avg 1.9036701192631 events/second
Writer 139906539395816 wrote 250
Writer 139906539395816 used 131.31542301178 seconds, avg 1.9038129281857 events/second
Writer 139906550205160 wrote 250
Writer 139906550205160 used 131.45636892319 seconds, avg 1.9017716832425 events/second
Projection 139906461866728 read 2500 events
projection 139906461866728 used 133.51770091057 seconds, avg 18.724109110256 events/second
Projection 139906471226088 read 2500 events
projection 139906471226088 used 133.62828993797 seconds, avg 18.708613282116 events/second
Projection 139906461383400 read 2500 events
projection 139906461383400 used 133.6140639782 seconds, avg 18.710605198028 events/second
Projection 139906471066344 read 2500 events
projection 139906471066344 used 133.63439106941 seconds, avg 18.707759132913 events/second
Projection 139906471709416 read 2500 events
projection 139906471709416 used 133.80006194115 seconds, avg 18.684595236583 events/second
Projection 139906460900072 read 12500 events
projection 139906460900072 used 137.14525985718 seconds, avg 91.144236505275 events/second

done. mysql avg writes 95.021444871781 events/second mysql avg reads 182.24784664661 events/second

all finished

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment