Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
ArangoDB prooph event store benchmarks
Testing databases are (Barangodb mysql postgres mariadb
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_arangodb_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 25
Running: 1
Paused: 0
Stopped: 24
Images: 388
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1333.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.90
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17636 MB memory for database.(B
Waiting for arangodb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup arangodb!(B
Your PHP Version is 7.1.10, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 1.8289589881897 seconds
test 1 using arangodb writes 546.75911622808 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.527419090271 seconds
test 2 using arangodb writes 1896.0254159291 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using arangodb took 0.48547220230103 seconds
test 3 using arangodb writes 5149.6254330332 events per second
test 4 load one stream with 2500 events
test 4 using arangodb took 0.018795013427734 seconds
test 4 using arangodb loads 133014.00446519 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.30426001548767 seconds
test 5 using arangodb loads 8216.6563884281 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.23645710945129 seconds
test 6 using arangodb loads 4229.0967792025 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Starting benchmark arangodb!(B
Your PHP Version is 7.1.10, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 1.2403399944305 seconds
test 1 using arangodb writes 806.23055330818 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.53015685081482 seconds
test 2 using arangodb writes 1886.2342313658 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using arangodb took 0.47423195838928 seconds
test 3 using arangodb writes 5271.6818336984 events per second
test 4 load one stream with 2500 events
test 4 using arangodb took 0.018671989440918 seconds
test 4 using arangodb loads 133890.39276776 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.27450513839722 seconds
test 5 using arangodb loads 9107.2976433047 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.24916100502014 seconds
test 6 using arangodb loads 4013.46912178 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Dumping logs arangodb!(B
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1
php_1 | Interactive shell
php_1 |
arangodb_1 | automaticaly choosing storage engine
arangodb_1 | Initializing database...Hang on...
arangodb_1 | Database initialized...Starting System...
arangodb_1 | 2017-12-07T22:17:49Z [1] INFO ArangoDB 3.2.6 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.0.0, OpenSSL 1.1.0f 25 May 2017
arangodb_1 | 2017-12-07T22:17:49Z [1] WARNING {memory} /sys/kernel/mm/transparent_hugepage/enabled is set to 'always'. It is recommended to set it to a value of 'never' or 'madvise'
arangodb_1 | 2017-12-07T22:17:49Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"'
arangodb_1 | 2017-12-07T22:17:49Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"'
Name Command State Ports
----------------------------------------------------------------------------------------------
eventstorebenchmarks_mysql_1 docker-entrypoint.sh mysqld Up 0.0.0.0:32768->3306/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 25
Running: 1
Paused: 0
Stopped: 24
Images: 388
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1199.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.90
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17504 MB memory for database.(B
Waiting for mysql database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup mysql!(B
mysql: set up event store tables on 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.9894750118256 seconds
test 1 using mysql writes 334.50689370015 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.79460000991821 seconds
test 2 using mysql writes 1258.4948244626 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using mysql took 0.68594694137573 seconds
test 3 using mysql writes 3644.5967598981 events per second
test 4 load one stream with 2500 events
test 4 using mysql took 0.054224014282227 seconds
test 4 using mysql loads 46105.033592458 events per second
test 5 project 1 stream with 2500 events
test 5 using mysql took 0.34087705612183 seconds
test 5 using mysql loads 7334.0225019619 events per second
test 6 project 10 stream with 100 events
test 6 using mysql took 0.2766740322113 seconds
test 6 using mysql loads 3614.3616081623 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
starting benchmarks for mysql
Writer 140547849960168 started
Writer 140547849476840 started
Writer 140547848833768 started
Writer 140547848993512 started
Writer 140547824331496 started
Writer 140547824171752 started
Writer 140547734383336 started
Writer 140547706583784 started
Writer 140547706100456 started
Writer 140547705617128 started
Writer 140547705133800 started
Writer 140547704650472 started
Writer 140547693677288 started
Writer 140547693193960 started
Writer 140547692710632 started
Writer 140547692227304 started
Writer 140547692067560 started
Writer 140547682867944 started
Writer 140547682384616 started
Writer 140547681901288 started
Writer 140547673029352 started
Writer 140547672546024 started
Writer 140547672062696 started
Writer 140547671579368 started
Writer 140547671096040 started
Writer 140547660122856 started
Writer 140547659639528 started
Writer 140547659156200 started
Writer 140547658672872 started
Writer 140547658513128 started
Writer 140547649313512 started
Writer 140547648830184 started
Writer 140547648346856 started
Writer 140547639474920 started
Writer 140547638991592 started
Writer 140547638508264 started
Writer 140547638024936 started
Writer 140547637541608 started
Writer 140547626568424 started
Writer 140547626085096 started
Writer 140547625601768 started
Writer 140547625118440 started
Writer 140547624958696 started
Writer 140547615759080 started
Writer 140547614792424 started
Writer 140547615275752 started
Writer 140547605920488 started
Writer 140547605437160 started
Writer 140547604888296 started
Writer 140547604404968 started
Projection 140547603921640 started
Projection 140547592948456 started
Projection 140547592465128 started
Projection 140547591981800 started
Projection 140547591498472 started
Projection 140547591338728 started
Writer 140547659639528 wrote 250 events
Writer 140547659639528 used 54.151919126511 seconds, avg 4.6166415527388 events/second
Writer 140547648346856 wrote 250 events
Writer 140547648346856 used 54.941977977753 seconds, avg 4.5502548179323 events/second
Writer 140547624958696 wrote 250 events
Writer 140547624958696 used 56.526174068451 seconds, avg 4.4227298967247 events/second
Writer 140547615759080 wrote 250 events
Writer 140547615759080 used 56.5637550354 seconds, avg 4.4197914343476 events/second
Writer 140547605920488 wrote 250 events
Writer 140547605920488 used 56.556204080582 seconds, avg 4.4203815313312 events/second
Writer 140547625601768 wrote 250 events
Writer 140547625601768 used 57.472043991089 seconds, avg 4.349940991115 events/second
Writer 140547671096040 wrote 250 events
Writer 140547671096040 used 58.3893699646 seconds, avg 4.281601259811 events/second
Writer 140547692227304 wrote 250 events
Writer 140547692227304 used 58.822551012039 seconds, avg 4.250070690556 events/second
Writer 140547705617128 wrote 250 events
Writer 140547705617128 used 58.987242937088 seconds, avg 4.2382045261318 events/second
Writer 140547692710632 wrote 250 events
Writer 140547692710632 used 59.279186964035 seconds, avg 4.2173317955875 events/second
Writer 140547625118440 wrote 250 events
Writer 140547625118440 used 59.258035182953 seconds, avg 4.2188371455137 events/second
Writer 140547605437160 wrote 250 events
Writer 140547605437160 used 59.235831975937 seconds, avg 4.2204184808539 events/second
Writer 140547706583784 wrote 250 events
Writer 140547706583784 used 59.564435958862 seconds, avg 4.1971353539327 events/second
Writer 140547658513128 wrote 250 events
Writer 140547658513128 used 59.473661899567 seconds, avg 4.2035413999255 events/second
Writer 140547604404968 wrote 250 events
Writer 140547604404968 used 59.390227079391 seconds, avg 4.2094467775953 events/second
Writer 140547849960168 wrote 250 events
Writer 140547849960168 used 59.698198795319 seconds, avg 4.1877310378685 events/second
Writer 140547649313512 wrote 250 events
Writer 140547649313512 used 59.902548789978 seconds, avg 4.1734451212838 events/second
Writer 140547659156200 wrote 250 events
Writer 140547659156200 used 60.295216798782 seconds, avg 4.1462658776782 events/second
Writer 140547604888296 wrote 250 events
Writer 140547604888296 used 60.338037014008 seconds, avg 4.1433233888925 events/second
Writer 140547638991592 wrote 250 events
Writer 140547638991592 used 60.401564121246 seconds, avg 4.1389656648322 events/second
Writer 140547824331496 wrote 250 events
Writer 140547824331496 used 60.683048009872 seconds, avg 4.1197666926574 events/second
Writer 140547693677288 wrote 250 events
Writer 140547693677288 used 60.883113861084 seconds, avg 4.1062288727614 events/second
Writer 140547705133800 wrote 250 events
Writer 140547705133800 used 60.893049955368 seconds, avg 4.1055588475736 events/second
Writer 140547658672872 wrote 250 events
Writer 140547658672872 used 60.814907073975 seconds, avg 4.1108342021456 events/second
Writer 140547615275752 wrote 250 events
Writer 140547615275752 used 60.820067882538 seconds, avg 4.1104853826015 events/second
Writer 140547693193960 wrote 250 events
Writer 140547693193960 used 61.014413118362 seconds, avg 4.097392521256 events/second
Writer 140547639474920 wrote 250 events
Writer 140547639474920 used 60.933643102646 seconds, avg 4.1028237812543 events/second
Writer 140547681901288 wrote 250 events
Writer 140547681901288 used 60.992466926575 seconds, avg 4.0988668371286 events/second
Writer 140547648830184 wrote 250 events
Writer 140547648830184 used 61.189512968063 seconds, avg 4.0856674268756 events/second
Writer 140547673029352 wrote 250 events
Writer 140547673029352 used 61.237680912018 seconds, avg 4.0824537486843 events/second
Writer 140547638024936 wrote 250 events
Writer 140547638024936 used 61.172850131989 seconds, avg 4.0867803193834 events/second
Writer 140547660122856 wrote 250 events
Writer 140547660122856 used 61.381540060043 seconds, avg 4.0728857528738 events/second
Writer 140547849476840 wrote 250 events
Writer 140547849476840 used 61.611419916153 seconds, avg 4.0576893105243 events/second
Writer 140547682867944 wrote 250 events
Writer 140547682867944 used 61.712352991104 seconds, avg 4.0510527938554 events/second
Writer 140547706100456 wrote 250 events
Writer 140547706100456 used 61.757020950317 seconds, avg 4.0481227260156 events/second
Writer 140547824171752 wrote 250 events
Writer 140547824171752 used 61.774753093719 seconds, avg 4.0469607320117 events/second
Writer 140547734383336 wrote 250 events
Writer 140547734383336 used 61.833904027939 seconds, avg 4.0430893686907 events/second
Writer 140547692067560 wrote 250 events
Writer 140547692067560 used 63.365316867828 seconds, avg 3.9453759936444 events/second
Writer 140547848833768 wrote 250 events
Writer 140547848833768 used 63.484030008316 seconds, avg 3.9379982645596 events/second
Writer 140547848993512 wrote 250 events
Writer 140547848993512 used 63.484191894531 seconds, avg 3.9379882225694 events/second
Writer 140547626085096 wrote 250 events
Writer 140547626085096 used 63.463243961334 seconds, avg 3.9392880728302 events/second
Writer 140547704650472 wrote 250 events
Writer 140547704650472 used 63.66152715683 seconds, avg 3.9270185803763 events/second
Writer 140547671579368 wrote 250 events
Writer 140547671579368 used 63.625928878784 seconds, avg 3.9292157207839 events/second
Writer 140547637541608 wrote 250 events
Writer 140547637541608 used 64.242670059204 seconds, avg 3.8914945435737 events/second
Writer 140547682384616 wrote 250 events
Writer 140547682384616 used 64.377182006836 seconds, avg 3.8833635180467 events/second
Writer 140547614792424 wrote 250 events
Writer 140547614792424 used 64.263059139252 seconds, avg 3.8902598685549 events/second
Writer 140547638508264 wrote 250 events
Writer 140547638508264 used 64.306173086166 seconds, avg 3.8876516514988 events/second
Writer 140547672062696 wrote 250 events
Writer 140547672062696 used 64.378154039383 seconds, avg 3.8833048839372 events/second
Writer 140547672546024 wrote 250 events
Writer 140547672546024 used 64.543506860733 seconds, avg 3.8733563166847 events/second
Writer 140547626568424 wrote 250 events
Writer 140547626568424 used 64.701232910156 seconds, avg 3.8639140052733 events/second
Projection 140547591981800 read 2500 events
projection 140547591981800 used 69.670376062393 seconds, avg 35.883256863163 events/second
Projection 140547592465128 read 2500 events
projection 140547592465128 used 69.753284931183 seconds, avg 35.840605965245 events/second
Projection 140547592948456 read 2500 events
projection 140547592948456 used 69.920627832413 seconds, avg 35.754827688219 events/second
Projection 140547591498472 read 2500 events
projection 140547591498472 used 69.971153020859 seconds, avg 35.729009628507 events/second
Projection 140547603921640 read 2500 events
projection 140547603921640 used 70.067697048187 seconds, avg 35.679779774704 events/second
Projection 140547591338728 read 12500 events
projection 140547591338728 used 76.212870121002 seconds, avg 164.01429286358 events/second
done.
mysql avg writes 192.6950745622 events/second
mysql avg reads 327.90067920649 events/second
all finished
mysql: destroying event-store tables on database event_store_tests
Starting benchmark mysql!(B
mysql: set up event store tables on 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 3.1812090873718 seconds
test 1 using mysql writes 314.34588941972 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.97397017478943 seconds
test 2 using mysql writes 1026.7254849115 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using mysql took 0.55448508262634 seconds
test 3 using mysql writes 4508.6875703827 events per second
test 4 load one stream with 2500 events
test 4 using mysql took 0.047827005386353 seconds
test 4 using mysql loads 52271.72347097 events per second
test 5 project 1 stream with 2500 events
test 5 using mysql took 0.22758507728577 seconds
test 5 using mysql loads 10984.90300777 events per second
test 6 project 10 stream with 100 events
test 6 using mysql took 0.26572012901306 seconds
test 6 using mysql loads 3763.3581005481 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
starting benchmarks for mysql
Writer 139735287167720 started
Writer 139735286684392 started
Writer 139735286201064 started
Writer 139735286041320 started
Writer 139735172582120 started
Writer 139735172098792 started
Writer 139735171615464 started
Writer 139735171455720 started
Writer 139735143357160 started
Writer 139735142873832 started
Writer 139735142390504 started
Writer 139735133518568 started
Writer 139735133035240 started
Writer 139735132551912 started
Writer 139735132068584 started
Writer 139735131585256 started
Writer 139735120612072 started
Writer 139735120128744 started
Writer 139735119645416 started
Writer 139735119162088 started
Writer 139735119002344 started
Writer 139735109802728 started
Writer 139735109319400 started
Writer 139735108836072 started
Writer 139735099964136 started
Writer 139735099480808 started
Writer 139735098997480 started
Writer 139735098514152 started
Writer 139735098030824 started
Writer 139735087057640 started
Writer 139735086574312 started
Writer 139735086090984 started
Writer 139735085607656 started
Writer 139735085447912 started
Writer 139735076248296 started
Writer 139735075764968 started
Writer 139735075281640 started
Writer 139735066409704 started
Writer 139735065926376 started
Writer 139735065443048 started
Writer 139735064959720 started
Writer 139735064476392 started
Writer 139735053503208 started
Writer 139735053019880 started
Writer 139735052536552 started
Writer 139735052053224 started
Writer 139735051893480 started
Writer 139735042145000 started
Writer 139735042693864 started
Writer 139735041661672 started
Projection 139735041501928 started
Projection 139735032273640 started
Projection 139735031790312 started
Projection 139735031306984 started
Projection 139735022435048 started
Projection 139735021951720 started
Writer 139735143357160 wrote 250 events
Writer 139735143357160 used 82.547853946686 seconds, avg 3.028546328551 events/second
Writer 139735087057640 wrote 250 events
Writer 139735087057640 used 83.388297796249 seconds, avg 2.9980225835866 events/second
Writer 139735287167720 wrote 250 events
Writer 139735287167720 used 83.818009138107 seconds, avg 2.9826525656088 events/second
Writer 139735132551912 wrote 250 events
Writer 139735132551912 used 84.801785945892 seconds, avg 2.948051119578 events/second
Writer 139735042693864 wrote 250 events
Writer 139735042693864 used 85.610254049301 seconds, avg 2.9202109347325 events/second
Writer 139735098997480 wrote 250 events
Writer 139735098997480 used 85.82272195816 seconds, avg 2.9129814843425 events/second
Writer 139735052536552 wrote 250 events
Writer 139735052536552 used 88.087182044983 seconds, avg 2.83809737349 events/second
Writer 139735131585256 wrote 250 events
Writer 139735131585256 used 88.223695993423 seconds, avg 2.8337058109494 events/second
Writer 139735041661672 wrote 250 events
Writer 139735041661672 used 90.369542837143 seconds, avg 2.7664187750792 events/second
Writer 139735286684392 wrote 250 events
Writer 139735286684392 used 90.608382225037 seconds, avg 2.7591266267076 events/second
Writer 139735052053224 wrote 250 events
Writer 139735052053224 used 91.858856916428 seconds, avg 2.72156663377 events/second
Writer 139735133035240 wrote 250 events
Writer 139735042145000 wrote 250 events
Writer 139735133035240 used 92.01048207283 seconds, avg 2.7170817320804 events/second
Writer 139735042145000 used 91.846379041672 seconds, avg 2.7219363747217 events/second
Writer 139735086574312 wrote 250 events
Writer 139735142873832 wrote 250 events
Writer 139735142873832 used 92.025088071823 seconds, avg 2.7166504834517 events/second
Writer 139735086574312 used 91.934854984283 seconds, avg 2.7193168471603 events/second
Writer 139735120128744 wrote 250 events
Writer 139735120128744 used 92.835624933243 seconds, avg 2.6929317293848 events/second
Writer 139735064959720 wrote 250 events
Writer 139735064959720 used 95.732385873795 seconds, avg 2.6114464579372 events/second
Writer 139735142390504 wrote 250 events
Writer 139735142390504 used 95.867113113403 seconds, avg 2.6077764509741 events/second
Writer 139735053503208 wrote 250 events
Writer 139735053503208 used 95.724936962128 seconds, avg 2.6116496697084 events/second
Writer 139735086090984 wrote 250 events
Writer 139735086090984 used 96.129469156265 seconds, avg 2.6006593211662 events/second
Writer 139735171615464 wrote 250 events
Writer 139735171615464 used 98.786093950272 seconds, avg 2.5307205701022 events/second
Writer 139735099964136 wrote 250 events
Writer 139735099964136 used 98.721338033676 seconds, avg 2.5323805874138 events/second
Writer 139735064476392 wrote 250 events
Writer 139735064476392 used 98.6419069767 seconds, avg 2.5344197781887 events/second
Writer 139735099480808 wrote 250 events
Writer 139735099480808 used 98.805358886719 seconds, avg 2.5302271335974 events/second
Writer 139735132068584 wrote 250 events
Writer 139735132068584 used 99.41560292244 seconds, avg 2.5146958088163 events/second
Writer 139735286201064 wrote 250 events
Writer 139735286201064 used 100.87718200684 seconds, avg 2.4782611392045 events/second
Writer 139735098514152 wrote 250 events
Writer 139735098514152 used 100.88334584236 seconds, avg 2.4781097208121 events/second
Writer 139735053019880 wrote 250 events
Writer 139735053019880 used 101.60980010033 seconds, avg 2.4603925974971 events/second
Writer 139735075764968 wrote 250 events
Writer 139735075764968 used 101.68592619896 seconds, avg 2.4585506504691 events/second
Writer 139735051893480 wrote 250 events
Writer 139735051893480 used 101.63299584389 seconds, avg 2.4598310610071 events/second
Writer 139735085447912 wrote 250 events
Writer 139735085447912 used 101.72842478752 seconds, avg 2.457523553738 events/second
Writer 139735098030824 wrote 250 events
Writer 139735098030824 used 102.34509706497 seconds, avg 2.4427159401812 events/second
Writer 139735120612072 wrote 250 events
Writer 139735120612072 used 103.30130600929 seconds, avg 2.4201049304983 events/second
Writer 139735066409704 wrote 250 events
Writer 139735066409704 used 103.35827994347 seconds, avg 2.4187709019223 events/second
Writer 139735172582120 wrote 250 events
Writer 139735172582120 used 104.04331207275 seconds, avg 2.4028454594485 events/second
Writer 139735172098792 wrote 250 events
Writer 139735172098792 used 104.5941631794 seconds, avg 2.3901907372327 events/second
Writer 139735133518568 wrote 250 events
Writer 139735133518568 used 104.92586898804 seconds, avg 2.3826345439036 events/second
Writer 139735286041320 wrote 250 events
Writer 139735286041320 used 105.06480312347 seconds, avg 2.3794838287204 events/second
Writer 139735171455720 wrote 250 events
Writer 139735171455720 used 105.13404011726 seconds, avg 2.3779167976533 events/second
Writer 139735065926376 wrote 250 events
Writer 139735065926376 used 104.9981508255 seconds, avg 2.3809943130854 events/second
Writer 139735119645416 wrote 250 events
Writer 139735119645416 used 105.09268093109 seconds, avg 2.37885262594 events/second
Writer 139735109802728 wrote 250 events
Writer 139735109802728 used 105.15814590454 seconds, avg 2.3773716990688 events/second
Writer 139735085607656 wrote 250 events
Writer 139735085607656 used 105.27369117737 seconds, avg 2.3747623665897 events/second
Writer 139735075281640 wrote 250 events
Writer 139735075281640 used 105.25716519356 seconds, avg 2.3751352180184 events/second
Writer 139735119002344 wrote 250 events
Writer 139735119002344 used 105.46464490891 seconds, avg 2.3704626343353 events/second
Writer 139735108836072 wrote 250 events
Writer 139735108836072 used 105.4605178833 seconds, avg 2.3705553985297 events/second
Writer 139735119162088 wrote 250 events
Writer 139735119162088 used 105.50512385368 seconds, avg 2.3695531635668 events/second
Writer 139735076248296 wrote 250 events
Writer 139735076248296 used 105.46307611465 seconds, avg 2.3704978956636 events/second
Writer 139735109319400 wrote 250 events
Writer 139735109319400 used 105.58250117302 seconds, avg 2.3678166099733 events/second
Writer 139735065443048 wrote 250 events
Writer 139735065443048 used 105.50166606903 seconds, avg 2.3696308249428 events/second
Projection 139735041501928 read 2500 events
projection 139735041501928 used 107.21316289902 seconds, avg 23.318032342304 events/second
Projection 139735031306984 read 2500 events
projection 139735031306984 used 107.2198870182 seconds, avg 23.316569990188 events/second
Projection 139735032273640 read 2500 events
projection 139735032273640 used 107.30941915512 seconds, avg 23.297116130935 events/second
Projection 139735022435048 read 2500 events
projection 139735022435048 used 107.37484908104 seconds, avg 23.282919802878 events/second
Projection 139735031790312 read 2500 events
projection 139735031790312 used 107.39390301704 seconds, avg 23.278788923457 events/second
Projection 139735021951720 read 12500 events
projection 139735021951720 used 112.39152503014 seconds, avg 111.21835028618 events/second
done.
mysql avg writes 118.27306010315 events/second
mysql avg reads 222.37581005466 events/second
all finished
mysql: destroying event-store tables on database event_store_tests
Dumping logs mysql!(B
Attaching to eventstorebenchmarks_mysql_1, eventstorebenchmarks_php_1
mysql_1 | Initializing database
mysql_1 | 2017-12-07T22:18:24.246779Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1 | 2017-12-07T22:18:24.924431Z 0 [Warning] InnoDB: New log files created, LSN=45790
mysql_1 | 2017-12-07T22:18:25.037040Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysql_1 | 2017-12-07T22:18:25.111530Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8afa123d-db9c-11e7-93e6-0242ac130003.
mysql_1 | 2017-12-07T22:18:25.115041Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mysql_1 | 2017-12-07T22:18:25.115847Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
mysql_1 | 2017-12-07T22:18:26.148972Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:26.149011Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:26.149024Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:26.149043Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:26.149050Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:26.149069Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:26.149126Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:26.149141Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | Database initialized
mysql_1 | Initializing certificates
mysql_1 | Generating a 2048 bit RSA private key
mysql_1 | .....................................................+++
mysql_1 | ..................................................................+++
mysql_1 | unable to write 'random state'
mysql_1 | writing new private key to 'ca-key.pem'
mysql_1 | -----
mysql_1 | Generating a 2048 bit RSA private key
mysql_1 | ...............................................................+++
mysql_1 | .....................+++
mysql_1 | unable to write 'random state'
mysql_1 | writing new private key to 'server-key.pem'
mysql_1 | -----
mysql_1 | Generating a 2048 bit RSA private key
mysql_1 | ...................................................+++
mysql_1 | ....+++
mysql_1 | unable to write 'random state'
mysql_1 | writing new private key to 'client-key.pem'
mysql_1 | -----
mysql_1 | Certificates initialized
mysql_1 | MySQL init process in progress...
mysql_1 | 2017-12-07T22:18:29.297700Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1 | 2017-12-07T22:18:29.298830Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 90 ...
mysql_1 | 2017-12-07T22:18:29.303185Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1 | 2017-12-07T22:18:29.303219Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1 | 2017-12-07T22:18:29.303226Z 0 [Note] InnoDB: Uses event mutexes
mysql_1 | 2017-12-07T22:18:29.303232Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1 | 2017-12-07T22:18:29.303241Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
php_1 | Interactive shell
mysql_1 | 2017-12-07T22:18:29.303257Z 0 [Note] InnoDB: Using Linux native AIO
php_1 |
mysql_1 | 2017-12-07T22:18:29.303631Z 0 [Note] InnoDB: Number of pools: 1
mysql_1 | 2017-12-07T22:18:29.303768Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1 | 2017-12-07T22:18:29.305778Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
mysql_1 | 2017-12-07T22:18:29.314626Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1 | 2017-12-07T22:18:29.316845Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1 | 2017-12-07T22:18:29.328980Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1 | 2017-12-07T22:18:29.339090Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1 | 2017-12-07T22:18:29.339186Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1 | 2017-12-07T22:18:29.403464Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1 | 2017-12-07T22:18:29.404696Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1 | 2017-12-07T22:18:29.404720Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
mysql_1 | 2017-12-07T22:18:29.405695Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2539315
mysql_1 | 2017-12-07T22:18:29.406661Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1 | 2017-12-07T22:18:29.407100Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1 | 2017-12-07T22:18:29.410077Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171207 22:18:29
mysql_1 | 2017-12-07T22:18:29.414448Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1 | 2017-12-07T22:18:29.414801Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1 | 2017-12-07T22:18:29.423785Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:29.423816Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:29.423826Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:29.423914Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:29.423924Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:29.423937Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:29.425389Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:29.425408Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:29.432438Z 0 [Note] Event Scheduler: Loaded 0 events
mysql_1 | 2017-12-07T22:18:29.432796Z 0 [Note] mysqld: ready for connections.
mysql_1 | Version: '5.7.19' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
mysql_1 | 2017-12-07T22:18:29.432818Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
mysql_1 | 2017-12-07T22:18:29.432823Z 0 [Note] Beginning of list of non-natively partitioned tables
mysql_1 | 2017-12-07T22:18:29.446233Z 0 [Note] End of list of non-natively partitioned tables
mysql_1 | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
mysql_1 | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
mysql_1 | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
mysql_1 | 2017-12-07T22:18:33.430815Z 5 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.430856Z 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.430877Z 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.430884Z 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.430903Z 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.430945Z 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.430968Z 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
mysql_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
mysql_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
mysql_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
mysql_1 | 2017-12-07T22:18:33.456092Z 9 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.456126Z 9 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.456152Z 9 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.456162Z 9 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.456176Z 9 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.456464Z 9 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:33.456489Z 9 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 |
mysql_1 | 2017-12-07T22:18:33.458416Z 0 [Note] Giving 0 client threads a chance to die gracefully
mysql_1 | 2017-12-07T22:18:33.458441Z 0 [Note] Shutting down slave threads
mysql_1 | 2017-12-07T22:18:33.458446Z 0 [Note] Forcefully disconnecting 0 remaining clients
mysql_1 | 2017-12-07T22:18:33.458453Z 0 [Note] Event Scheduler: Purging the queue. 0 events
mysql_1 | 2017-12-07T22:18:33.458989Z 0 [Note] Binlog end
mysql_1 | 2017-12-07T22:18:33.459785Z 0 [Note] Shutting down plugin 'ngram'
mysql_1 | 2017-12-07T22:18:33.459798Z 0 [Note] Shutting down plugin 'ARCHIVE'
mysql_1 | 2017-12-07T22:18:33.459801Z 0 [Note] Shutting down plugin 'partition'
mysql_1 | 2017-12-07T22:18:33.459804Z 0 [Note] Shutting down plugin 'BLACKHOLE'
mysql_1 | 2017-12-07T22:18:33.459807Z 0 [Note] Shutting down plugin 'MyISAM'
mysql_1 | 2017-12-07T22:18:33.459814Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
mysql_1 | 2017-12-07T22:18:33.459817Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
mysql_1 | 2017-12-07T22:18:33.459819Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
mysql_1 | 2017-12-07T22:18:33.459822Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
mysql_1 | 2017-12-07T22:18:33.459824Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
mysql_1 | 2017-12-07T22:18:33.459830Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
mysql_1 | 2017-12-07T22:18:33.459832Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
mysql_1 | 2017-12-07T22:18:33.459835Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
mysql_1 | 2017-12-07T22:18:33.459837Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
mysql_1 | 2017-12-07T22:18:33.459839Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
mysql_1 | 2017-12-07T22:18:33.459846Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
mysql_1 | 2017-12-07T22:18:33.459849Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
mysql_1 | 2017-12-07T22:18:33.459852Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
mysql_1 | 2017-12-07T22:18:33.459855Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
mysql_1 | 2017-12-07T22:18:33.459858Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
mysql_1 | 2017-12-07T22:18:33.459861Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
mysql_1 | 2017-12-07T22:18:33.459864Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
mysql_1 | 2017-12-07T22:18:33.459867Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
mysql_1 | 2017-12-07T22:18:33.459870Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
mysql_1 | 2017-12-07T22:18:33.459873Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
mysql_1 | 2017-12-07T22:18:33.459943Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
mysql_1 | 2017-12-07T22:18:33.459949Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
mysql_1 | 2017-12-07T22:18:33.459952Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
mysql_1 | 2017-12-07T22:18:33.459955Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
mysql_1 | 2017-12-07T22:18:33.459958Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
mysql_1 | 2017-12-07T22:18:33.459961Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
mysql_1 | 2017-12-07T22:18:33.459964Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
mysql_1 | 2017-12-07T22:18:33.459977Z 0 [Note] Shutting down plugin 'INNODB_CMP'
mysql_1 | 2017-12-07T22:18:33.459980Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
mysql_1 | 2017-12-07T22:18:33.459983Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
mysql_1 | 2017-12-07T22:18:33.459986Z 0 [Note] Shutting down plugin 'INNODB_TRX'
mysql_1 | 2017-12-07T22:18:33.459990Z 0 [Note] Shutting down plugin 'InnoDB'
mysql_1 | 2017-12-07T22:18:33.460138Z 0 [Note] InnoDB: FTS optimize thread exiting.
mysql_1 | 2017-12-07T22:18:33.460278Z 0 [Note] InnoDB: Starting shutdown...
mysql_1 | 2017-12-07T22:18:33.560496Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
mysql_1 | 2017-12-07T22:18:33.560960Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 171207 22:18:33
mysql_1 | 2017-12-07T22:18:35.374731Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12143451
mysql_1 | 2017-12-07T22:18:35.378648Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
mysql_1 | 2017-12-07T22:18:35.378676Z 0 [Note] Shutting down plugin 'CSV'
mysql_1 | 2017-12-07T22:18:35.378686Z 0 [Note] Shutting down plugin 'MEMORY'
mysql_1 | 2017-12-07T22:18:35.378708Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
mysql_1 | 2017-12-07T22:18:35.378763Z 0 [Note] Shutting down plugin 'sha256_password'
mysql_1 | 2017-12-07T22:18:35.378780Z 0 [Note] Shutting down plugin 'mysql_native_password'
mysql_1 | 2017-12-07T22:18:35.379029Z 0 [Note] Shutting down plugin 'binlog'
mysql_1 | 2017-12-07T22:18:35.379842Z 0 [Note] mysqld: Shutdown complete
mysql_1 |
mysql_1 |
mysql_1 | MySQL init process done. Ready for start up.
mysql_1 |
mysql_1 | 2017-12-07T22:18:35.611458Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1 | 2017-12-07T22:18:35.613112Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 1 ...
mysql_1 | 2017-12-07T22:18:35.618185Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1 | 2017-12-07T22:18:35.618216Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1 | 2017-12-07T22:18:35.618223Z 0 [Note] InnoDB: Uses event mutexes
mysql_1 | 2017-12-07T22:18:35.618231Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1 | 2017-12-07T22:18:35.618253Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
mysql_1 | 2017-12-07T22:18:35.618265Z 0 [Note] InnoDB: Using Linux native AIO
mysql_1 | 2017-12-07T22:18:35.618605Z 0 [Note] InnoDB: Number of pools: 1
mysql_1 | 2017-12-07T22:18:35.618746Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1 | 2017-12-07T22:18:35.620611Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
mysql_1 | 2017-12-07T22:18:35.631111Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1 | 2017-12-07T22:18:35.633334Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1 | 2017-12-07T22:18:35.646527Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1 | 2017-12-07T22:18:35.659630Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1 | 2017-12-07T22:18:35.659746Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1 | 2017-12-07T22:18:35.727438Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1 | 2017-12-07T22:18:35.728779Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1 | 2017-12-07T22:18:35.728811Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
mysql_1 | 2017-12-07T22:18:35.729599Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 12143451
mysql_1 | 2017-12-07T22:18:35.729960Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1 | 2017-12-07T22:18:35.730431Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1 | 2017-12-07T22:18:35.736287Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171207 22:18:35
mysql_1 | 2017-12-07T22:18:35.736297Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1 | 2017-12-07T22:18:35.736676Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1 | 2017-12-07T22:18:35.740239Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1 | 2017-12-07T22:18:35.740292Z 0 [Note] IPv6 is available.
mysql_1 | 2017-12-07T22:18:35.740309Z 0 [Note] - '::' resolves to '::';
mysql_1 | 2017-12-07T22:18:35.740353Z 0 [Note] Server socket created on IP: '::'.
mysql_1 | 2017-12-07T22:18:35.744208Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:35.744261Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:35.744319Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:35.744332Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:35.744355Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:35.747606Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:35.747630Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
mysql_1 | 2017-12-07T22:18:35.757718Z 0 [Note] Event Scheduler: Loaded 0 events
mysql_1 | 2017-12-07T22:18:35.758416Z 0 [Note] mysqld: ready for connections.
mysql_1 | Version: '5.7.19' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
mysql_1 | 2017-12-07T22:18:35.758433Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
mysql_1 | 2017-12-07T22:18:35.758438Z 0 [Note] Beginning of list of non-natively partitioned tables
mysql_1 | 2017-12-07T22:18:35.776387Z 0 [Note] End of list of non-natively partitioned tables
Name Command State Ports
-------------------------------------------------------------------------------------------------
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
eventstorebenchmarks_postgres_1 docker-entrypoint.sh postgres Up 0.0.0.0:5432->5432/tcp
Docker Info(B
Containers: 25
Running: 1
Paused: 0
Stopped: 24
Images: 388
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 933.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.90
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17500 MB memory for database.(B
Waiting for postgres database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup postgres!(B
postgres: set up event store tables on 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.495945930481 seconds
test 1 using postgres writes 668.47335831081 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.50242710113525 seconds
test 2 using postgres writes 1990.3384943616 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using postgres took 0.33961415290833 seconds
test 3 using postgres writes 7361.2951008989 events per second
test 4 load one stream with 2500 events
test 4 using postgres took 0.018508911132812 seconds
test 4 using postgres loads 135070.07419621 events per second
test 5 project 1 stream with 2500 events
test 5 using postgres took 0.20746994018555 seconds
test 5 using postgres loads 12049.938404398 events per second
test 6 project 10 stream with 100 events
test 6 using postgres took 0.26221203804016 seconds
test 6 using postgres loads 3813.7074387364 events per second
test 7 real world test
postgres: destroying event-store tables on database event_store_tests
postgres: set up event store tables on database event_store_tests
starting benchmarks for postgres
Writer 140379283643112 started
Writer 140379283159784 started
Writer 140379282676456 started
Writer 140379282516712 started
Writer 140379257367272 started
Writer 140379257207528 started
Writer 140379167062760 started
Writer 140379141376744 started
Writer 140379140893416 started
Writer 140379139926760 started
Writer 140379140410088 started
Writer 140379139767016 started
Writer 140379130567400 started
Writer 140379130084072 started
Writer 140379129600744 started
Writer 140379120728808 started
Writer 140379120245480 started
Writer 140379119762152 started
Writer 140379119278824 started
Writer 140379118795496 started
Writer 140379107822312 started
Writer 140379107338984 started
Writer 140379106855656 started
Writer 140379106372328 started
Writer 140379097012968 started
Writer 140379096529640 started
Writer 140379096046312 started
Writer 140379106212584 started
Writer 140379087174376 started
Writer 140379086691048 started
Writer 140379086207720 started
Writer 140379085724392 started
Writer 140379085241064 started
Writer 140379073784552 started
Writer 140379073301224 started
Writer 140379074267880 started
Writer 140379072817896 started
Writer 140379072658152 started
Writer 140379063458536 started
Writer 140379062975208 started
Writer 140379062491880 started
Writer 140379053619944 started
Writer 140379053136616 started
Writer 140379052653288 started
Writer 140379052169960 started
Writer 140379051686632 started
Writer 140379040713448 started
Writer 140379040230120 started
Writer 140379039746792 started
Writer 140379039197928 started
Projection 140379039038184 started
Projection 140379029838568 started
Projection 140379029355240 started
Projection 140379028871912 started
Projection 140379019999976 started
Projection 140379019516648 started
Writer 140379283643112 wrote 250 events
Writer 140379283643112 used 16.069170951843 seconds, avg 15.55774101534 events/second
Writer 140379282516712 wrote 250 events
Writer 140379282516712 used 16.280904054642 seconds, avg 15.35541264545 events/second
Writer 140379283159784 wrote 250 events
Writer 140379283159784 used 16.329739093781 seconds, avg 15.309491386498 events/second
Writer 140379257207528 wrote 250 events
Writer 140379257207528 used 16.400822162628 seconds, avg 15.243138272035 events/second
Writer 140379257367272 wrote 250 events
Writer 140379257367272 used 16.554764986038 seconds, avg 15.101392270494 events/second
Writer 140379085241064 wrote 250 events
Writer 140379085241064 used 16.573079109192 seconds, avg 15.084704438618 events/second
Writer 140379139767016 wrote 250 events
Writer 140379139767016 used 16.73561000824 seconds, avg 14.938206607164 events/second
Writer 140379062975208 wrote 250 events
Writer 140379062975208 used 16.623257875443 seconds, avg 15.039169931264 events/second
Writer 140379129600744 wrote 250 events
Writer 140379129600744 used 16.784754991531 seconds, avg 14.894468231805 events/second
Writer 140379282676456 wrote 250 events
Writer 140379282676456 used 16.905115127563 seconds, avg 14.788423392183 events/second
Writer 140379140410088 wrote 250 events
Writer 140379140410088 used 16.877748012543 seconds, avg 14.812402686319 events/second
Writer 140379120728808 wrote 250 events
Writer 140379120728808 used 16.864789962769 seconds, avg 14.82378378574 events/second
Writer 140379139926760 wrote 250 events
Writer 140379139926760 used 16.909546852112 seconds, avg 14.784547580515 events/second
Writer 140379140893416 wrote 250 events
Writer 140379140893416 used 16.934190034866 seconds, avg 14.763032627204 events/second
Writer 140379141376744 wrote 250 events
Writer 140379141376744 used 17.023998975754 seconds, avg 14.68515125947 events/second
Writer 140379130084072 wrote 250 events
Writer 140379130084072 used 17.04101395607 seconds, avg 14.670488542787 events/second
Writer 140379107338984 wrote 250 events
Writer 140379107338984 used 17.010316133499 seconds, avg 14.696963774098 events/second
Writer 140379040713448 wrote 250 events
Writer 140379040713448 used 16.885869026184 seconds, avg 14.805278876221 events/second
Writer 140379052169960 wrote 250 events
Writer 140379052169960 used 16.910838127136 seconds, avg 14.783418664438 events/second
Writer 140379053619944 wrote 250 events
Writer 140379053619944 used 16.932693004608 seconds, avg 14.764337836395 events/second
Writer 140379097012968 wrote 250 events
Writer 140379097012968 used 17.043688058853 seconds, avg 14.668186787785 events/second
Writer 140379096046312 wrote 250 events
Writer 140379096046312 used 17.043000936508 seconds, avg 14.668778164793 events/second
Writer 140379039746792 wrote 250 events
Writer 140379039746792 used 16.925825119019 seconds, avg 14.770328668887 events/second
Writer 140379072658152 wrote 250 events
Writer 140379072658152 used 16.997159004211 seconds, avg 14.708340372533 events/second
Writer 140379106855656 wrote 250 events
Writer 140379106855656 used 17.088016986847 seconds, avg 14.630135269202 events/second
Writer 140379039197928 wrote 250 events
Writer 140379039197928 used 16.930511951447 seconds, avg 14.766239834741 events/second
Writer 140379085724392 wrote 250 events
Writer 140379085724392 used 17.041379928589 seconds, avg 14.670173486397 events/second
Writer 140379130567400 wrote 250 events
Writer 140379130567400 used 17.151395082474 seconds, avg 14.576073771134 events/second
Writer 140379073301224 wrote 250 events
Writer 140379073301224 used 17.01984000206 seconds, avg 14.688739727855 events/second
Writer 140379167062760 wrote 250 events
Writer 140379167062760 used 17.191773891449 seconds, avg 14.541838531529 events/second
Writer 140379052653288 wrote 250 events
Writer 140379052653288 used 17.00828909874 seconds, avg 14.698715346891 events/second
Writer 140379073784552 wrote 250 events
Writer 140379119278824 wrote 250 events
Writer 140379119278824 used 17.156394958496 seconds, avg 14.571825876286 events/second
Writer 140379073784552 used 17.057745933533 seconds, avg 14.656098230924 events/second
Writer 140379096529640 wrote 250 events
Writer 140379096529640 used 17.119781970978 seconds, avg 14.602989712358 events/second
Writer 140379072817896 wrote 250 events
Writer 140379072817896 used 17.061003923416 seconds, avg 14.653299484732 events/second
Writer 140379053136616 wrote 250 events
Writer 140379053136616 used 17.035284996033 seconds, avg 14.675422222653 events/second
Writer 140379063458536 wrote 250 events
Writer 140379063458536 used 17.069558858871 seconds, avg 14.645955532124 events/second
Writer 140379040230120 wrote 250 events
Writer 140379040230120 used 17.035226106644 seconds, avg 14.675472954392 events/second
Writer 140379106212584 wrote 250 events
Writer 140379106212584 used 17.159815073013 seconds, avg 14.568921572655 events/second
Writer 140379087174376 wrote 250 events
Writer 140379086207720 wrote 250 events
Writer 140379086207720 used 17.142924070358 seconds, avg 14.583276398702 events/second
Writer 140379087174376 used 17.158330917358 seconds, avg 14.570181750434 events/second
Writer 140379107822312 wrote 250 events
Writer 140379107822312 used 17.19974899292 seconds, avg 14.535095837905 events/second
Writer 140379086691048 wrote 250 events
Writer 140379086691048 used 17.159368038177 seconds, avg 14.569301121334 events/second
Writer 140379062491880 wrote 250 events
Writer 140379062491880 used 17.104250907898 seconds, avg 14.616249571302 events/second
Writer 140379074267880 wrote 250 events
Writer 140379074267880 used 17.148269891739 seconds, avg 14.578730191343 events/second
Writer 140379118795496 wrote 250 events
Writer 140379118795496 used 17.246231079102 seconds, avg 14.49592081037 events/second
Writer 140379119762152 wrote 250 events
Writer 140379119762152 used 17.262326955795 seconds, avg 14.482404408177 events/second
Writer 140379120245480 wrote 250 events
Writer 140379120245480 used 17.275913953781 seconds, avg 14.47101442325 events/second
Writer 140379106372328 wrote 250 events
Writer 140379106372328 used 17.240771055222 seconds, avg 14.500511560606 events/second
Writer 140379051686632 wrote 250 events
Writer 140379051686632 used 17.124342918396 seconds, avg 14.599100309504 events/second
Projection 140379019999976 read 2500 events
projection 140379019999976 used 18.048732042313 seconds, avg 138.51388530447 events/second
Projection 140379029838568 read 2500 events
projection 140379029838568 used 18.271733999252 seconds, avg 136.82335787629 events/second
Projection 140379039038184 read 2500 events
projection 140379039038184 used 18.482279062271 seconds, avg 135.26470364271 events/second
Projection 140379028871912 read 2500 events
projection 140379028871912 used 18.467356920242 seconds, avg 135.3740013147 events/second
Projection 140379029355240 read 2500 events
projection 140379029355240 used 18.50390291214 seconds, avg 135.10663192898 events/second
Projection 140379019516648 read 12500 events
projection 140379019516648 used 23.640848875046 seconds, avg 528.74581898768 events/second
done.
postgres avg writes 718.53790320743 events/second
postgres avg reads 1055.6564886441 events/second
all finished
postgres: destroying event-store tables on database event_store_tests
Starting benchmark postgres!(B
postgres: set up event store tables on 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.4744160175323 seconds
test 1 using postgres writes 678.23462856409 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.52736616134644 seconds
test 2 using postgres writes 1896.215709872 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using postgres took 0.34541511535645 seconds
test 3 using postgres writes 7237.6682109588 events per second
test 4 load one stream with 2500 events
test 4 using postgres took 0.017620086669922 seconds
test 4 using postgres loads 141883.52457242 events per second
test 5 project 1 stream with 2500 events
test 5 using postgres took 0.20778203010559 seconds
test 5 using postgres loads 12031.839320896 events per second
test 6 project 10 stream with 100 events
test 6 using postgres took 0.25452589988708 seconds
test 6 using postgres loads 3928.8732519701 events per second
test 7 real world test
postgres: destroying event-store tables on database event_store_tests
postgres: set up event store tables on database event_store_tests
starting benchmarks for postgres
Writer 140038951811816 started
Writer 140038951328488 started
Writer 140038950845160 started
Writer 140038950685416 started
Writer 140038925130472 started
Writer 140038835673832 started
Writer 140038835190504 started
Writer 140038809516776 started
Writer 140038809033448 started
Writer 140038808550120 started
Writer 140038808066792 started
Writer 140038807583464 started
Writer 140038796610280 started
Writer 140038796126952 started
Writer 140038795643624 started
Writer 140038795160296 started
Writer 140038795000552 started
Writer 140038785800936 started
Writer 140038785317608 started
Writer 140038784834280 started
Writer 140038775962344 started
Writer 140038775479016 started
Writer 140038774995688 started
Writer 140038774512360 started
Writer 140038774029032 started
Writer 140038763055848 started
Writer 140038762572520 started
Writer 140038762089192 started
Writer 140038761605864 started
Writer 140038761446120 started
Writer 140038752246504 started
Writer 140038751763176 started
Writer 140038751279848 started
Writer 140038742407912 started
Writer 140038741924584 started
Writer 140038741441256 started
Writer 140038740957928 started
Writer 140038740474600 started
Writer 140038729501416 started
Writer 140038729018088 started
Writer 140038728051432 started
Writer 140038728534760 started
Writer 140038727891688 started
Writer 140038718692072 started
Writer 140038718208744 started
Writer 140038717725416 started
Writer 140038708853480 started
Writer 140038708370152 started
Writer 140038707337960 started
Writer 140038707886824 started
Projection 140038698433256 started
Projection 140038697949928 started
Projection 140038697466600 started
Projection 140038696983272 started
Projection 140038696499944 started
Projection 140038685526760 started
Writer 140038951811816 wrote 250 events
Writer 140038951811816 used 16.583476066589 seconds, avg 15.07524713131 events/second
Writer 140038950685416 wrote 250 events
Writer 140038950685416 used 16.750148057938 seconds, avg 14.925241205944 events/second
Writer 140038951328488 wrote 250 events
Writer 140038951328488 used 16.778558015823 seconds, avg 14.899969339691 events/second
Writer 140038835673832 wrote 250 events
Writer 140038835673832 used 16.902246952057 seconds, avg 14.790932868815 events/second
Writer 140038809516776 wrote 250 events
Writer 140038809516776 used 17.162247180939 seconds, avg 14.566856971834 events/second
Writer 140038950845160 wrote 250 events
Writer 140038950845160 used 17.297476053238 seconds, avg 14.452975638212 events/second
Writer 140038925130472 wrote 250 events
Writer 140038925130472 used 17.331259965897 seconds, avg 14.424802379742 events/second
Writer 140038835190504 wrote 250 events
Writer 140038835190504 used 17.444147825241 seconds, avg 14.331453878088 events/second
Writer 140038808550120 wrote 250 events
Writer 140038808550120 used 17.504585981369 seconds, avg 14.281971608245 events/second
Writer 140038809033448 wrote 250 events
Writer 140038809033448 used 17.573108911514 seconds, avg 14.226281829745 events/second
Writer 140038808066792 wrote 250 events
Writer 140038808066792 used 17.628019094467 seconds, avg 14.181967846771 events/second
Writer 140038807583464 wrote 250 events
Writer 140038807583464 used 17.629214048386 seconds, avg 14.181006556154 events/second
Writer 140038784834280 wrote 250 events
Writer 140038784834280 used 17.605718851089 seconds, avg 14.199931403797 events/second
Writer 140038795160296 wrote 250 events
Writer 140038795160296 used 17.684770107269 seconds, avg 14.136457442398 events/second
Writer 140038795643624 wrote 250 events
Writer 140038795643624 used 17.702835083008 seconds, avg 14.12203180043 events/second
Writer 140038796126952 wrote 250 events
Writer 140038796126952 used 17.720532178879 seconds, avg 14.107928445737 events/second
Writer 140038740957928 wrote 250 events
Writer 140038740957928 used 17.589317083359 seconds, avg 14.213172621496 events/second
Writer 140038729501416 wrote 250 events
Writer 140038729501416 used 17.589565038681 seconds, avg 14.21297226226 events/second
Writer 140038740474600 wrote 250 events
Writer 140038740474600 used 17.592520952225 seconds, avg 14.210584183979 events/second
Writer 140038795000552 wrote 250 events
Writer 140038795000552 used 17.754492998123 seconds, avg 14.080942780311 events/second
Writer 140038761605864 wrote 250 events
Writer 140038761605864 used 17.692715167999 seconds, avg 14.130109348743 events/second
Writer 140038751279848 wrote 250 events
Writer 140038751279848 used 17.665992021561 seconds, avg 14.151483805432 events/second
Writer 140038762572520 wrote 250 events
Writer 140038785800936 wrote 250 events
Writer 140038785800936 used 17.764174938202 seconds, avg 14.073268298117 events/second
Writer 140038751763176 wrote 250 events
Writer 140038751763176 used 17.685376167297 seconds, avg 14.13597300024 events/second
Writer 140038762572520 used 17.70694899559 seconds, avg 14.118750783224 events/second
Writer 140038761446120 wrote 250 events
Writer 140038761446120 used 17.704462051392 seconds, avg 14.120734042882 events/second
Writer 140038763055848 wrote 250 events
Writer 140038763055848 used 17.728344917297 seconds, avg 14.101711195616 events/second
Writer 140038785317608 wrote 250 events
Writer 140038785317608 used 17.824100017548 seconds, avg 14.025953610779 events/second
Writer 140038796610280 wrote 250 events
Writer 140038796610280 used 17.856125831604 seconds, avg 14.000797393437 events/second
Writer 140038741441256 wrote 250 events
Writer 140038741441256 used 17.733949899673 seconds, avg 14.097254216592 events/second
Writer 140038762089192 wrote 250 events
Writer 140038762089192 used 17.789531946182 seconds, avg 14.05320841247 events/second
Writer 140038775962344 wrote 250 events
Writer 140038775962344 used 17.837785005569 seconds, avg 14.015193025476 events/second
Writer 140038707886824 wrote 250 events
Writer 140038707886824 used 17.667639970779 seconds, avg 14.150163825699 events/second
Writer 140038774512360 wrote 250 events
Writer 140038774512360 used 17.820146083832 seconds, avg 14.029065689132 events/second
Writer 140038718208744 wrote 250 events
Writer 140038718208744 used 17.70493888855 seconds, avg 14.120353737097 events/second
Writer 140038774995688 wrote 250 events
Writer 140038774995688 used 17.834621906281 seconds, avg 14.017678721407 events/second
Writer 140038708853480 wrote 250 events
Writer 140038708853480 used 17.69849395752 seconds, avg 14.125495683421 events/second
Writer 140038728051432 wrote 250 events
Writer 140038728051432 used 17.758407115936 seconds, avg 14.077839209782 events/second
Writer 140038775479016 wrote 250 events
Writer 140038775479016 used 17.874837875366 seconds, avg 13.986140839047 events/second
Writer 140038728534760 wrote 250 events
Writer 140038728534760 used 17.752977848053 seconds, avg 14.082144535961 events/second
Writer 140038774029032 wrote 250 events
Writer 140038774029032 used 17.861871957779 seconds, avg 13.996293366728 events/second
Writer 140038707337960 wrote 250 events
Writer 140038707337960 used 17.722601175308 seconds, avg 14.106281438433 events/second
Writer 140038742407912 wrote 250 events
Writer 140038742407912 used 17.825021982193 seconds, avg 14.025228145567 events/second
Writer 140038717725416 wrote 250 events
Writer 140038717725416 used 17.75062584877 seconds, avg 14.084010452923 events/second
Writer 140038708370152 wrote 250 events
Writer 140038708370152 used 17.739927053452 seconds, avg 14.092504396818 events/second
Writer 140038752246504 wrote 250 events
Writer 140038752246504 used 17.844816923141 seconds, avg 14.00967020714 events/second
Writer 140038741924584 wrote 250 events
Writer 140038741924584 used 17.841091156006 seconds, avg 14.012595856047 events/second
Writer 140038718692072 wrote 250 events
Writer 140038718692072 used 17.797341108322 seconds, avg 14.047042110301 events/second
Writer 140038729018088 wrote 250 events
Writer 140038729018088 used 17.825399875641 seconds, avg 14.024930814687 events/second
Writer 140038727891688 wrote 250 events
Writer 140038727891688 used 17.822288036346 seconds, avg 14.027379620964 events/second
Projection 140038698433256 read 2500 events
projection 140038698433256 used 18.82343006134 seconds, avg 132.81320098692 events/second
Projection 140038697466600 read 2500 events
projection 140038697466600 used 18.851068973541 seconds, avg 132.61847397137 events/second
Projection 140038697949928 read 2500 events
projection 140038697949928 used 19.005942106247 seconds, avg 131.53780991358 events/second
Projection 140038696499944 read 2500 events
projection 140038696499944 used 19.268779993057 seconds, avg 129.74355412749 events/second
Projection 140038696983272 read 2500 events
projection 140038696983272 used 19.325551986694 seconds, avg 129.36241105668 events/second
Projection 140038685526760 read 12500 events
projection 140038685526760 used 27.759366035461 seconds, avg 450.29846805694 events/second
done.
postgres avg writes 691.3374515906 events/second
postgres avg reads 899.20605045917 events/second
all finished
postgres: destroying event-store tables on database event_store_tests
Dumping logs postgres!(B
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_postgres_1
php_1 | Interactive shell
php_1 |
postgres_1 | The files belonging to this database system will be owned by user "postgres".
postgres_1 | This user must also own the server process.
postgres_1 |
postgres_1 | The database cluster will be initialized with locale "en_US.utf8".
postgres_1 | The default database encoding has accordingly been set to "UTF8".
postgres_1 | The default text search configuration will be set to "english".
postgres_1 |
postgres_1 | Data page checksums are disabled.
postgres_1 |
postgres_1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
postgres_1 | creating subdirectories ... ok
postgres_1 | selecting default max_connections ... 100
postgres_1 | selecting default shared_buffers ... 128MB
postgres_1 | selecting dynamic shared memory implementation ... posix
postgres_1 | creating configuration files ... ok
postgres_1 | running bootstrap script ... ok
postgres_1 | performing post-bootstrap initialization ... ok
postgres_1 | syncing data to disk ... ok
postgres_1 |
postgres_1 | Success. You can now start the database server using:
postgres_1 |
postgres_1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
postgres_1 |
postgres_1 |
postgres_1 | WARNING: enabling "trust" authentication for local connections
postgres_1 | You can change this by editing pg_hba.conf or using the option -A, or
postgres_1 | --auth-local and --auth-host, the next time you run initdb.
postgres_1 | waiting for server to start....LOG: could not bind IPv6 socket: Cannot assign requested address
postgres_1 | HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
postgres_1 | LOG: database system was shut down at 2017-12-07 22:23:47 UTC
postgres_1 | LOG: MultiXact member wraparound protections are now enabled
postgres_1 | LOG: database system is ready to accept connections
postgres_1 | LOG: autovacuum launcher started
postgres_1 | done
postgres_1 | server started
postgres_1 | CREATE DATABASE
postgres_1 |
postgres_1 | CREATE ROLE
postgres_1 |
postgres_1 |
postgres_1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
postgres_1 |
postgres_1 | LOG: received fast shutdown request
postgres_1 | waiting for server to shut down...LOG: aborting any active transactions
postgres_1 | .LOG: autovacuum launcher shutting down
postgres_1 | LOG: shutting down
postgres_1 | LOG: database system is shut down
postgres_1 | done
postgres_1 | server stopped
postgres_1 |
postgres_1 | PostgreSQL init process complete; ready for start up.
postgres_1 |
postgres_1 | LOG: database system was shut down at 2017-12-07 22:23:48 UTC
postgres_1 | LOG: MultiXact member wraparound protections are now enabled
postgres_1 | LOG: database system is ready to accept connections
postgres_1 | LOG: autovacuum launcher started
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_mariadb_1 docker-entrypoint.sh mysqld Up 0.0.0.0:32769->3306/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 25
Running: 1
Paused: 0
Stopped: 24
Images: 388
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1333.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.90
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17495 MB memory for database.(B
Waiting for mariadb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup mariadb!(B
mariadb: set up event store tables on 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 3.3119978904724 seconds
test 1 using mariadb writes 301.93255946107 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.79111480712891 seconds
test 2 using mariadb writes 1264.039038315 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using mariadb took 0.42232179641724 seconds
test 3 using mariadb writes 5919.6565775405 events per second
test 4 load one stream with 2500 events
test 4 using mariadb took 0.024646997451782 seconds
test 4 using mariadb loads 101432.23347553 events per second
test 5 project 1 stream with 2500 events
test 5 using mariadb took 0.220782995224 seconds
test 5 using mariadb loads 11323.33582785 events per second
test 6 project 10 stream with 100 events
test 6 using mariadb took 0.23756718635559 seconds
test 6 using mariadb loads 4209.3355372034 events per second
test 7 real world test
mariadb: destroying event-store tables on database event_store_tests
mariadb: set up event store tables on database event_store_tests
starting benchmarks for mariadb
Writer 140568737864424 started
Writer 140568737381096 started
Writer 140568736897768 started
Writer 140568736738024 started
Writer 140568711912168 started
Writer 140568711752424 started
Writer 140568622340840 started
Writer 140568621857512 started
Writer 140568621697768 started
Writer 140568591473384 started
Writer 140568590990056 started
Writer 140568590506728 started
Writer 140568581634792 started
Writer 140568581151464 started
Writer 140568580668136 started
Writer 140568580184808 started
Writer 140568579701480 started
Writer 140568568728296 started
Writer 140568568244968 started
Writer 140568567761640 started
Writer 140568567278312 started
Writer 140568567118568 started
Writer 140568557918952 started
Writer 140568557435624 started
Writer 140568556952296 started
Writer 140568548080360 started
Writer 140568547597032 started
Writer 140568547113704 started
Writer 140568546630376 started
Writer 140568546147048 started
Writer 140568535173864 started
Writer 140568534690536 started
Writer 140568534207208 started
Writer 140568533723880 started
Writer 140568533564136 started
Writer 140568524364520 started
Writer 140568523881192 started
Writer 140568523397864 started
Writer 140568514525928 started
Writer 140568514042600 started
Writer 140568513559272 started
Writer 140568513075944 started
Writer 140568512592616 started
Writer 140568501619432 started
Writer 140568501136104 started
Writer 140568500652776 started
Writer 140568500169448 started
Writer 140568500009704 started
Writer 140568490744552 started
Writer 140568490261224 started
Projection 140568489777896 started
Projection 140568480905960 started
Projection 140568480422632 started
Projection 140568479939304 started
Projection 140568479455976 started
Projection 140568478972648 started
Writer 140568534207208 wrote 250 events
Writer 140568534207208 used 37.537350893021 seconds, avg 6.6600331150828 events/second
Writer 140568514042600 wrote 250 events
Writer 140568514042600 used 37.786391973495 seconds, avg 6.6161384282299 events/second
Writer 140568535173864 wrote 250 events
Writer 140568535173864 used 37.862453937531 seconds, avg 6.6028472537062 events/second
Writer 140568523397864 wrote 250 events
Writer 140568523397864 used 38.020377874374 seconds, avg 6.5754212340035 events/second
Writer 140568737864424 wrote 250 events
Writer 140568737864424 used 39.065804004669 seconds, avg 6.399458717658 events/second
Writer 140568546630376 wrote 250 events
Writer 140568546630376 used 39.274919033051 seconds, avg 6.3653854967752 events/second
Writer 140568557435624 wrote 250 events
Writer 140568557435624 used 39.642992019653 seconds, avg 6.3062848504487 events/second
Writer 140568591473384 wrote 250 events
Writer 140568591473384 used 39.993427991867 seconds, avg 6.2510270450145 events/second
Writer 140568548080360 wrote 250 events
Writer 140568622340840 wrote 250 events
Writer 140568622340840 used 40.007610082626 seconds, avg 6.2488111507707 events/second
Writer 140568548080360 used 39.925539016724 seconds, avg 6.26165622699 events/second
Writer 140568512592616 wrote 250 events
Writer 140568512592616 used 39.863406896591 seconds, avg 6.2714158036848 events/second
Writer 140568513075944 wrote 250 events
Writer 140568513075944 used 39.867701053619 seconds, avg 6.2707403083957 events/second
Writer 140568567278312 wrote 250 events
Writer 140568567278312 used 40.084555864334 seconds, avg 6.2368160157773 events/second
Writer 140568534690536 wrote 250 events
Writer 140568534690536 used 40.134521961212 seconds, avg 6.2290513947472 events/second
Writer 140568501136104 wrote 250 events
Writer 140568501136104 used 40.258665084839 seconds, avg 6.2098432591633 events/second
Writer 140568490261224 wrote 250 events
Writer 140568490261224 used 40.476600170135 seconds, avg 6.1764080715567 events/second
Writer 140568501619432 wrote 250 events
Writer 140568501619432 used 40.50052022934 seconds, avg 6.1727602160254 events/second
Writer 140568711752424 wrote 250 events
Writer 140568556952296 wrote 250 events
Writer 140568711752424 used 41.050781011581 seconds, avg 6.0900181151114 events/second
Writer 140568556952296 used 40.96790099144 seconds, avg 6.1023385125891 events/second
Writer 140568737381096 wrote 250 events
Writer 140568737381096 used 41.197340965271 seconds, avg 6.0683528145845 events/second
Writer 140568621697768 wrote 250 events
Writer 140568621697768 used 41.397705078125 seconds, avg 6.0389821012591 events/second
Writer 140568590506728 wrote 250 events
Writer 140568590506728 used 41.383427858353 seconds, avg 6.0410655409141 events/second
Writer 140568547597032 wrote 250 events
Writer 140568547597032 used 41.486763000488 seconds, avg 6.0260184675545 events/second
Writer 140568500169448 wrote 250 events
Writer 140568500169448 used 41.41418504715 seconds, avg 6.0365790058497 events/second
Writer 140568513559272 wrote 250 events
Writer 140568513559272 used 41.564789056778 seconds, avg 6.0147063337311 events/second
Writer 140568580184808 wrote 250 events
Writer 140568580184808 used 41.725461006165 seconds, avg 5.9915455448908 events/second
Writer 140568580668136 wrote 250 events
Writer 140568568244968 wrote 250 events
Writer 140568580668136 used 41.744252920151 seconds, avg 5.9888483446621 events/second
Writer 140568568244968 used 41.726536035538 seconds, avg 5.9913911805926 events/second
Writer 140568523881192 wrote 250 events
Writer 140568523881192 used 41.826336145401 seconds, avg 5.9770953671611 events/second
Writer 140568736897768 wrote 250 events
Writer 140568736897768 used 42.066718816757 seconds, avg 5.9429403345909 events/second
Writer 140568514525928 wrote 250 events
Writer 140568514525928 used 41.995887041092 seconds, avg 5.9529639118083 events/second
Writer 140568581151464 wrote 250 events
Writer 140568581151464 used 42.160407066345 seconds, avg 5.9297340181415 events/second
Writer 140568500652776 wrote 250 events
Writer 140568500652776 used 42.037349939346 seconds, avg 5.9470922967483 events/second
Writer 140568557918952 wrote 250 events
Writer 140568557918952 used 42.122467041016 seconds, avg 5.9350749745158 events/second
Writer 140568711912168 wrote 250 events
Writer 140568711912168 used 42.459563970566 seconds, avg 5.8879549534071 events/second
Writer 140568490744552 wrote 250 events
Writer 140568490744552 used 42.283264160156 seconds, avg 5.9125047454491 events/second
Writer 140568567118568 wrote 250 events
Writer 140568546147048 wrote 250 events
Writer 140568546147048 used 42.407739877701 seconds, avg 5.8951502890975 events/second
Writer 140568567118568 used 42.435261011124 seconds, avg 5.8913270248171 events/second
Writer 140568524364520 wrote 250 events
Writer 140568524364520 used 42.451804161072 seconds, avg 5.8890312188251 events/second
Writer 140568736738024 wrote 250 events
Writer 140568567761640 wrote 250 events
Writer 140568736738024 used 42.656399965286 seconds, avg 5.8607852562206 events/second
Writer 140568567761640 used 42.581051826477 seconds, avg 5.8711560489107 events/second
Writer 140568500009704 wrote 250 events
Writer 140568500009704 used 42.478311061859 seconds, avg 5.8853564030815 events/second
Writer 140568621857512 wrote 250 events
Writer 140568621857512 used 42.66548204422 seconds, avg 5.8595376876533 events/second
Writer 140568568728296 wrote 250 events
Writer 140568568728296 used 42.619252204895 seconds, avg 5.8658936294355 events/second
Writer 140568547113704 wrote 250 events
Writer 140568547113704 used 42.706958055496 seconds, avg 5.8538470399866 events/second
Writer 140568590990056 wrote 250 events
Writer 140568590990056 used 42.766444921494 seconds, avg 5.84570451107 events/second
Writer 140568581634792 wrote 250 events
Writer 140568581634792 used 42.796881914139 seconds, avg 5.8415470664793 events/second
Writer 140568579701480 wrote 250 events
Writer 140568579701480 used 42.85785984993 seconds, avg 5.8332357442811 events/second
Writer 140568533723880 wrote 250 events
Writer 140568533723880 used 42.839195966721 seconds, avg 5.835777127895 events/second
Writer 140568533564136 wrote 250 events
Writer 140568533564136 used 42.860360145569 seconds, avg 5.8328954575023 events/second
Error 22001.
Error-Info: Data too long for column 'position' at row 1
#0 /app/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(827): Prooph\EventStore\Pdo\Exception\RuntimeException::fromStatementErrorInfo(Array)
#1 /app/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(583): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->persist()
#2 /app/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(488): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->handleStreamWithSingleHandler('blog-8d78df7b-9...', Object(Prooph\EventStore\Pdo\PdoStreamIterator))
#3 /app/src/AllProjector.php(48): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->run()
#4 [internal function]: Prooph\EventStoreBenchmarks\AllProjector->run()
#5 {main}Projection 140568479939304 read 2500 events
projection 140568479939304 used 43.737995862961 seconds, avg 57.158540318879 events/second
Projection 140568480905960 read 2500 events
projection 140568480905960 used 43.892452955246 seconds, avg 56.957400001068 events/second
Projection 140568480422632 read 2500 events
projection 140568480422632 used 43.891645908356 seconds, avg 56.958447291312 events/second
Projection 140568479455976 read 2500 events
projection 140568479455976 used 43.891802072525 seconds, avg 56.958244636871 events/second
Projection 140568489777896 read 2500 events
projection 140568489777896 used 43.922585964203 seconds, avg 56.918324482022 events/second
done.
mariadb avg writes 290.60997664325 events/second
mariadb avg reads 569.09638429585 events/second
all finished
mariadb: destroying event-store tables on database event_store_tests
Starting benchmark mariadb!(B
mariadb: set up event store tables on 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 3.1186609268188 seconds
test 1 using mariadb writes 320.65044051456 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.79399418830872 seconds
test 2 using mariadb writes 1259.4550624232 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using mariadb took 0.44675302505493 seconds
test 3 using mariadb writes 5595.9330095025 events per second
test 4 load one stream with 2500 events
test 4 using mariadb took 0.030411005020142 seconds
test 4 using mariadb loads 82207.082546079 events per second
test 5 project 1 stream with 2500 events
test 5 using mariadb took 0.25538015365601 seconds
test 5 using mariadb loads 9789.3276521694 events per second
test 6 project 10 stream with 100 events
test 6 using mariadb took 0.2421669960022 seconds
test 6 using mariadb loads 4129.3818584219 events per second
test 7 real world test
mariadb: destroying event-store tables on database event_store_tests
mariadb: set up event store tables on database event_store_tests
starting benchmarks for mariadb
Writer 139913277815528 started
Writer 139913277332200 started
Writer 139913276848872 started
Writer 139913276689128 started
Writer 139913251539688 started
Writer 139913162713832 started
Writer 139913162230504 started
Writer 139913161747176 started
Writer 139913161263848 started
Writer 139913128811240 started
Writer 139913129294568 started
Writer 139913128327912 started
Writer 139913127844584 started
Writer 139913127361256 started
Writer 139913116388072 started
Writer 139913115904744 started
Writer 139913115421416 started
Writer 139913114938088 started
Writer 139913114778344 started
Writer 139913105578728 started
Writer 139913105095400 started
Writer 139913104612072 started
Writer 139913095740136 started
Writer 139913095256808 started
Writer 139913094773480 started
Writer 139913094290152 started
Writer 139913093806824 started
Writer 139913082833640 started
Writer 139913082350312 started
Writer 139913081866984 started
Writer 139913081383656 started
Writer 139913081223912 started
Writer 139913072024296 started
Writer 139913071057640 started
Writer 139913071540968 started
Writer 139913062185704 started
Writer 139913061702376 started
Writer 139913061219048 started
Writer 139913060735720 started
Writer 139913060252392 started
Writer 139913049279208 started
Writer 139913048795880 started
Writer 139913048312552 started
Writer 139913047829224 started
Writer 139913047669480 started
Writer 139913038469864 started
Writer 139913037986536 started
Writer 139913037503208 started
Writer 139913037277928 started
Writer 139913028049640 started
Projection 139913027566312 started
Projection 139913027082984 started
Projection 139913018211048 started
Projection 139913017727720 started
Projection 139913017244392 started
Projection 139913016761064 started
Writer 139913116388072 wrote 250 events
Writer 139913116388072 used 38.758584022522 seconds, avg 6.4501840380631 events/second
Writer 139913082350312 wrote 250 events
Writer 139913082350312 used 39.801561117172 seconds, avg 6.2811606626188 events/second
Writer 139913114778344 wrote 250 events
Writer 139913114778344 used 40.353677034378 seconds, avg 6.1952223037078 events/second
Writer 139913081866984 wrote 250 events
Writer 139913081866984 used 40.611402988434 seconds, avg 6.1559065090955 events/second
Writer 139913162713832 wrote 250 events
Writer 139913162713832 used 41.636567115784 seconds, avg 6.0043374686678 events/second
Writer 139913095256808 wrote 250 events
Writer 139913095256808 used 41.648880004883 seconds, avg 6.0025623731224 events/second
Writer 139913071540968 wrote 250 events
Writer 139913071540968 used 41.779442071915 seconds, avg 5.9838041774152 events/second
Writer 139913061702376 wrote 250 events
Writer 139913061702376 used 41.792380094528 seconds, avg 5.9819517202547 events/second
Writer 139913037277928 wrote 250 events
Writer 139913037277928 used 41.813197851181 seconds, avg 5.9789734545008 events/second
Writer 139913081223912 wrote 250 events
Writer 139913081223912 used 42.272763967514 seconds, avg 5.9139733610067 events/second
Writer 139913028049640 wrote 250 events
Writer 139913028049640 used 42.206089019775 seconds, avg 5.9233159434143 events/second
Writer 139913047829224 wrote 250 events
Writer 139913047829224 used 42.231163978577 seconds, avg 5.9197989457933 events/second
Writer 139913162230504 wrote 250 events
Writer 139913162230504 used 42.702315092087 seconds, avg 5.8544835206447 events/second
Writer 139913094290152 wrote 250 events
Writer 139913094290152 used 42.920773029327 seconds, avg 5.8246853995192 events/second
Writer 139913104612072 wrote 250 events
Writer 139913104612072 used 43.047511100769 seconds, avg 5.8075366869592 events/second
Writer 139913060735720 wrote 250 events
Writer 139913060735720 used 43.039623022079 seconds, avg 5.8086010621364 events/second
Writer 139913038469864 wrote 250 events
Writer 139913038469864 used 43.014670133591 seconds, avg 5.8119706421919 events/second
Writer 139913105095400 wrote 250 events
Writer 139913105095400 used 43.17388510704 seconds, avg 5.7905374830219 events/second
Writer 139913251539688 wrote 250 events
Writer 139913251539688 used 43.240812063217 seconds, avg 5.781575046151 events/second
Writer 139913049279208 wrote 250 events
Writer 139913049279208 used 43.480051994324 seconds, avg 5.7497631335086 events/second
Writer 139913161263848 wrote 250 events
Writer 139913161263848 used 43.597694158554 seconds, avg 5.7342482171376 events/second
Writer 139913060252392 wrote 250 events
Writer 139913060252392 used 43.604636192322 seconds, avg 5.7333353017178 events/second
Writer 139913048795880 wrote 250 events
Writer 139913048795880 used 43.598115921021 seconds, avg 5.734192744771 events/second
Writer 139913127844584 wrote 250 events
Writer 139913127844584 used 43.866117954254 seconds, avg 5.6991594346396 events/second
Writer 139913081383656 wrote 250 events
Writer 139913081383656 used 43.801274061203 seconds, avg 5.7075965336232 events/second
Writer 139913047669480 wrote 250 events
Writer 139913047669480 used 43.749048948288 seconds, avg 5.7144099359852 events/second
Writer 139913095740136 wrote 250 events
Writer 139913095740136 used 43.92388010025 seconds, avg 5.6916647488657 events/second
Writer 139913114938088 wrote 250 events
Writer 139913114938088 used 43.9625248909 seconds, avg 5.6866615514104 events/second
Writer 139913276848872 wrote 250 events
Writer 139913276848872 used 44.27799487114 seconds, avg 5.646145466333 events/second
Writer 139913105578728 wrote 250 events
Writer 139913105578728 used 44.212666034698 seconds, avg 5.6544882365564 events/second
Writer 139913128327912 wrote 250 events
Writer 139913128327912 used 44.324329137802 seconds, avg 5.6402432899269 events/second
Writer 139913277815528 wrote 250 events
Writer 139913277815528 used 44.374176979065 seconds, avg 5.6339073087022 events/second
Writer 139913161747176 wrote 250 events
Writer 139913161747176 used 44.471426963806 seconds, avg 5.6215870968896 events/second
Writer 139913093806824 wrote 250 events
Writer 139913093806824 used 44.411391973495 seconds, avg 5.6291863166369 events/second
Writer 139913061219048 wrote 250 events
Writer 139913061219048 used 44.43487405777 seconds, avg 5.6262115129431 events/second
Writer 139913072024296 wrote 250 events
Writer 139913072024296 used 44.455351829529 seconds, avg 5.6236198727808 events/second
Writer 139913062185704 wrote 250 events
Writer 139913062185704 used 44.50724196434 seconds, avg 5.6170634028571 events/second
Writer 139913115421416 wrote 250 events
Writer 139913115421416 used 44.579988002777 seconds, avg 5.6078974266307 events/second
Writer 139913129294568 wrote 250 events
Writer 139913129294568 used 44.743769168854 seconds, avg 5.5873701443558 events/second
Writer 139913128811240 wrote 250 events
Writer 139913128811240 used 44.747557163239 seconds, avg 5.5868971592796 events/second
Writer 139913127361256 wrote 250 events
Writer 139913127361256 used 44.737622976303 seconds, avg 5.5881377544896 events/second
Writer 139913071057640 wrote 250 events
Writer 139913071057640 used 44.686691999435 seconds, avg 5.5945067494179 events/second
Writer 139913082833640 wrote 250 events
Writer 139913082833640 used 44.741767168045 seconds, avg 5.5876201550338 events/second
Writer 139913115904744 wrote 250 events
Writer 139913115904744 used 44.789233922958 seconds, avg 5.5816985043777 events/second
Writer 139913276689128 wrote 250 events
Writer 139913276689128 used 45.069127082825 seconds, avg 5.5470344375778 events/second
Writer 139913037986536 wrote 250 events
Writer 139913037986536 used 44.908092021942 seconds, avg 5.5669254413625 events/second
Writer 139913048312552 wrote 250 events
Writer 139913048312552 used 44.996304035187 seconds, avg 5.5560118849873 events/second
Writer 139913277332200 wrote 250 events
Writer 139913277332200 used 45.210836172104 seconds, avg 5.5296477828529 events/second
Writer 139913037503208 wrote 250 events
Writer 139913037503208 used 45.098804950714 seconds, avg 5.5433841378549 events/second
Writer 139913094773480 wrote 250 events
Writer 139913094773480 used 45.218142032623 seconds, avg 5.5287543619027 events/second
Error 22001.
Error-Info: Data too long for column 'position' at row 1
#0 /app/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(827): Prooph\EventStore\Pdo\Exception\RuntimeException::fromStatementErrorInfo(Array)
#1 /app/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(583): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->persist()
#2 /app/vendor/prooph/pdo-event-store/src/Projection/PdoEventStoreProjector.php(488): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->handleStreamWithSingleHandler('blog-b9f17f40-2...', Object(Prooph\EventStore\Pdo\PdoStreamIterator))
#3 /app/src/AllProjector.php(48): Prooph\EventStore\Pdo\Projection\PdoEventStoreProjector->run()
#4 [internal function]: Prooph\EventStoreBenchmarks\AllProjector->run()
#5 {main}Projection 139913017727720 read 2500 events
projection 139913017727720 used 46.005482196808 seconds, avg 54.341349783167 events/second
Projection 139913027566312 read 2500 events
projection 139913027566312 used 46.043678998947 seconds, avg 54.296269419678 events/second
Projection 139913027082984 read 2500 events
projection 139913027082984 used 46.129425048828 seconds, avg 54.195342720048 events/second
Projection 139913017244392 read 2500 events
projection 139913017244392 used 46.141772985458 seconds, avg 54.180839578659 events/second
Projection 139913018211048 read 2500 events
projection 139913018211048 used 46.18706703186 seconds, avg 54.12770631821 events/second
done.
mariadb avg writes 275.80029577326 events/second
mariadb avg reads 541.11575017221 events/second
all finished
mariadb: destroying event-store tables on database event_store_tests
Dumping logs mariadb!(B
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_mariadb_1
mariadb_1 | Initializing database
mariadb_1 |
mariadb_1 | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
php_1 | Interactive shell
php_1 |
mariadb_1 | To do so, start the server, then issue the following commands:
mariadb_1 |
mariadb_1 | '/usr/bin/mysqladmin' -u root password 'new-password'
mariadb_1 | '/usr/bin/mysqladmin' -u root -h password 'new-password'
mariadb_1 |
mariadb_1 | Alternatively you can run:
mariadb_1 | '/usr/bin/mysql_secure_installation'
mariadb_1 |
mariadb_1 | which will also give you the option of removing the test
mariadb_1 | databases and anonymous user created by default. This is
mariadb_1 | strongly recommended for production servers.
mariadb_1 |
mariadb_1 | See the MariaDB Knowledgebase at http://mariadb.com/kb or the
mariadb_1 | MySQL manual for more instructions.
mariadb_1 |
mariadb_1 | Please report any problems at http://mariadb.org/jira
mariadb_1 |
mariadb_1 | The latest information about MariaDB is available at http://mariadb.org/.
mariadb_1 | You can find additional information about the MySQL part at:
mariadb_1 | http://dev.mysql.com
mariadb_1 | Consider joining MariaDB's strong and vibrant community:
mariadb_1 | https://mariadb.org/get-involved/
mariadb_1 |
mariadb_1 | Database initialized
mariadb_1 | MySQL init process in progress...
mariadb_1 | 2017-12-07 22:25:39 0 [Note] mysqld (mysqld 10.3.1-MariaDB-10.3.1+maria~jessie) starting as process 99 ...
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Uses event mutexes
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Using Linux native AIO
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Number of pools: 1
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Completed initialization of buffer pool
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Waiting for purge to start
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: 5.7.19 started; log sequence number 1622414
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mariadb_1 | 2017-12-07 22:25:39 0 [Note] InnoDB: Buffer pool(s) load completed at 171207 22:25:39
mariadb_1 | 2017-12-07 22:25:39 0 [Note] Plugin 'FEEDBACK' is disabled.
mariadb_1 | 2017-12-07 22:25:39 0 [Warning] 'user' entry 'root@7346c207af9b' ignored in --skip-name-resolve mode.
mariadb_1 | 2017-12-07 22:25:39 0 [Warning] 'proxies_priv' entry '@% root@7346c207af9b' ignored in --skip-name-resolve mode.
mariadb_1 | 2017-12-07 22:25:39 0 [Note] Reading of all Master_info entries succeded
mariadb_1 | 2017-12-07 22:25:39 0 [Note] Added new Master_info '' to hash table
mariadb_1 | 2017-12-07 22:25:39 0 [Note] mysqld: ready for connections.
mariadb_1 | Version: '10.3.1-MariaDB-10.3.1+maria~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
mariadb_1 | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
mariadb_1 | 2017-12-07 22:25:43 10 [Warning] 'proxies_priv' entry '@% root@7346c207af9b' ignored in --skip-name-resolve mode.
mariadb_1 | 2017-12-07 22:25:43 14 [Warning] 'proxies_priv' entry '@% root@7346c207af9b' ignored in --skip-name-resolve mode.
mariadb_1 |
mariadb_1 | 2017-12-07 22:25:43 0 [Note] mysqld (unknown): Normal shutdown
mariadb_1 |
mariadb_1 | 2017-12-07 22:25:43 0 [Note] Event Scheduler: Purging the queue. 0 events
mariadb_1 | 2017-12-07 22:25:43 0 [Note] InnoDB: FTS optimize thread exiting.
mariadb_1 | 2017-12-07 22:25:43 0 [Note] InnoDB: Starting shutdown...
mariadb_1 | 2017-12-07 22:25:43 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
mariadb_1 | 2017-12-07 22:25:43 0 [Note] InnoDB: Buffer pool(s) dump completed at 171207 22:25:43
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Shutdown completed; log sequence number 1622442
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
mariadb_1 | 2017-12-07 22:25:44 0 [Note] mysqld: Shutdown complete
mariadb_1 |
mariadb_1 |
mariadb_1 | MySQL init process done. Ready for start up.
mariadb_1 |
mariadb_1 | 2017-12-07 22:25:44 0 [Note] mysqld (mysqld 10.3.1-MariaDB-10.3.1+maria~jessie) starting as process 1 ...
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Uses event mutexes
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Using Linux native AIO
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Number of pools: 1
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Completed initialization of buffer pool
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Waiting for purge to start
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: 5.7.19 started; log sequence number 1622442
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mariadb_1 | 2017-12-07 22:25:44 0 [Note] InnoDB: Buffer pool(s) load completed at 171207 22:25:44
mariadb_1 | 2017-12-07 22:25:44 0 [Note] Plugin 'FEEDBACK' is disabled.
mariadb_1 | 2017-12-07 22:25:44 0 [Note] Server socket created on IP: '::'.
mariadb_1 | 2017-12-07 22:25:44 0 [Warning] 'proxies_priv' entry '@% root@7346c207af9b' ignored in --skip-name-resolve mode.
mariadb_1 | 2017-12-07 22:25:44 0 [Note] Reading of all Master_info entries succeded
mariadb_1 | 2017-12-07 22:25:44 0 [Note] Added new Master_info '' to hash table
mariadb_1 | 2017-12-07 22:25:44 0 [Note] mysqld: ready for connections.
mariadb_1 | Version: '10.3.1-MariaDB-10.3.1+maria~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
VST 1.1 - ArangoDB 3.3-beta
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_arangodb_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 25
Running: 1
Paused: 0
Stopped: 24
Images: 389
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1066.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.83
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 14041 MB memory for database.(B
Waiting for arangodb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup arangodb!(B
Your PHP Version is 7.1.10, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 2.4199869632721 seconds
test 1 using arangodb writes 413.225366573 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.59560608863831 seconds
test 2 using arangodb writes 1678.9620171383 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using arangodb took 0.11385798454285 seconds
test 3 using arangodb writes 21957.17770728 events per second
test 4 load one stream with 2500 events
test 4 using arangodb took 0.009984016418457 seconds
test 4 using arangodb loads 250400.22924826 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.067672967910767 seconds
test 5 using arangodb loads 36942.372666387 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.29150104522705 seconds
test 6 using arangodb loads 3430.5194316579 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Starting benchmark arangodb!(B
Your PHP Version is 7.1.10, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 1.829530954361 seconds
test 1 using arangodb writes 546.58818295277 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.6960620880127 seconds
test 2 using arangodb writes 1436.6534497735 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using arangodb took 0.11731004714966 seconds
test 3 using arangodb writes 21311.047610531 events per second
test 4 load one stream with 2500 events
test 4 using arangodb took 0.0076758861541748 seconds
test 4 using arangodb loads 325695.29430036 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.07342004776001 seconds
test 5 using arangodb loads 34050.645242997 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.26591277122498 seconds
test 6 using arangodb loads 3760.6317116448 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Dumping logs arangodb!(B
Attaching to eventstorebenchmarks_arangodb_1, eventstorebenchmarks_php_1
php_1 | Interactive shell
php_1 |
arangodb_1 | automaticaly choosing storage engine
arangodb_1 | Initializing database...Hang on...
arangodb_1 | Database initialized...Starting System...
arangodb_1 | 2017-12-08T16:52:07Z [1] INFO ArangoDB 3.3.beta1 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.492.77, OpenSSL 1.1.0f 25 May 2017
arangodb_1 | 2017-12-08T16:52:07Z [1] INFO detected operating system: Linux version 4.8.12-040812-generic (kernel@tangerine) (gcc version 6.2.0 20161005 (Ubuntu 6.2.0-5ubuntu12) ) #201612020431 SMP Fri Dec 2 09:33:31 UTC 2016
arangodb_1 | 2017-12-08T16:52:07Z [1] WARNING {memory} maximum number of memory mappings per process is 65530, which seems too low. it is recommended to set it to at least 512000
arangodb_1 | 2017-12-08T16:52:07Z [1] WARNING {memory} execute 'sudo sysctl -w "vm.max_map_count=512000"'
arangodb_1 | 2017-12-08T16:52:07Z [1] WARNING {memory} /sys/kernel/mm/transparent_hugepage/enabled is set to 'always'. It is recommended to set it to a value of 'never' or 'madvise'
arangodb_1 | 2017-12-08T16:52:07Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"'
arangodb_1 | 2017-12-08T16:52:07Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"'
arangodb_1 | 2017-12-08T16:52:07Z [1] INFO using storage engine mmfiles
arangodb_1 | 2017-12-08T16:52:07Z [1] INFO {cluster} Starting up with role SINGLE
arangodb_1 | 2017-12-08T16:52:07Z [1] INFO {syscall} file-descriptors (nofiles) hard limit is 1048576, soft limit is 1048576
arangodb_1 | 2017-12-08T16:52:07Z [1] INFO {authentication} Authentication is turned off, authentication for unix sockets is turned on
arangodb_1 | 2017-12-08T16:52:08Z [1] INFO using endpoint 'http+tcp://0.0.0.0:8529' for non-encrypted requests
arangodb_1 | 2017-12-08T16:52:08Z [1] INFO You are using a milestone/alpha/beta/preview version ('3.3.beta1') of ArangoDB
arangodb_1 | 2017-12-08T16:52:08Z [1] INFO ArangoDB (version 3.3.beta1 [linux]) is ready for business. Have fun!
VST 1.1 - ArangoDB 3.2.9
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_arangodb_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 25
Running: 1
Paused: 0
Stopped: 24
Images: 389
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1066.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.92
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17446 MB memory for database.(B
Waiting for arangodb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup arangodb!(B
Your PHP Version is 7.1.10, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.67568612098694 seconds
test 1 using arangodb writes 1479.9771209439 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.52561593055725 seconds
test 2 using arangodb writes 1902.5298547169 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using arangodb took 0.1190710067749 seconds
test 3 using arangodb writes 20995.87521525 events per second
test 4 load one stream with 2500 events
test 4 using arangodb took 0.011968851089478 seconds
test 4 using arangodb loads 208875.52040796 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.072605848312378 seconds
test 5 using arangodb loads 34432.487989728 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.28829789161682 seconds
test 6 using arangodb loads 3468.6344544243 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Starting benchmark arangodb!(B
Your PHP Version is 7.1.10, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.63890695571899 seconds
test 1 using arangodb writes 1565.1731305299 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.52063894271851 seconds
test 2 using arangodb writes 1920.7168691195 events per second
test 3 create one stream with 2500 events using a single commit
test 3 using arangodb took 0.10928297042847 seconds
test 3 using arangodb writes 22876.39135538 events per second
test 4 load one stream with 2500 events
test 4 using arangodb took 0.012287855148315 seconds
test 4 using arangodb loads 203452.91914861 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.073054075241089 seconds
test 5 using arangodb loads 34221.225739285 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.26895594596863 seconds
test 6 using arangodb loads 3718.0810277258 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Dumping logs arangodb!(B
Attaching to eventstorebenchmarks_arangodb_1, eventstorebenchmarks_php_1
php_1 | Interactive shell
php_1 |
arangodb_1 | automaticaly choosing storage engine
arangodb_1 | Initializing database...Hang on...
arangodb_1 | Database initialized...Starting System...
arangodb_1 | 2017-12-08T22:17:23Z [1] INFO ArangoDB 3.2.6 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.0.0, OpenSSL 1.1.0f 25 May 2017
arangodb_1 | 2017-12-08T22:17:23Z [1] WARNING {memory} /sys/kernel/mm/transparent_hugepage/enabled is set to 'always'. It is recommended to set it to a value of 'never' or 'madvise'
arangodb_1 | 2017-12-08T22:17:23Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"'
arangodb_1 | 2017-12-08T22:17:23Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"'
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_arangodb_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 44
Running: 1
Paused: 0
Stopped: 43
Images: 436
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1600.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3192.11
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17589 MB memory for database.(B
Waiting for arangodb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.53900194168091 seconds
test 1 using arangodb writes 1855.2808861531 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.41492891311646 seconds
test 2 using arangodb writes 2410.0513808237 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.017341136932373 seconds
test 4 using arangodb loads 144165.86465752 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.26909899711609 seconds
test 5 using arangodb loads 9290.261304547 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.22547698020935 seconds
test 6 using arangodb loads 4435.0425443499 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Starting benchmark arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.5004940032959 seconds
test 1 using arangodb writes 1998.0259372035 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.37166094779968 seconds
test 2 using arangodb writes 2690.6243605098 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.015625953674316 seconds
test 4 using arangodb loads 159990.23497101 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.27049016952515 seconds
test 5 using arangodb loads 9242.4800664247 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.27126288414001 seconds
test 6 using arangodb loads 3686.4608410041 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Dumping logs arangodb!(B
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1
php_1 | Interactive shell
php_1 |
arangodb_1 | automaticaly choosing storage engine
arangodb_1 | Initializing database...Hang on...
arangodb_1 | Database initialized...Starting System...
arangodb_1 | 2017-12-10T20:07:20Z [1] INFO ArangoDB 3.2.9 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.492.77, OpenSSL 1.1.0f 25 May 2017
arangodb_1 | 2017-12-10T20:07:20Z [1] WARNING {memory} /sys/kernel/mm/transparent_hugepage/enabled is set to 'always'. It is recommended to set it to a value of 'never' or 'madvise'
arangodb_1 | 2017-12-10T20:07:20Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"'
arangodb_1 | 2017-12-10T20:07:20Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"'
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_arangodb_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 44
Running: 1
Paused: 0
Stopped: 43
Images: 433
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1199.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3192.30
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17462 MB memory for database.(B
Waiting for arangodb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.57762503623962 seconds
test 1 using arangodb writes 1731.2268985258 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.4290931224823 seconds
test 2 using arangodb writes 2330.4964531126 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.02186107635498 seconds
test 4 using arangodb loads 114358.50455874 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.27440404891968 seconds
test 5 using arangodb loads 9110.6527394273 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.28239297866821 seconds
test 6 using arangodb loads 3541.164531484 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Starting benchmark arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.64159393310547 seconds
test 1 using arangodb writes 1558.6182293834 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.49746108055115 seconds
test 2 using arangodb writes 2010.2075098862 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.020989894866943 seconds
test 4 using arangodb loads 119104.9319612 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.30933618545532 seconds
test 5 using arangodb loads 8081.8220355312 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.29553413391113 seconds
test 6 using arangodb loads 3383.7038949305 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Dumping logs arangodb!(B
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1
php_1 | Interactive shell
php_1 |
arangodb_1 | automaticaly choosing storage engine
arangodb_1 | Initializing database...Hang on...
arangodb_1 | Database initialized...Starting System...
arangodb_1 | 2017-12-13T21:31:28Z [1] INFO ArangoDB 3.2.9 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.492.77, OpenSSL 1.1.0f 25 May 2017
arangodb_1 | 2017-12-13T21:31:28Z [1] WARNING {memory} /sys/kernel/mm/transparent_hugepage/enabled is set to 'always'. It is recommended to set it to a value of 'never' or 'madvise'
arangodb_1 | 2017-12-13T21:31:28Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"'
arangodb_1 | 2017-12-13T21:31:28Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"'
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_arangodb_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 47
Running: 1
Paused: 0
Stopped: 46
Images: 457
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 933.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.70
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17602 MB memory for database.(B
Waiting for arangodb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.62807106971741 seconds
test 1 using arangodb writes 1592.1765039264 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.51583218574524 seconds
test 2 using arangodb writes 1938.6149752468 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.02143120765686 seconds
test 4 using arangodb loads 116652.31563373 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.28973317146301 seconds
test 5 using arangodb loads 8628.6288427942 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.28173112869263 seconds
test 6 using arangodb loads 3549.4835258017 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Starting benchmark arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.63103199005127 seconds
test 1 using arangodb writes 1584.7057134437 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.47236108779907 seconds
test 2 using arangodb writes 2117.0245090666 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.019221067428589 seconds
test 4 using arangodb loads 130065.61728625 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.25880002975464 seconds
test 5 using arangodb loads 9659.9679774774 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.25568008422852 seconds
test 6 using arangodb loads 3911.1376352107 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Dumping logs arangodb!(B
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1
php_1 | Interactive shell
php_1 |
arangodb_1 | automaticaly choosing storage engine
arangodb_1 | Initializing database...Hang on...
arangodb_1 | Database initialized...Starting System...
arangodb_1 | 2017-12-14T23:13:06Z [1] INFO ArangoDB 3.2.9 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.492.77, OpenSSL 1.1.0f 25 May 2017
arangodb_1 | 2017-12-14T23:13:06Z [1] WARNING {memory} /sys/kernel/mm/transparent_hugepage/enabled is set to 'always'. It is recommended to set it to a value of 'never' or 'madvise'
arangodb_1 | 2017-12-14T23:13:06Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"'
arangodb_1 | 2017-12-14T23:13:06Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"'
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_arangodb_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 47
Running: 1
Paused: 0
Stopped: 46
Images: 457
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1199.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.70
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17538 MB memory for database.(B
Waiting for arangodb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.57005786895752 seconds
test 1 using arangodb writes 1754.2078698584 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.38766098022461 seconds
test 2 using arangodb writes 2579.5735217421 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.021249055862427 seconds
test 4 using arangodb loads 117652.28611501 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.27123999595642 seconds
test 5 using arangodb loads 9216.9297937966 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.27861905097961 seconds
test 6 using arangodb loads 3589.1300199467 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Starting benchmark arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.60853004455566 seconds
test 1 using arangodb writes 1643.3042360795 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.48598885536194 seconds
test 2 using arangodb writes 2057.6603536623 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.01754093170166 seconds
test 4 using arangodb loads 142523.78622302 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.28023290634155 seconds
test 5 using arangodb loads 8921.1507407804 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.28165316581726 seconds
test 6 using arangodb loads 3550.4660389609 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Dumping logs arangodb!(B
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1
php_1 | Interactive shell
php_1 |
arangodb_1 | automaticaly choosing storage engine
arangodb_1 | Initializing database...Hang on...
arangodb_1 | Database initialized...Starting System...
arangodb_1 | 2017-12-14T23:14:02Z [1] INFO ArangoDB 3.2.9 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.492.77, OpenSSL 1.1.0f 25 May 2017
arangodb_1 | 2017-12-14T23:14:02Z [1] WARNING {memory} /sys/kernel/mm/transparent_hugepage/enabled is set to 'always'. It is recommended to set it to a value of 'never' or 'madvise'
arangodb_1 | 2017-12-14T23:14:02Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"'
arangodb_1 | 2017-12-14T23:14:02Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"'
Name Command State Ports
------------------------------------------------------------------------------------------------
eventstorebenchmarks_arangodb_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
eventstorebenchmarks_php_1 docker-php-entrypoint php -a Exit 0
Docker Info(B
Containers: 47
Running: 1
Paused: 0
Stopped: 46
Images: 457
Server Version: 17.05.0-ce
Storage Driver: overlay
Backing Filesystem: extfs
Supports d_type: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 9048e5e50717ea4497b757314bad98ea3763c145
runc version: 9c2d8d184e5da67c95d601382adf14862e4f2228
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.8.12-040812-generic
Operating System: Ubuntu 16.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 19.54GiB
Name: ThinkPad
ID: EU7G:ZCOQ:2FYE:HYHG:WQ3J:WD2B:NMTB:CIN3:A7AC:QIKZ:L7AQ:LO5L
Docker Root Dir: /home/skeil/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: true
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info(B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) pro Kern: 2
Kern(e) pro Socket: 4
Socket(s): 1
NUMA-Knoten: 1
Anbieterkennung: GenuineIntel
Prozessorfamilie: 6
Modell: 30
Model name: Intel(R) Core(TM) i7 CPU Q 720 @ 1.60GHz
Stepping: 5
CPU MHz: 1066.000
CPU max MHz: 1600,0000
CPU min MHz: 933,0000
BogoMIPS: 3191.70
Virtualisierung: VT-x
L1d Cache: 32K
L1i Cache: 32K
L2 Cache: 256K
L3 Cache: 6144K
NUMA node0 CPU(s): 0-7
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm tpr_shadow vnmi flexpriority ept vpid dtherm ida
Using 4 CPUs for each service and 17519 MB memory for database.(B
Waiting for arangodb database, lean back to enjoy the timer.(B
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark warmup arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.6510910987854 seconds
test 1 using arangodb writes 1535.8833838544 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.44609594345093 seconds
test 2 using arangodb writes 2241.6702386132 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.015871047973633 seconds
test 4 using arangodb loads 157519.52890278 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.27776098251343 seconds
test 5 using arangodb loads 9000.5441994688 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.27053594589233 seconds
test 6 using arangodb loads 3696.3664724908 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Starting benchmark arangodb!(B
Your PHP Version is 7.1.12, so "real-world-test" is skipped
You don't have pthreads installed, so "real-world-test" is skipped
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 arangodb took 0.62151789665222 seconds
test 1 using arangodb writes 1608.9641269969 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.50628185272217 seconds
test 2 using arangodb writes 1975.1843654344 events per second
test 3 create one stream with 2500 events using a single commit
Test 3 skipped because of VST 1.1 issue https://github.com/sandrokeil/arangodb-php-driver/issues/41
test 4 load one stream with 2500 events
test 4 using arangodb took 0.013227939605713 seconds
test 4 using arangodb loads 188993.9079341 events per second
test 5 project 1 stream with 2500 events
test 5 using arangodb took 0.2620849609375 seconds
test 5 using arangodb loads 9538.8914764788 events per second
test 6 project 10 stream with 100 events
test 6 using arangodb took 0.29118990898132 seconds
test 6 using arangodb loads 3434.1849396441 events per second
real-world-test skipped
arangodb: destroying event-store tables on database _system
Dumping logs arangodb!(B
Attaching to eventstorebenchmarks_arangodb_1, eventstorebenchmarks_php_1
php_1 | Interactive shell
php_1 |
arangodb_1 | automaticaly choosing storage engine
arangodb_1 | Initializing database...Hang on...
arangodb_1 | Database initialized...Starting System...
arangodb_1 | 2017-12-14T23:14:44Z [1] INFO ArangoDB 3.2.9 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.492.77, OpenSSL 1.1.0f 25 May 2017
arangodb_1 | 2017-12-14T23:14:44Z [1] WARNING {memory} /sys/kernel/mm/transparent_hugepage/enabled is set to 'always'. It is recommended to set it to a value of 'never' or 'madvise'
arangodb_1 | 2017-12-14T23:14:44Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"'
arangodb_1 | 2017-12-14T23:14:44Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.