Last active
December 14, 2017 23:17
-
-
Save sandrokeil/59ca8be72df1d034cfea8f4997f175bd to your computer and use it in GitHub Desktop.
ArangoDB prooph event store benchmarks
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[32mTesting databases are (B[marangodb 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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17636 MB memory for database.(B[m | |
[32mWaiting for arangodb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup arangodb!(B[m | |
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 | |
[32mStarting benchmark arangodb!(B[m | |
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 | |
[32mDumping logs arangodb!(B[m | |
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1 | |
[36mphp_1 |[0m Interactive shell | |
[36mphp_1 |[0m | |
[33marangodb_1 |[0m automaticaly choosing storage engine | |
[33marangodb_1 |[0m Initializing database...Hang on... | |
[33marangodb_1 |[0m Database initialized...Starting System... | |
[33marangodb_1 |[0m 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 | |
[33marangodb_1 |[0m 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' | |
[33marangodb_1 |[0m 2017-12-07T22:17:49Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"' | |
[33marangodb_1 |[0m 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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17504 MB memory for database.(B[m | |
[32mWaiting for mysql database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup mysql!(B[m | |
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 | |
[32mStarting benchmark mysql!(B[m | |
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 | |
[32mDumping logs mysql!(B[m | |
Attaching to eventstorebenchmarks_mysql_1, eventstorebenchmarks_php_1 | |
[36mmysql_1 |[0m Initializing database | |
[36mmysql_1 |[0m 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). | |
[36mmysql_1 |[0m 2017-12-07T22:18:24.924431Z 0 [Warning] InnoDB: New log files created, LSN=45790 | |
[36mmysql_1 |[0m 2017-12-07T22:18:25.037040Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. | |
[36mmysql_1 |[0m 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. | |
[36mmysql_1 |[0m 2017-12-07T22:18:25.115041Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. | |
[36mmysql_1 |[0m 2017-12-07T22:18:25.115847Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. | |
[36mmysql_1 |[0m 2017-12-07T22:18:26.148972Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:26.149011Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:26.149024Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:26.149043Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:26.149050Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:26.149069Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:26.149126Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:26.149141Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m Database initialized | |
[36mmysql_1 |[0m Initializing certificates | |
[36mmysql_1 |[0m Generating a 2048 bit RSA private key | |
[36mmysql_1 |[0m .....................................................+++ | |
[36mmysql_1 |[0m ..................................................................+++ | |
[36mmysql_1 |[0m unable to write 'random state' | |
[36mmysql_1 |[0m writing new private key to 'ca-key.pem' | |
[36mmysql_1 |[0m ----- | |
[36mmysql_1 |[0m Generating a 2048 bit RSA private key | |
[36mmysql_1 |[0m ...............................................................+++ | |
[36mmysql_1 |[0m .....................+++ | |
[36mmysql_1 |[0m unable to write 'random state' | |
[36mmysql_1 |[0m writing new private key to 'server-key.pem' | |
[36mmysql_1 |[0m ----- | |
[36mmysql_1 |[0m Generating a 2048 bit RSA private key | |
[36mmysql_1 |[0m ...................................................+++ | |
[36mmysql_1 |[0m ....+++ | |
[36mmysql_1 |[0m unable to write 'random state' | |
[36mmysql_1 |[0m writing new private key to 'client-key.pem' | |
[36mmysql_1 |[0m ----- | |
[36mmysql_1 |[0m Certificates initialized | |
[36mmysql_1 |[0m MySQL init process in progress... | |
[36mmysql_1 |[0m 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). | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.298830Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 90 ... | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.303185Z 0 [Note] InnoDB: PUNCH HOLE support available | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.303219Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.303226Z 0 [Note] InnoDB: Uses event mutexes | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.303232Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.303241Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 | |
[33mphp_1 |[0m Interactive shell | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.303257Z 0 [Note] InnoDB: Using Linux native AIO | |
[33mphp_1 |[0m | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.303631Z 0 [Note] InnoDB: Number of pools: 1 | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.303768Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.305778Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.314626Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
[36mmysql_1 |[0m 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(). | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.328980Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.339090Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.339186Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.403464Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.404696Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.404720Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.405695Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2539315 | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.406661Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.407100Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.410077Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171207 22:18:29 | |
[36mmysql_1 |[0m 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. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.414801Z 0 [Warning] CA certificate ca.pem is self signed. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.423785Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.423816Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.423826Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.423914Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.423924Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.423937Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.425389Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.425408Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.432438Z 0 [Note] Event Scheduler: Loaded 0 events | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.432796Z 0 [Note] mysqld: ready for connections. | |
[36mmysql_1 |[0m Version: '5.7.19' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL) | |
[36mmysql_1 |[0m 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. | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.432823Z 0 [Note] Beginning of list of non-natively partitioned tables | |
[36mmysql_1 |[0m 2017-12-07T22:18:29.446233Z 0 [Note] End of list of non-natively partitioned tables | |
[36mmysql_1 |[0m Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. | |
[36mmysql_1 |[0m Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. | |
[36mmysql_1 |[0m Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.430815Z 5 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.430856Z 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.430877Z 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.430884Z 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.430903Z 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.430945Z 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.430968Z 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m mysql: [Warning] Using a password on the command line interface can be insecure. | |
[36mmysql_1 |[0m mysql: [Warning] Using a password on the command line interface can be insecure. | |
[36mmysql_1 |[0m mysql: [Warning] Using a password on the command line interface can be insecure. | |
[36mmysql_1 |[0m mysql: [Warning] Using a password on the command line interface can be insecure. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.456092Z 9 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.456126Z 9 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.456152Z 9 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.456162Z 9 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.456176Z 9 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.456464Z 9 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.456489Z 9 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.458416Z 0 [Note] Giving 0 client threads a chance to die gracefully | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.458441Z 0 [Note] Shutting down slave threads | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.458446Z 0 [Note] Forcefully disconnecting 0 remaining clients | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.458453Z 0 [Note] Event Scheduler: Purging the queue. 0 events | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.458989Z 0 [Note] Binlog end | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459785Z 0 [Note] Shutting down plugin 'ngram' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459798Z 0 [Note] Shutting down plugin 'ARCHIVE' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459801Z 0 [Note] Shutting down plugin 'partition' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459804Z 0 [Note] Shutting down plugin 'BLACKHOLE' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459807Z 0 [Note] Shutting down plugin 'MyISAM' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459814Z 0 [Note] Shutting down plugin 'MRG_MYISAM' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459817Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459819Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459822Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459824Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459830Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459832Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459835Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459837Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459839Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459846Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459849Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459852Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459855Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459858Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459861Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459864Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459867Z 0 [Note] Shutting down plugin 'INNODB_METRICS' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459870Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459873Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459943Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459949Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459952Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459955Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459958Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459961Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459964Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459977Z 0 [Note] Shutting down plugin 'INNODB_CMP' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459980Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459983Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459986Z 0 [Note] Shutting down plugin 'INNODB_TRX' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.459990Z 0 [Note] Shutting down plugin 'InnoDB' | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.460138Z 0 [Note] InnoDB: FTS optimize thread exiting. | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.460278Z 0 [Note] InnoDB: Starting shutdown... | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.560496Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool | |
[36mmysql_1 |[0m 2017-12-07T22:18:33.560960Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 171207 22:18:33 | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.374731Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12143451 | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.378648Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.378676Z 0 [Note] Shutting down plugin 'CSV' | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.378686Z 0 [Note] Shutting down plugin 'MEMORY' | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.378708Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.378763Z 0 [Note] Shutting down plugin 'sha256_password' | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.378780Z 0 [Note] Shutting down plugin 'mysql_native_password' | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.379029Z 0 [Note] Shutting down plugin 'binlog' | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.379842Z 0 [Note] mysqld: Shutdown complete | |
[36mmysql_1 |[0m | |
[36mmysql_1 |[0m | |
[36mmysql_1 |[0m MySQL init process done. Ready for start up. | |
[36mmysql_1 |[0m | |
[36mmysql_1 |[0m 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). | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.613112Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 1 ... | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.618185Z 0 [Note] InnoDB: PUNCH HOLE support available | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.618216Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.618223Z 0 [Note] InnoDB: Uses event mutexes | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.618231Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.618253Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.618265Z 0 [Note] InnoDB: Using Linux native AIO | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.618605Z 0 [Note] InnoDB: Number of pools: 1 | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.618746Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.620611Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.631111Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
[36mmysql_1 |[0m 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(). | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.646527Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.659630Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.659746Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.727438Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.728779Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.728811Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.729599Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 12143451 | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.729960Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.730431Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.736287Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171207 22:18:35 | |
[36mmysql_1 |[0m 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. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.736676Z 0 [Warning] CA certificate ca.pem is self signed. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.740239Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.740292Z 0 [Note] IPv6 is available. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.740309Z 0 [Note] - '::' resolves to '::'; | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.740353Z 0 [Note] Server socket created on IP: '::'. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.744208Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.744261Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.744319Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.744332Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.744355Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.747606Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.747630Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.757718Z 0 [Note] Event Scheduler: Loaded 0 events | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.758416Z 0 [Note] mysqld: ready for connections. | |
[36mmysql_1 |[0m Version: '5.7.19' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) | |
[36mmysql_1 |[0m 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. | |
[36mmysql_1 |[0m 2017-12-07T22:18:35.758438Z 0 [Note] Beginning of list of non-natively partitioned tables | |
[36mmysql_1 |[0m 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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17500 MB memory for database.(B[m | |
[32mWaiting for postgres database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup postgres!(B[m | |
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 | |
[32mStarting benchmark postgres!(B[m | |
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 | |
[32mDumping logs postgres!(B[m | |
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_postgres_1 | |
[36mphp_1 |[0m Interactive shell | |
[36mphp_1 |[0m | |
[33mpostgres_1 |[0m The files belonging to this database system will be owned by user "postgres". | |
[33mpostgres_1 |[0m This user must also own the server process. | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m The database cluster will be initialized with locale "en_US.utf8". | |
[33mpostgres_1 |[0m The default database encoding has accordingly been set to "UTF8". | |
[33mpostgres_1 |[0m The default text search configuration will be set to "english". | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m Data page checksums are disabled. | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m fixing permissions on existing directory /var/lib/postgresql/data ... ok | |
[33mpostgres_1 |[0m creating subdirectories ... ok | |
[33mpostgres_1 |[0m selecting default max_connections ... 100 | |
[33mpostgres_1 |[0m selecting default shared_buffers ... 128MB | |
[33mpostgres_1 |[0m selecting dynamic shared memory implementation ... posix | |
[33mpostgres_1 |[0m creating configuration files ... ok | |
[33mpostgres_1 |[0m running bootstrap script ... ok | |
[33mpostgres_1 |[0m performing post-bootstrap initialization ... ok | |
[33mpostgres_1 |[0m syncing data to disk ... ok | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m Success. You can now start the database server using: | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m pg_ctl -D /var/lib/postgresql/data -l logfile start | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m WARNING: enabling "trust" authentication for local connections | |
[33mpostgres_1 |[0m You can change this by editing pg_hba.conf or using the option -A, or | |
[33mpostgres_1 |[0m --auth-local and --auth-host, the next time you run initdb. | |
[33mpostgres_1 |[0m waiting for server to start....LOG: could not bind IPv6 socket: Cannot assign requested address | |
[33mpostgres_1 |[0m HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. | |
[33mpostgres_1 |[0m LOG: database system was shut down at 2017-12-07 22:23:47 UTC | |
[33mpostgres_1 |[0m LOG: MultiXact member wraparound protections are now enabled | |
[33mpostgres_1 |[0m LOG: database system is ready to accept connections | |
[33mpostgres_1 |[0m LOG: autovacuum launcher started | |
[33mpostgres_1 |[0m done | |
[33mpostgres_1 |[0m server started | |
[33mpostgres_1 |[0m CREATE DATABASE | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m CREATE ROLE | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/* | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m LOG: received fast shutdown request | |
[33mpostgres_1 |[0m waiting for server to shut down...LOG: aborting any active transactions | |
[33mpostgres_1 |[0m .LOG: autovacuum launcher shutting down | |
[33mpostgres_1 |[0m LOG: shutting down | |
[33mpostgres_1 |[0m LOG: database system is shut down | |
[33mpostgres_1 |[0m done | |
[33mpostgres_1 |[0m server stopped | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m PostgreSQL init process complete; ready for start up. | |
[33mpostgres_1 |[0m | |
[33mpostgres_1 |[0m LOG: database system was shut down at 2017-12-07 22:23:48 UTC | |
[33mpostgres_1 |[0m LOG: MultiXact member wraparound protections are now enabled | |
[33mpostgres_1 |[0m LOG: database system is ready to accept connections | |
[33mpostgres_1 |[0m 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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17495 MB memory for database.(B[m | |
[32mWaiting for mariadb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup mariadb!(B[m | |
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 | |
[32mStarting benchmark mariadb!(B[m | |
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 | |
[32mDumping logs mariadb!(B[m | |
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_mariadb_1 | |
[33mmariadb_1 |[0m Initializing database | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! | |
[36mphp_1 |[0m Interactive shell | |
[36mphp_1 |[0m | |
[33mmariadb_1 |[0m To do so, start the server, then issue the following commands: | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m '/usr/bin/mysqladmin' -u root password 'new-password' | |
[33mmariadb_1 |[0m '/usr/bin/mysqladmin' -u root -h password 'new-password' | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m Alternatively you can run: | |
[33mmariadb_1 |[0m '/usr/bin/mysql_secure_installation' | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m which will also give you the option of removing the test | |
[33mmariadb_1 |[0m databases and anonymous user created by default. This is | |
[33mmariadb_1 |[0m strongly recommended for production servers. | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m See the MariaDB Knowledgebase at http://mariadb.com/kb or the | |
[33mmariadb_1 |[0m MySQL manual for more instructions. | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m Please report any problems at http://mariadb.org/jira | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m The latest information about MariaDB is available at http://mariadb.org/. | |
[33mmariadb_1 |[0m You can find additional information about the MySQL part at: | |
[33mmariadb_1 |[0m http://dev.mysql.com | |
[33mmariadb_1 |[0m Consider joining MariaDB's strong and vibrant community: | |
[33mmariadb_1 |[0m https://mariadb.org/get-involved/ | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m Database initialized | |
[33mmariadb_1 |[0m MySQL init process in progress... | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] mysqld (mysqld 10.3.1-MariaDB-10.3.1+maria~jessie) starting as process 99 ... | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Uses event mutexes | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Using Linux native AIO | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Number of pools: 1 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Using SSE2 crc32 instructions | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Completed initialization of buffer pool | |
[33mmariadb_1 |[0m 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(). | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Waiting for purge to start | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: 5.7.19 started; log sequence number 1622414 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] InnoDB: Buffer pool(s) load completed at 171207 22:25:39 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] Plugin 'FEEDBACK' is disabled. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Warning] 'user' entry 'root@7346c207af9b' ignored in --skip-name-resolve mode. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Warning] 'proxies_priv' entry '@% root@7346c207af9b' ignored in --skip-name-resolve mode. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] Reading of all Master_info entries succeded | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] Added new Master_info '' to hash table | |
[33mmariadb_1 |[0m 2017-12-07 22:25:39 0 [Note] mysqld: ready for connections. | |
[33mmariadb_1 |[0m Version: '10.3.1-MariaDB-10.3.1+maria~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution | |
[33mmariadb_1 |[0m Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:43 10 [Warning] 'proxies_priv' entry '@% root@7346c207af9b' ignored in --skip-name-resolve mode. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:43 14 [Warning] 'proxies_priv' entry '@% root@7346c207af9b' ignored in --skip-name-resolve mode. | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m 2017-12-07 22:25:43 0 [Note] mysqld (unknown): Normal shutdown | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m 2017-12-07 22:25:43 0 [Note] Event Scheduler: Purging the queue. 0 events | |
[33mmariadb_1 |[0m 2017-12-07 22:25:43 0 [Note] InnoDB: FTS optimize thread exiting. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:43 0 [Note] InnoDB: Starting shutdown... | |
[33mmariadb_1 |[0m 2017-12-07 22:25:43 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool | |
[33mmariadb_1 |[0m 2017-12-07 22:25:43 0 [Note] InnoDB: Buffer pool(s) dump completed at 171207 22:25:43 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Shutdown completed; log sequence number 1622442 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] mysqld: Shutdown complete | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m MySQL init process done. Ready for start up. | |
[33mmariadb_1 |[0m | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] mysqld (mysqld 10.3.1-MariaDB-10.3.1+maria~jessie) starting as process 1 ... | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Uses event mutexes | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Using Linux native AIO | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Number of pools: 1 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Using SSE2 crc32 instructions | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Completed initialization of buffer pool | |
[33mmariadb_1 |[0m 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(). | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Waiting for purge to start | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: 5.7.19 started; log sequence number 1622442 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] InnoDB: Buffer pool(s) load completed at 171207 22:25:44 | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] Plugin 'FEEDBACK' is disabled. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] Server socket created on IP: '::'. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Warning] 'proxies_priv' entry '@% root@7346c207af9b' ignored in --skip-name-resolve mode. | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] Reading of all Master_info entries succeded | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] Added new Master_info '' to hash table | |
[33mmariadb_1 |[0m 2017-12-07 22:25:44 0 [Note] mysqld: ready for connections. | |
[33mmariadb_1 |[0m Version: '10.3.1-MariaDB-10.3.1+maria~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 14041 MB memory for database.(B[m | |
[32mWaiting for arangodb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup arangodb!(B[m | |
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 | |
[32mStarting benchmark arangodb!(B[m | |
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 | |
[32mDumping logs arangodb!(B[m | |
Attaching to eventstorebenchmarks_arangodb_1, eventstorebenchmarks_php_1 | |
[33mphp_1 |[0m Interactive shell | |
[33mphp_1 |[0m | |
[36marangodb_1 |[0m automaticaly choosing storage engine | |
[36marangodb_1 |[0m Initializing database...Hang on... | |
[36marangodb_1 |[0m Database initialized...Starting System... | |
[36marangodb_1 |[0m 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 | |
[36marangodb_1 |[0m 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 | |
[36marangodb_1 |[0m 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 | |
[36marangodb_1 |[0m 2017-12-08T16:52:07Z [1] WARNING {memory} execute 'sudo sysctl -w "vm.max_map_count=512000"' | |
[36marangodb_1 |[0m 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' | |
[36marangodb_1 |[0m 2017-12-08T16:52:07Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"' | |
[36marangodb_1 |[0m 2017-12-08T16:52:07Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"' | |
[36marangodb_1 |[0m 2017-12-08T16:52:07Z [1] INFO using storage engine mmfiles | |
[36marangodb_1 |[0m 2017-12-08T16:52:07Z [1] INFO {cluster} Starting up with role SINGLE | |
[36marangodb_1 |[0m 2017-12-08T16:52:07Z [1] INFO {syscall} file-descriptors (nofiles) hard limit is 1048576, soft limit is 1048576 | |
[36marangodb_1 |[0m 2017-12-08T16:52:07Z [1] INFO {authentication} Authentication is turned off, authentication for unix sockets is turned on | |
[36marangodb_1 |[0m 2017-12-08T16:52:08Z [1] INFO using endpoint 'http+tcp://0.0.0.0:8529' for non-encrypted requests | |
[36marangodb_1 |[0m 2017-12-08T16:52:08Z [1] INFO You are using a milestone/alpha/beta/preview version ('3.3.beta1') of ArangoDB | |
[36marangodb_1 |[0m 2017-12-08T16:52:08Z [1] INFO ArangoDB (version 3.3.beta1 [linux]) is ready for business. Have fun! |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17446 MB memory for database.(B[m | |
[32mWaiting for arangodb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup arangodb!(B[m | |
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 | |
[32mStarting benchmark arangodb!(B[m | |
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 | |
[32mDumping logs arangodb!(B[m | |
Attaching to eventstorebenchmarks_arangodb_1, eventstorebenchmarks_php_1 | |
[33mphp_1 |[0m Interactive shell | |
[33mphp_1 |[0m | |
[36marangodb_1 |[0m automaticaly choosing storage engine | |
[36marangodb_1 |[0m Initializing database...Hang on... | |
[36marangodb_1 |[0m Database initialized...Starting System... | |
[36marangodb_1 |[0m 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 | |
[36marangodb_1 |[0m 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' | |
[36marangodb_1 |[0m 2017-12-08T22:17:23Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"' | |
[36marangodb_1 |[0m 2017-12-08T22:17:23Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17589 MB memory for database.(B[m | |
[32mWaiting for arangodb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup arangodb!(B[m | |
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 | |
[32mStarting benchmark arangodb!(B[m | |
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 | |
[32mDumping logs arangodb!(B[m | |
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1 | |
[36mphp_1 |[0m Interactive shell | |
[36mphp_1 |[0m | |
[33marangodb_1 |[0m automaticaly choosing storage engine | |
[33marangodb_1 |[0m Initializing database...Hang on... | |
[33marangodb_1 |[0m Database initialized...Starting System... | |
[33marangodb_1 |[0m 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 | |
[33marangodb_1 |[0m 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' | |
[33marangodb_1 |[0m 2017-12-10T20:07:20Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"' | |
[33marangodb_1 |[0m 2017-12-10T20:07:20Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17462 MB memory for database.(B[m | |
[32mWaiting for arangodb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup arangodb!(B[m | |
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 | |
[32mStarting benchmark arangodb!(B[m | |
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 | |
[32mDumping logs arangodb!(B[m | |
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1 | |
[36mphp_1 |[0m Interactive shell | |
[36mphp_1 |[0m | |
[33marangodb_1 |[0m automaticaly choosing storage engine | |
[33marangodb_1 |[0m Initializing database...Hang on... | |
[33marangodb_1 |[0m Database initialized...Starting System... | |
[33marangodb_1 |[0m 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 | |
[33marangodb_1 |[0m 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' | |
[33marangodb_1 |[0m 2017-12-13T21:31:28Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"' | |
[33marangodb_1 |[0m 2017-12-13T21:31:28Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17602 MB memory for database.(B[m | |
[32mWaiting for arangodb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup arangodb!(B[m | |
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 | |
[32mStarting benchmark arangodb!(B[m | |
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 | |
[32mDumping logs arangodb!(B[m | |
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1 | |
[36mphp_1 |[0m Interactive shell | |
[36mphp_1 |[0m | |
[33marangodb_1 |[0m automaticaly choosing storage engine | |
[33marangodb_1 |[0m Initializing database...Hang on... | |
[33marangodb_1 |[0m Database initialized...Starting System... | |
[33marangodb_1 |[0m 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 | |
[33marangodb_1 |[0m 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' | |
[33marangodb_1 |[0m 2017-12-14T23:13:06Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"' | |
[33marangodb_1 |[0m 2017-12-14T23:13:06Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17538 MB memory for database.(B[m | |
[32mWaiting for arangodb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup arangodb!(B[m | |
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 | |
[32mStarting benchmark arangodb!(B[m | |
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 | |
[32mDumping logs arangodb!(B[m | |
Attaching to eventstorebenchmarks_php_1, eventstorebenchmarks_arangodb_1 | |
[36mphp_1 |[0m Interactive shell | |
[36mphp_1 |[0m | |
[33marangodb_1 |[0m automaticaly choosing storage engine | |
[33marangodb_1 |[0m Initializing database...Hang on... | |
[33marangodb_1 |[0m Database initialized...Starting System... | |
[33marangodb_1 |[0m 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 | |
[33marangodb_1 |[0m 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' | |
[33marangodb_1 |[0m 2017-12-14T23:14:02Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"' | |
[33marangodb_1 |[0m 2017-12-14T23:14:02Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/defrag"' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
[32mDocker Info(B[m | |
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 | |
[32mHardware Info(B[m | |
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 | |
[32mUsing 4 CPUs for each service and 17519 MB memory for database.(B[m | |
[32mWaiting for arangodb database, lean back to enjoy the timer.(B[m | |
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 | |
[32mStarting benchmark warmup arangodb!(B[m | |
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 | |
[32mStarting benchmark arangodb!(B[m | |
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 | |
[32mDumping logs arangodb!(B[m | |
Attaching to eventstorebenchmarks_arangodb_1, eventstorebenchmarks_php_1 | |
[33mphp_1 |[0m Interactive shell | |
[33mphp_1 |[0m | |
[36marangodb_1 |[0m automaticaly choosing storage engine | |
[36marangodb_1 |[0m Initializing database...Hang on... | |
[36marangodb_1 |[0m Database initialized...Starting System... | |
[36marangodb_1 |[0m 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 | |
[36marangodb_1 |[0m 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' | |
[36marangodb_1 |[0m 2017-12-14T23:14:44Z [1] WARNING {memory} execute 'sudo bash -c "echo madvise > /sys/kernel/mm/transparent_hugepage/enabled"' | |
[36marangodb_1 |[0m 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