-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathresults.log
1551 lines (1455 loc) · 106 KB
/
results.log
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
[32mTesting databases are (B[mmysql arangodb postgres mariadb
Name Command State Ports
--------------------------------------------------------------------------------------------------
eventstorebenchmarks_database_1 docker-entrypoint.sh --max ... Up 0.0.0.0:32770->3306/tcp
Docker Info
Containers: 351
Running: 1
Paused: 0
Stopped: 350
Images: 80
Server Version: 17.09.0-ce
Storage Driver: overlay2
Backing Filesystem: extfs
Supports d_type: true
Native Overlay Diff: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host macvlan null overlay
Log: awslogs fluentd gcplogs gelf journald json-file logentries splunk syslog
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 06b9cb35161009dcb7123345749fef02f7cea8e0
runc version: 3f2f8b84a77f73d38244dd690525642a72156c64
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.13.0-31-generic
Operating System: Ubuntu 17.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 31.18GiB
Name: codebook
ID: QODG:6EEM:6T3U:CWGU:KMA6:NNP7:KM72:RYVB:2YGB:BW3E:454Y:EGKH
Docker Root Dir: /var/lib/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: false
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info
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: 158
Model name: Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz
Stepping: 9
CPU MHz: 2800.000
CPU max MHz: 3800,0000
CPU min MHz: 800,0000
BogoMIPS: 5616.00
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 pdpe1gb rdtscp lm constant_tsc art arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf tsc_known_freq pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch cpuid_fault epb invpcid_single pti intel_pt tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid mpx rdseed adx smap clflushopt xsaveopt xsavec xgetbv1 xsaves dtherm ida arat pln pts hwp hwp_notify hwp_act_window hwp_epp
Using 4 CPUs for each service and 25405 MB memory for database.
Waiting for mysql database, lean back to enjoy the timer.
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark mysql!
2018-01-25T16:13:19.329016: mysql: set up event store tables on database event_store_tests
2018-01-25T16:13:20.526824: test 1 create 10 streams with 100 events in each stream, using 1 event per commit
2018-01-25T16:13:31.391768: test 1 using mysql took 10.864897012711 seconds
2018-01-25T16:13:31.391838: test 1 using mysql writes 92.039528660983 events per second
2018-01-25T16:13:31.391862: test 2 create 10 streams with 100 events in each stream, using 5 events per commit
2018-01-25T16:13:34.107067: test 2 using mysql took 2.7151551246643 seconds
2018-01-25T16:13:34.107122: test 2 using mysql writes 368.30308180776 events per second
2018-01-25T16:13:34.107141: test 3 create one stream with 2500 events using a single commit
2018-01-25T16:13:34.961839: test 3 using mysql took 0.85464000701904 seconds
2018-01-25T16:13:34.961883: test 3 using mysql writes 2925.2082508048 events per second
2018-01-25T16:13:34.961898: test 4 load one stream with 2500 events
2018-01-25T16:13:34.996603: test 4 using mysql took 0.034682989120483 seconds
2018-01-25T16:13:34.996626: test 4 using mysql loads 72081.445786445 events per second
2018-01-25T16:13:34.996632: test 5 project 1 stream with 2500 events
2018-01-25T16:13:35.165388: test 5 using mysql took 0.16731405258179 seconds
2018-01-25T16:13:35.165438: test 5 using mysql loads 14941.96071055 events per second
2018-01-25T16:13:35.165442: test 6 project 10 stream with 100 events
2018-01-25T16:13:35.361180: test 6 using mysql took 0.19569897651672 seconds
2018-01-25T16:13:35.361205: test 6 using mysql loads 5109.8887577194 events per second
2018-01-25T16:13:35.379809: mysql: destroying event-store tables on database event_store_tests
Starting real world benchmark mysql!
2018-01-25T16:13:36.207215: mysql: set up event store tables on database event_store_tests
Waiting ... stay patient!
2018-01-25T16:13:37.438121: Writer writer0-user started
2018-01-25T16:17:27.426572: Writer writer0-user wrote 250 events
2018-01-25T16:17:27.426664: Writer writer0-user used 229.98367404938 seconds, avg 1.0870336819922 events/second
2018-01-25T16:13:37.705581: Writer writer0-post started
2018-01-25T16:17:34.138301: Writer writer0-post wrote 250 events
2018-01-25T16:17:34.138371: Writer writer0-post used 236.41334199905 seconds, avg 1.0574699290914 events/second
2018-01-25T16:13:37.439164: Writer writer0-todo started
2018-01-25T16:17:42.460892: Writer writer0-todo wrote 250 events
2018-01-25T16:17:42.460939: Writer writer0-todo used 244.99972486496 seconds, avg 1.0204093091851 events/second
2018-01-25T16:13:37.618738: Writer writer0-blog started
2018-01-25T16:17:39.148323: Writer writer0-blog wrote 250 events
2018-01-25T16:17:39.148348: Writer writer0-blog used 241.51751899719 seconds, avg 1.0351215971331 events/second
2018-01-25T16:13:37.745432: Writer writer0-comment started
2018-01-25T16:17:42.717418: Writer writer0-comment wrote 250 events
2018-01-25T16:17:42.717490: Writer writer0-comment used 244.96144509315 seconds, avg 1.0205687670765 events/second
2018-01-25T16:13:37.746608: Writer writer1-user started
2018-01-25T16:17:36.229473: Writer writer1-user wrote 250 events
2018-01-25T16:17:36.229543: Writer writer1-user used 238.46680998802 seconds, avg 1.0483639212206 events/second
2018-01-25T16:13:37.658078: Writer writer1-post started
2018-01-25T16:17:37.600259: Writer writer1-post wrote 250 events
2018-01-25T16:17:37.600332: Writer writer1-post used 239.92692303658 seconds, avg 1.0419839375921 events/second
2018-01-25T16:13:37.618137: Writer writer1-todo started
2018-01-25T16:17:42.387259: Writer writer1-todo wrote 250 events
2018-01-25T16:17:42.387340: Writer writer1-todo used 244.75387501717 seconds, avg 1.021434287741 events/second
2018-01-25T16:13:37.605240: Writer writer1-blog started
2018-01-25T16:17:27.703972: Writer writer1-blog wrote 250 events
2018-01-25T16:17:27.704050: Writer writer1-blog used 230.08928585052 seconds, avg 1.0865347296632 events/second
2018-01-25T16:13:37.634884: Writer writer1-comment started
2018-01-25T16:17:36.117284: Writer writer1-comment wrote 250 events
2018-01-25T16:17:36.117361: Writer writer1-comment used 238.47601890564 seconds, avg 1.0483234379173 events/second
2018-01-25T16:13:37.642075: Writer writer2-user started
2018-01-25T16:17:18.239712: Writer writer2-user wrote 250 events
2018-01-25T16:17:18.239764: Writer writer2-user used 220.58644509315 seconds, avg 1.1333425310627 events/second
2018-01-25T16:13:37.726628: Writer writer2-post started
2018-01-25T16:17:41.664024: Writer writer2-post wrote 250 events
2018-01-25T16:17:41.664099: Writer writer2-post used 243.91574215889 seconds, avg 1.0249440966264 events/second
2018-01-25T16:13:37.601056: Writer writer2-todo started
2018-01-25T16:17:08.852471: Writer writer2-todo wrote 250 events
2018-01-25T16:17:08.852545: Writer writer2-todo used 211.23473095894 seconds, avg 1.1835174966971 events/second
2018-01-25T16:13:37.708120: Writer writer2-blog started
2018-01-25T16:17:42.967189: Writer writer2-blog wrote 250 events
2018-01-25T16:17:42.967251: Writer writer2-blog used 245.25423407555 seconds, avg 1.0193503934492 events/second
2018-01-25T16:13:37.438660: Writer writer2-comment started
2018-01-25T16:17:39.112286: Writer writer2-comment wrote 250 events
2018-01-25T16:17:39.112377: Writer writer2-comment used 241.66296887398 seconds, avg 1.034498587702 events/second
2018-01-25T16:13:37.626166: Writer writer3-user started
2018-01-25T16:17:22.139368: Writer writer3-user wrote 250 events
2018-01-25T16:17:22.139476: Writer writer3-user used 224.50502610207 seconds, avg 1.1135608157224 events/second
2018-01-25T16:13:37.606469: Writer writer3-post started
2018-01-25T16:16:54.764402: Writer writer3-post wrote 250 events
2018-01-25T16:16:54.764482: Writer writer3-post used 197.13917589188 seconds, avg 1.2681396220156 events/second
2018-01-25T16:13:37.635375: Writer writer3-todo started
2018-01-25T16:17:12.432913: Writer writer3-todo wrote 250 events
2018-01-25T16:17:12.432935: Writer writer3-todo used 214.78355002403 seconds, avg 1.1639625100341 events/second
2018-01-25T16:13:37.630752: Writer writer3-blog started
2018-01-25T16:17:31.744251: Writer writer3-blog wrote 250 events
2018-01-25T16:17:31.744365: Writer writer3-blog used 234.05611491203 seconds, avg 1.0681199254032 events/second
2018-01-25T16:13:37.726054: Writer writer3-comment started
2018-01-25T16:17:22.964771: Writer writer3-comment wrote 250 events
2018-01-25T16:17:22.964796: Writer writer3-comment used 225.21522521973 seconds, avg 1.1100492862154 events/second
2018-01-25T16:13:37.709215: Writer writer4-user started
2018-01-25T16:17:34.102788: Writer writer4-user wrote 250 events
2018-01-25T16:17:34.102873: Writer writer4-user used 236.38797497749 seconds, avg 1.0575834072093 events/second
2018-01-25T16:13:37.637647: Writer writer4-post started
2018-01-25T16:17:34.146580: Writer writer4-post wrote 250 events
2018-01-25T16:17:34.146647: Writer writer4-post used 236.48899412155 seconds, avg 1.0571316476212 events/second
2018-01-25T16:13:37.636916: Writer writer4-todo started
2018-01-25T16:17:25.091549: Writer writer4-todo wrote 250 events
2018-01-25T16:17:25.091644: Writer writer4-todo used 227.40911006927 seconds, avg 1.0993403031384 events/second
2018-01-25T16:13:37.606144: Writer writer4-blog started
2018-01-25T16:17:05.709472: Writer writer4-blog wrote 250 events
2018-01-25T16:17:05.709592: Writer writer4-blog used 208.08787298203 seconds, avg 1.2014155194022 events/second
2018-01-25T16:13:37.638175: Writer writer4-comment started
2018-01-25T16:17:37.975914: Writer writer4-comment wrote 250 events
2018-01-25T16:17:37.975993: Writer writer4-comment used 240.32638311386 seconds, avg 1.0402519971416 events/second
2018-01-25T16:13:37.663191: Writer writer5-user started
2018-01-25T16:17:22.864686: Writer writer5-user wrote 250 events
2018-01-25T16:17:22.864770: Writer writer5-user used 225.17524790764 seconds, avg 1.1102463628797 events/second
2018-01-25T16:13:37.635680: Writer writer5-post started
2018-01-25T16:17:25.126161: Writer writer5-post wrote 250 events
2018-01-25T16:17:25.126240: Writer writer5-post used 227.48063111305 seconds, avg 1.09899466507 events/second
2018-01-25T16:13:37.630089: Writer writer5-todo started
2018-01-25T16:17:18.235572: Writer writer5-todo wrote 250 events
2018-01-25T16:17:18.235653: Writer writer5-todo used 220.55134820938 seconds, avg 1.1335228826743 events/second
2018-01-25T16:13:37.662178: Writer writer5-blog started
2018-01-25T16:17:39.282429: Writer writer5-blog wrote 250 events
2018-01-25T16:17:39.282531: Writer writer5-blog used 241.60484099388 seconds, avg 1.0347474784511 events/second
2018-01-25T16:13:37.708467: Writer writer5-comment started
2018-01-25T16:17:34.497557: Writer writer5-comment wrote 250 events
2018-01-25T16:17:34.497588: Writer writer5-comment used 236.77765393257 seconds, avg 1.0558428797981 events/second
2018-01-25T16:13:37.722047: Writer writer6-user started
2018-01-25T16:17:18.234469: Writer writer6-user wrote 250 events
2018-01-25T16:17:18.234562: Writer writer6-user used 220.49699187279 seconds, avg 1.1338023157442 events/second
2018-01-25T16:13:37.716121: Writer writer6-post started
2018-01-25T16:17:41.958128: Writer writer6-post wrote 250 events
2018-01-25T16:17:41.958226: Writer writer6-post used 244.21683096886 seconds, avg 1.0236804687384 events/second
2018-01-25T16:13:37.709599: Writer writer6-todo started
2018-01-25T16:17:12.578333: Writer writer6-todo wrote 250 events
2018-01-25T16:17:12.578411: Writer writer6-todo used 214.8549041748 seconds, avg 1.1635759535496 events/second
2018-01-25T16:13:37.658642: Writer writer6-blog started
2018-01-25T16:17:41.357546: Writer writer6-blog wrote 250 events
2018-01-25T16:17:41.357642: Writer writer6-blog used 243.68403196335 seconds, avg 1.0259186783219 events/second
2018-01-25T16:13:37.662885: Writer writer6-comment started
2018-01-25T16:17:41.410591: Writer writer6-comment wrote 250 events
2018-01-25T16:17:41.410641: Writer writer6-comment used 243.72924304008 seconds, avg 1.0257283733445 events/second
2018-01-25T16:13:37.718982: Writer writer7-user started
2018-01-25T16:17:33.676553: Writer writer7-user wrote 250 events
2018-01-25T16:17:33.676580: Writer writer7-user used 235.93842792511 seconds, avg 1.0595984816825 events/second
2018-01-25T16:13:37.734110: Writer writer7-post started
2018-01-25T16:17:12.432548: Writer writer7-post wrote 250 events
2018-01-25T16:17:12.432582: Writer writer7-post used 214.68209290504 seconds, avg 1.1645125898348 events/second
2018-01-25T16:13:37.635232: Writer writer7-todo started
2018-01-25T16:17:05.713974: Writer writer7-todo wrote 250 events
2018-01-25T16:17:05.714050: Writer writer7-todo used 208.06423091888 seconds, avg 1.2015520346573 events/second
2018-01-25T16:13:37.642076: Writer writer7-blog started
2018-01-25T16:17:01.654502: Writer writer7-blog wrote 250 events
2018-01-25T16:17:01.654587: Writer writer7-blog used 203.96084189415 seconds, avg 1.2257254759212 events/second
2018-01-25T16:13:37.634802: Writer writer7-comment started
2018-01-25T16:16:50.297743: Writer writer7-comment wrote 250 events
2018-01-25T16:16:50.297802: Writer writer7-comment used 192.64417314529 seconds, avg 1.2977293624731 events/second
2018-01-25T16:13:37.746091: Writer writer8-user started
2018-01-25T16:17:34.102691: Writer writer8-user wrote 250 events
2018-01-25T16:17:34.102785: Writer writer8-user used 236.34392309189 seconds, avg 1.0577805290251 events/second
2018-01-25T16:13:37.754075: Writer writer8-post started
2018-01-25T16:16:41.000672: Writer writer8-post wrote 250 events
2018-01-25T16:16:41.000725: Writer writer8-post used 183.23774003983 seconds, avg 1.3643477590679 events/second
2018-01-25T16:13:37.718482: Writer writer8-todo started
2018-01-25T16:17:29.797565: Writer writer8-todo wrote 250 events
2018-01-25T16:17:29.797634: Writer writer8-todo used 232.05248904228 seconds, avg 1.0773424626118 events/second
2018-01-25T16:13:37.650051: Writer writer8-blog started
2018-01-25T16:17:37.709137: Writer writer8-blog wrote 250 events
2018-01-25T16:17:37.709217: Writer writer8-blog used 240.04777002335 seconds, avg 1.041459372756 events/second
2018-01-25T16:13:37.709061: Writer writer8-comment started
2018-01-25T16:17:40.463098: Writer writer8-comment wrote 250 events
2018-01-25T16:17:40.463148: Writer writer8-comment used 242.72955203056 seconds, avg 1.0299528751593 events/second
2018-01-25T16:13:37.710793: Writer writer9-user started
2018-01-25T16:17:37.824824: Writer writer9-user wrote 250 events
2018-01-25T16:17:37.824940: Writer writer9-user used 240.09143304825 seconds, avg 1.041269972968 events/second
2018-01-25T16:13:37.711096: Writer writer9-post started
2018-01-25T16:17:27.649297: Writer writer9-post wrote 250 events
2018-01-25T16:17:27.649371: Writer writer9-post used 229.9068069458 seconds, avg 1.0873971211254 events/second
2018-01-25T16:13:37.658078: Writer writer9-todo started
2018-01-25T16:17:24.791352: Writer writer9-todo wrote 250 events
2018-01-25T16:17:24.791416: Writer writer9-todo used 227.12440013885 seconds, avg 1.1007183721659 events/second
2018-01-25T16:13:37.719690: Writer writer9-blog started
2018-01-25T16:17:31.746939: Writer writer9-blog wrote 250 events
2018-01-25T16:17:31.747025: Writer writer9-blog used 234.00744199753 seconds, avg 1.0683420914564 events/second
2018-01-25T16:13:37.654124: Writer writer9-comment started
2018-01-25T16:17:27.425364: Writer writer9-comment wrote 250 events
2018-01-25T16:17:27.425464: Writer writer9-comment used 229.75610995293 seconds, avg 1.0881103447095 events/second
2018-01-25T16:13:37.709402: Projection projectorsuser started
2018-01-25T16:17:43.488169: Projection projectorsuser read 2500 events
2018-01-25T16:17:43.488238: projection projectorsuser used 245.76129984856 seconds, avg 10.172472238471 events/second
2018-01-25T16:13:37.703875: Projection projectorspost started
2018-01-25T16:17:43.532387: Projection projectorspost read 2500 events
2018-01-25T16:17:43.532447: projection projectorspost used 245.81440901756 seconds, avg 10.170274435871 events/second
2018-01-25T16:13:37.704303: Projection projectorstodo started
2018-01-25T16:17:43.629466: Projection projectorstodo read 2500 events
2018-01-25T16:17:43.629550: projection projectorstodo used 245.91930294037 seconds, avg 10.165936427553 events/second
2018-01-25T16:13:37.734079: Projection projectorsblog started
2018-01-25T16:17:43.471280: Projection projectorsblog read 2500 events
2018-01-25T16:17:43.471362: projection projectorsblog used 245.73249983788 seconds, avg 10.173664458911 events/second
2018-01-25T16:13:37.723829: Projection projectorscomment started
2018-01-25T16:17:43.549245: Projection projectorscomment read 2500 events
2018-01-25T16:17:43.549303: projection projectorscomment used 245.81671500206 seconds, avg 10.170179029441 events/second
2018-01-25T16:13:37.723510: Projection projectorsall started
2018-01-25T16:17:43.119485: Projection projectorsall read 2500 events
2018-01-25T16:17:43.119520: projection projectorsall used 245.39118289948 seconds, avg 10.187815105908 events/second
mysql real world test duration 246 seconds
mysql avg writes 50 events/second
mysql avg reads 101 events/second
Dumping logs mysql!
Attaching to eventstorebenchmarks_database_1
[36mdatabase_1 |[0m Initializing database
[36mdatabase_1 |[0m 2018-01-25T16:12:57.655883Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[36mdatabase_1 |[0m 2018-01-25T16:12:58.902820Z 0 [Warning] InnoDB: New log files created, LSN=45790
[36mdatabase_1 |[0m 2018-01-25T16:12:59.019711Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
[36mdatabase_1 |[0m 2018-01-25T16:12:59.053714Z 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: 9c44e8f6-01ea-11e8-9a11-0242ac1e0002.
[36mdatabase_1 |[0m 2018-01-25T16:12:59.062628Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
[36mdatabase_1 |[0m 2018-01-25T16:12:59.063470Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
[36mdatabase_1 |[0m 2018-01-25T16:13:01.728250Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:01.728277Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:01.728284Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:01.728297Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:01.728301Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:01.728310Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:01.728336Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:01.728345Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m Database initialized
[36mdatabase_1 |[0m Initializing certificates
[36mdatabase_1 |[0m Generating a 2048 bit RSA private key
[36mdatabase_1 |[0m ................................+++
[36mdatabase_1 |[0m ...........................................+++
[36mdatabase_1 |[0m unable to write 'random state'
[36mdatabase_1 |[0m writing new private key to 'ca-key.pem'
[36mdatabase_1 |[0m -----
[36mdatabase_1 |[0m Generating a 2048 bit RSA private key
[36mdatabase_1 |[0m ..................+++
[36mdatabase_1 |[0m ..........................................................................................................................................................................................................+++
[36mdatabase_1 |[0m unable to write 'random state'
[36mdatabase_1 |[0m writing new private key to 'server-key.pem'
[36mdatabase_1 |[0m -----
[36mdatabase_1 |[0m Generating a 2048 bit RSA private key
[36mdatabase_1 |[0m .......................................+++
[36mdatabase_1 |[0m .................+++
[36mdatabase_1 |[0m unable to write 'random state'
[36mdatabase_1 |[0m writing new private key to 'client-key.pem'
[36mdatabase_1 |[0m -----
[36mdatabase_1 |[0m Certificates initialized
[36mdatabase_1 |[0m MySQL init process in progress...
[36mdatabase_1 |[0m 2018-01-25T16:13:05.772894Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[36mdatabase_1 |[0m 2018-01-25T16:13:05.773744Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 94 ...
[36mdatabase_1 |[0m 2018-01-25T16:13:05.775831Z 0 [Note] InnoDB: PUNCH HOLE support available
[36mdatabase_1 |[0m 2018-01-25T16:13:05.775844Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
[36mdatabase_1 |[0m 2018-01-25T16:13:05.775846Z 0 [Note] InnoDB: Uses event mutexes
[36mdatabase_1 |[0m 2018-01-25T16:13:05.775848Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
[36mdatabase_1 |[0m 2018-01-25T16:13:05.775850Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
[36mdatabase_1 |[0m 2018-01-25T16:13:05.775852Z 0 [Note] InnoDB: Using Linux native AIO
[36mdatabase_1 |[0m 2018-01-25T16:13:05.776555Z 0 [Note] InnoDB: Number of pools: 1
[36mdatabase_1 |[0m 2018-01-25T16:13:05.776640Z 0 [Note] InnoDB: Using CPU crc32 instructions
[36mdatabase_1 |[0m 2018-01-25T16:13:05.777616Z 0 [Note] InnoDB: Initializing buffer pool, total size = 18G, instances = 8, chunk size = 128M
[36mdatabase_1 |[0m 2018-01-25T16:13:06.436320Z 0 [Note] InnoDB: Completed initialization of buffer pool
[36mdatabase_1 |[0m 2018-01-25T16:13:06.547374Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
[36mdatabase_1 |[0m 2018-01-25T16:13:06.548533Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
[36mdatabase_1 |[0m MySQL init process in progress...
[36mdatabase_1 |[0m 2018-01-25T16:13:06.824778Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
[36mdatabase_1 |[0m 2018-01-25T16:13:06.824860Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[36mdatabase_1 |[0m 2018-01-25T16:13:06.856841Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.857509Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.857517Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.858040Z 0 [Note] InnoDB: Waiting for purge to start
[36mdatabase_1 |[0m 2018-01-25T16:13:06.908178Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 2565377
[36mdatabase_1 |[0m 2018-01-25T16:13:06.908424Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
[36mdatabase_1 |[0m 2018-01-25T16:13:06.908516Z 0 [Note] Plugin 'FEDERATED' is disabled.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.910816Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180125 16:13:06
[36mdatabase_1 |[0m 2018-01-25T16:13:06.915208Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.915512Z 0 [Warning] CA certificate ca.pem is self signed.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.928062Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.928100Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.928116Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.928140Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.928147Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.928161Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.929742Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.929765Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.938778Z 0 [Note] Event Scheduler: Loaded 0 events
[36mdatabase_1 |[0m 2018-01-25T16:13:06.939025Z 0 [Note] mysqld: ready for connections.
[36mdatabase_1 |[0m Version: '5.7.20' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
[36mdatabase_1 |[0m 2018-01-25T16:13:06.939046Z 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.
[36mdatabase_1 |[0m 2018-01-25T16:13:06.939053Z 0 [Note] Beginning of list of non-natively partitioned tables
[36mdatabase_1 |[0m 2018-01-25T16:13:06.954121Z 0 [Note] End of list of non-natively partitioned tables
[36mdatabase_1 |[0m Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
[36mdatabase_1 |[0m Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
[36mdatabase_1 |[0m Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.672500Z 5 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.672517Z 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.672526Z 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.672528Z 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.672533Z 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.672549Z 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.672572Z 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m mysql: [Warning] Using a password on the command line interface can be insecure.
[36mdatabase_1 |[0m mysql: [Warning] Using a password on the command line interface can be insecure.
[36mdatabase_1 |[0m mysql: [Warning] Using a password on the command line interface can be insecure.
[36mdatabase_1 |[0m mysql: [Warning] Using a password on the command line interface can be insecure.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.682869Z 9 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.682887Z 9 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.682899Z 9 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.682902Z 9 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.682908Z 9 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.683019Z 9 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.683026Z 9 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m
[36mdatabase_1 |[0m 2018-01-25T16:13:09.683561Z 0 [Note] Giving 0 client threads a chance to die gracefully
[36mdatabase_1 |[0m 2018-01-25T16:13:09.683571Z 0 [Note] Shutting down slave threads
[36mdatabase_1 |[0m 2018-01-25T16:13:09.683573Z 0 [Note] Forcefully disconnecting 0 remaining clients
[36mdatabase_1 |[0m 2018-01-25T16:13:09.683576Z 0 [Note] Event Scheduler: Purging the queue. 0 events
[36mdatabase_1 |[0m 2018-01-25T16:13:09.683595Z 0 [Note] Binlog end
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684053Z 0 [Note] Shutting down plugin 'ngram'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684058Z 0 [Note] Shutting down plugin 'BLACKHOLE'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684061Z 0 [Note] Shutting down plugin 'partition'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684062Z 0 [Note] Shutting down plugin 'ARCHIVE'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684063Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684065Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684066Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684067Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684068Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684070Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684071Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684072Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684073Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684074Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684076Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684077Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684078Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684079Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684080Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684081Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684083Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684084Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684085Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684086Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684087Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684089Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684090Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684091Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684092Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684093Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684094Z 0 [Note] Shutting down plugin 'INNODB_CMP'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684114Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684115Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684119Z 0 [Note] Shutting down plugin 'INNODB_TRX'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684121Z 0 [Note] Shutting down plugin 'InnoDB'
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684166Z 0 [Note] InnoDB: FTS optimize thread exiting.
[36mdatabase_1 |[0m 2018-01-25T16:13:09.684213Z 0 [Note] InnoDB: Starting shutdown...
[36mdatabase_1 |[0m 2018-01-25T16:13:09.784592Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
[36mdatabase_1 |[0m 2018-01-25T16:13:09.785174Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180125 16:13:09
[36mdatabase_1 |[0m 2018-01-25T16:13:12.033598Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12169513
[36mdatabase_1 |[0m 2018-01-25T16:13:12.034927Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
[36mdatabase_1 |[0m 2018-01-25T16:13:12.034955Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
[36mdatabase_1 |[0m 2018-01-25T16:13:12.034958Z 0 [Note] Shutting down plugin 'MyISAM'
[36mdatabase_1 |[0m 2018-01-25T16:13:12.034964Z 0 [Note] Shutting down plugin 'CSV'
[36mdatabase_1 |[0m 2018-01-25T16:13:12.034966Z 0 [Note] Shutting down plugin 'MEMORY'
[36mdatabase_1 |[0m 2018-01-25T16:13:12.034968Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
[36mdatabase_1 |[0m 2018-01-25T16:13:12.035000Z 0 [Note] Shutting down plugin 'sha256_password'
[36mdatabase_1 |[0m 2018-01-25T16:13:12.035003Z 0 [Note] Shutting down plugin 'mysql_native_password'
[36mdatabase_1 |[0m 2018-01-25T16:13:12.035174Z 0 [Note] Shutting down plugin 'binlog'
[36mdatabase_1 |[0m 2018-01-25T16:13:12.036336Z 0 [Note] mysqld: Shutdown complete
[36mdatabase_1 |[0m
[36mdatabase_1 |[0m
[36mdatabase_1 |[0m MySQL init process done. Ready for start up.
[36mdatabase_1 |[0m
[36mdatabase_1 |[0m 2018-01-25T16:13:12.261550Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[36mdatabase_1 |[0m 2018-01-25T16:13:12.262585Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
[36mdatabase_1 |[0m 2018-01-25T16:13:12.264750Z 0 [Note] InnoDB: PUNCH HOLE support available
[36mdatabase_1 |[0m 2018-01-25T16:13:12.264763Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
[36mdatabase_1 |[0m 2018-01-25T16:13:12.264765Z 0 [Note] InnoDB: Uses event mutexes
[36mdatabase_1 |[0m 2018-01-25T16:13:12.264788Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
[36mdatabase_1 |[0m 2018-01-25T16:13:12.264790Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
[36mdatabase_1 |[0m 2018-01-25T16:13:12.264794Z 0 [Note] InnoDB: Using Linux native AIO
[36mdatabase_1 |[0m 2018-01-25T16:13:12.265484Z 0 [Note] InnoDB: Number of pools: 1
[36mdatabase_1 |[0m 2018-01-25T16:13:12.265583Z 0 [Note] InnoDB: Using CPU crc32 instructions
[36mdatabase_1 |[0m 2018-01-25T16:13:12.266545Z 0 [Note] InnoDB: Initializing buffer pool, total size = 18G, instances = 8, chunk size = 128M
[36mdatabase_1 |[0m 2018-01-25T16:13:13.013181Z 0 [Note] InnoDB: Completed initialization of buffer pool
[36mdatabase_1 |[0m 2018-01-25T16:13:13.127902Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
[36mdatabase_1 |[0m 2018-01-25T16:13:13.139907Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.429343Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
[36mdatabase_1 |[0m 2018-01-25T16:13:13.429430Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[36mdatabase_1 |[0m 2018-01-25T16:13:13.462576Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.463194Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.463200Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.463756Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 12169513
[36mdatabase_1 |[0m 2018-01-25T16:13:13.463886Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
[36mdatabase_1 |[0m 2018-01-25T16:13:13.463981Z 0 [Note] Plugin 'FEDERATED' is disabled.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.465913Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180125 16:13:13
[36mdatabase_1 |[0m 2018-01-25T16:13:13.466757Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.466877Z 0 [Warning] CA certificate ca.pem is self signed.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.467963Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
[36mdatabase_1 |[0m 2018-01-25T16:13:13.468001Z 0 [Note] IPv6 is available.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.468005Z 0 [Note] - '::' resolves to '::';
[36mdatabase_1 |[0m 2018-01-25T16:13:13.468014Z 0 [Note] Server socket created on IP: '::'.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.477263Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.477282Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.477294Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.477296Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.477303Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.478476Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.478485Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.481883Z 0 [Note] Event Scheduler: Loaded 0 events
[36mdatabase_1 |[0m 2018-01-25T16:13:13.482032Z 0 [Note] mysqld: ready for connections.
[36mdatabase_1 |[0m Version: '5.7.20' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
[36mdatabase_1 |[0m 2018-01-25T16:13:13.482042Z 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.
[36mdatabase_1 |[0m 2018-01-25T16:13:13.482044Z 0 [Note] Beginning of list of non-natively partitioned tables
[36mdatabase_1 |[0m 2018-01-25T16:13:13.487841Z 0 [Note] End of list of non-natively partitioned tables
Name Command State Ports
-----------------------------------------------------------------------------------------
eventstorebenchmarks_database_1 /entrypoint.sh arangod Up 0.0.0.0:8529->8529/tcp
Docker Info
Containers: 351
Running: 1
Paused: 0
Stopped: 350
Images: 80
Server Version: 17.09.0-ce
Storage Driver: overlay2
Backing Filesystem: extfs
Supports d_type: true
Native Overlay Diff: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host macvlan null overlay
Log: awslogs fluentd gcplogs gelf journald json-file logentries splunk syslog
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 06b9cb35161009dcb7123345749fef02f7cea8e0
runc version: 3f2f8b84a77f73d38244dd690525642a72156c64
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.13.0-31-generic
Operating System: Ubuntu 17.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 31.18GiB
Name: codebook
ID: QODG:6EEM:6T3U:CWGU:KMA6:NNP7:KM72:RYVB:2YGB:BW3E:454Y:EGKH
Docker Root Dir: /var/lib/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: false
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info
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: 158
Model name: Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz
Stepping: 9
CPU MHz: 2800.000
CPU max MHz: 3800,0000
CPU min MHz: 800,0000
BogoMIPS: 5616.00
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 pdpe1gb rdtscp lm constant_tsc art arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf tsc_known_freq pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch cpuid_fault epb invpcid_single pti intel_pt tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid mpx rdseed adx smap clflushopt xsaveopt xsavec xgetbv1 xsaves dtherm ida arat pln pts hwp hwp_notify hwp_act_window hwp_epp
Using 4 CPUs for each service and 25357 MB memory for database.
Waiting for arangodb database, lean back to enjoy the timer.
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark arangodb!
2018-01-25T16:18:17.639952: arangodb: set up event store tables on database _system
2018-01-25T16:18:18.753039: test 1 create 10 streams with 100 events in each stream, using 1 event per commit
2018-01-25T16:18:19.769010: test 1 using arangodb took 1.0159471035004 seconds
2018-01-25T16:18:19.769037: test 1 using arangodb writes 984.3032147585 events per second
2018-01-25T16:18:19.769043: test 2 create 10 streams with 100 events in each stream, using 5 events per commit
2018-01-25T16:18:20.661547: test 2 using arangodb took 0.89249205589294 seconds
2018-01-25T16:18:20.661580: test 2 using arangodb writes 1120.4581524252 events per second
2018-01-25T16:18:20.661586: test 3 create one stream with 2500 events using a single commit
2018-01-25T16:18:20.872991: test 3 using arangodb took 0.21137404441833 seconds
2018-01-25T16:18:20.873016: test 3 using arangodb writes 11827.374580827 events per second
2018-01-25T16:18:20.873022: test 4 load one stream with 2500 events
2018-01-25T16:18:20.882452: test 4 using arangodb took 0.0094010829925537 seconds
2018-01-25T16:18:20.882471: test 4 using arangodb loads 265926.80885598 events per second
2018-01-25T16:18:20.882475: test 5 project 1 stream with 2500 events
2018-01-25T16:18:20.966732: test 5 using arangodb took 0.082963943481445 seconds
2018-01-25T16:18:20.966767: test 5 using arangodb loads 30133.572430283 events per second
2018-01-25T16:18:20.966771: test 6 project 10 stream with 100 events
2018-01-25T16:18:21.109264: test 6 using arangodb took 0.14241003990173 seconds
2018-01-25T16:18:21.109319: test 6 using arangodb loads 7021.9768261425 events per second
2018-01-25T16:18:21.133915: arangodb: destroying event-store tables on database _system
Starting real world benchmark arangodb!
2018-01-25T16:18:21.444816: arangodb: set up event store tables on database _system
Waiting ... stay patient!
2018-01-25T16:18:22.564721: Writer writer0-user started
2018-01-25T16:19:02.797162: Writer writer0-user wrote 250 events
2018-01-25T16:19:02.797209: Writer writer0-user used 40.228917121887 seconds, avg 6.2144352343002 events/second
2018-01-25T16:18:22.729376: Writer writer0-post started
2018-01-25T16:19:03.750481: Writer writer0-post wrote 250 events
2018-01-25T16:19:03.750560: Writer writer0-post used 40.977488994598 seconds, avg 6.1009106739789 events/second
2018-01-25T16:18:22.850807: Writer writer0-todo started
2018-01-25T16:19:03.801423: Writer writer0-todo wrote 250 events
2018-01-25T16:19:03.801502: Writer writer0-todo used 40.899092912674 seconds, avg 6.1126050040716 events/second
2018-01-25T16:18:22.778219: Writer writer0-blog started
2018-01-25T16:19:00.708342: Writer writer0-blog wrote 250 events
2018-01-25T16:19:00.708385: Writer writer0-blog used 37.886403799057 seconds, avg 6.5986732688053 events/second
2018-01-25T16:18:22.897903: Writer writer0-comment started
2018-01-25T16:19:00.596950: Writer writer0-comment wrote 250 events
2018-01-25T16:19:00.596998: Writer writer0-comment used 37.685659170151 seconds, avg 6.6338231970748 events/second
2018-01-25T16:18:22.868174: Writer writer1-user started
2018-01-25T16:19:00.288201: Writer writer1-user wrote 250 events
2018-01-25T16:19:00.288241: Writer writer1-user used 37.372411966324 seconds, avg 6.6894264203572 events/second
2018-01-25T16:18:22.899471: Writer writer1-post started
2018-01-25T16:18:56.541465: Writer writer1-post wrote 250 events
2018-01-25T16:18:56.541499: Writer writer1-post used 33.590372085571 seconds, avg 7.4426088333623 events/second
2018-01-25T16:18:22.719184: Writer writer1-todo started
2018-01-25T16:19:03.890771: Writer writer1-todo wrote 250 events
2018-01-25T16:19:03.890849: Writer writer1-todo used 41.131945133209 seconds, avg 6.0780009112225 events/second
2018-01-25T16:18:22.848427: Writer writer1-blog started
2018-01-25T16:19:02.836551: Writer writer1-blog wrote 250 events
2018-01-25T16:19:02.836583: Writer writer1-blog used 39.924501180649 seconds, avg 6.2618189985345 events/second
2018-01-25T16:18:22.882110: Writer writer1-comment started
2018-01-25T16:19:03.181888: Writer writer1-comment wrote 250 events
2018-01-25T16:19:03.181936: Writer writer1-comment used 40.296172857285 seconds, avg 6.2040631224562 events/second
2018-01-25T16:18:22.913991: Writer writer2-user started
2018-01-25T16:19:04.595631: Writer writer2-user wrote 250 events
2018-01-25T16:19:04.595698: Writer writer2-user used 41.678039073944 seconds, avg 5.9983628202003 events/second
2018-01-25T16:18:22.759672: Writer writer2-post started
2018-01-25T16:19:03.538871: Writer writer2-post wrote 250 events
2018-01-25T16:19:03.538949: Writer writer2-post used 40.735574007034 seconds, avg 6.1371419476458 events/second
2018-01-25T16:18:22.693322: Writer writer2-todo started
2018-01-25T16:19:01.721827: Writer writer2-todo wrote 250 events
2018-01-25T16:19:01.721880: Writer writer2-todo used 38.981487035751 seconds, avg 6.4133007489098 events/second
2018-01-25T16:18:22.752551: Writer writer2-blog started
2018-01-25T16:18:58.547187: Writer writer2-blog wrote 250 events
2018-01-25T16:18:58.547226: Writer writer2-blog used 35.751142978668 seconds, avg 6.9927834237123 events/second
2018-01-25T16:18:22.881079: Writer writer2-comment started
2018-01-25T16:19:03.798342: Writer writer2-comment wrote 250 events
2018-01-25T16:19:03.798409: Writer writer2-comment used 40.861472845078 seconds, avg 6.1182327163745 events/second
2018-01-25T16:18:22.833680: Writer writer3-user started
2018-01-25T16:19:02.247596: Writer writer3-user wrote 250 events
2018-01-25T16:19:02.247635: Writer writer3-user used 39.410479068756 seconds, avg 6.3434905108321 events/second
2018-01-25T16:18:22.908319: Writer writer3-post started
2018-01-25T16:19:03.271282: Writer writer3-post wrote 250 events
2018-01-25T16:19:03.271330: Writer writer3-post used 40.34036397934 seconds, avg 6.1972668399333 events/second
2018-01-25T16:18:22.771606: Writer writer3-todo started
2018-01-25T16:19:02.798221: Writer writer3-todo wrote 250 events
2018-01-25T16:19:02.798267: Writer writer3-todo used 39.994696855545 seconds, avg 6.2508287261925 events/second
2018-01-25T16:18:22.776205: Writer writer3-blog started
2018-01-25T16:19:02.019743: Writer writer3-blog wrote 250 events
2018-01-25T16:19:02.019792: Writer writer3-blog used 39.208029031754 seconds, avg 6.3762450236285 events/second
2018-01-25T16:18:22.768699: Writer writer3-comment started
2018-01-25T16:18:59.393906: Writer writer3-comment wrote 250 events
2018-01-25T16:18:59.393956: Writer writer3-comment used 36.585725069046 seconds, avg 6.8332662405403 events/second
2018-01-25T16:18:22.899225: Writer writer4-user started
2018-01-25T16:19:01.866794: Writer writer4-user wrote 250 events
2018-01-25T16:19:01.866845: Writer writer4-user used 38.911748170853 seconds, avg 6.4247948692078 events/second
2018-01-25T16:18:22.937520: Writer writer4-post started
2018-01-25T16:18:59.395763: Writer writer4-post wrote 250 events
2018-01-25T16:18:59.395813: Writer writer4-post used 36.45408987999 seconds, avg 6.8579410656808 events/second
2018-01-25T16:18:22.923326: Writer writer4-todo started
2018-01-25T16:19:03.544459: Writer writer4-todo wrote 250 events
2018-01-25T16:19:03.544536: Writer writer4-todo used 40.587938785553 seconds, avg 6.1594652864951 events/second
2018-01-25T16:18:22.944015: Writer writer4-blog started
2018-01-25T16:19:03.889440: Writer writer4-blog wrote 250 events
2018-01-25T16:19:03.889528: Writer writer4-blog used 40.913235902786 seconds, avg 6.1104919834262 events/second
2018-01-25T16:18:22.934400: Writer writer4-comment started
2018-01-25T16:19:03.971293: Writer writer4-comment wrote 250 events
2018-01-25T16:19:03.971357: Writer writer4-comment used 41.013495206833 seconds, avg 6.0955546153586 events/second
2018-01-25T16:18:22.928046: Writer writer5-user started
2018-01-25T16:19:04.308159: Writer writer5-user wrote 250 events
2018-01-25T16:19:04.308225: Writer writer5-user used 41.341641902924 seconds, avg 6.0471715319638 events/second
2018-01-25T16:18:22.926377: Writer writer5-post started
2018-01-25T16:19:00.019761: Writer writer5-post wrote 250 events
2018-01-25T16:19:00.019812: Writer writer5-post used 37.089572191238 seconds, avg 6.7404390298968 events/second
2018-01-25T16:18:22.908319: Writer writer5-todo started
2018-01-25T16:19:01.813424: Writer writer5-todo wrote 250 events
2018-01-25T16:19:01.813446: Writer writer5-todo used 38.853356838226 seconds, avg 6.4344504656554 events/second
2018-01-25T16:18:22.896009: Writer writer5-blog started
2018-01-25T16:19:01.869391: Writer writer5-blog wrote 250 events
2018-01-25T16:19:01.869444: Writer writer5-blog used 38.945760965347 seconds, avg 6.4191838547574 events/second
2018-01-25T16:18:22.892574: Writer writer5-comment started
2018-01-25T16:18:59.228225: Writer writer5-comment wrote 250 events
2018-01-25T16:18:59.228268: Writer writer5-comment used 36.287981987 seconds, avg 6.8893332257926 events/second
2018-01-25T16:18:22.863594: Writer writer6-user started
2018-01-25T16:18:58.811305: Writer writer6-user wrote 250 events
2018-01-25T16:18:58.811342: Writer writer6-user used 35.943964004517 seconds, avg 6.9552707088341 events/second
2018-01-25T16:18:22.790501: Writer writer6-post started
2018-01-25T16:19:03.319913: Writer writer6-post wrote 250 events
2018-01-25T16:19:03.319956: Writer writer6-post used 40.489912986755 seconds, avg 6.1743773092764 events/second
2018-01-25T16:18:22.757499: Writer writer6-todo started
2018-01-25T16:19:03.698890: Writer writer6-todo wrote 250 events
2018-01-25T16:19:03.698967: Writer writer6-todo used 40.901894807816 seconds, avg 6.1121862733907 events/second
2018-01-25T16:18:22.949937: Writer writer6-blog started
2018-01-25T16:19:00.534848: Writer writer6-blog wrote 250 events
2018-01-25T16:19:00.534910: Writer writer6-blog used 37.58119392395 seconds, avg 6.6522633768875 events/second
2018-01-25T16:18:22.886172: Writer writer6-comment started
2018-01-25T16:19:00.635952: Writer writer6-comment wrote 250 events
2018-01-25T16:19:00.635997: Writer writer6-comment used 37.746220827103 seconds, avg 6.6231796063805 events/second
2018-01-25T16:18:22.909349: Writer writer7-user started
2018-01-25T16:19:02.355883: Writer writer7-user wrote 250 events
2018-01-25T16:19:02.355922: Writer writer7-user used 39.44297003746 seconds, avg 6.3382650891291 events/second
2018-01-25T16:18:22.929014: Writer writer7-post started
2018-01-25T16:19:03.756941: Writer writer7-post wrote 250 events
2018-01-25T16:19:03.757007: Writer writer7-post used 40.819036006927 seconds, avg 6.124593436199 events/second
2018-01-25T16:18:22.897383: Writer writer7-todo started
2018-01-25T16:19:03.585222: Writer writer7-todo wrote 250 events
2018-01-25T16:19:03.585295: Writer writer7-todo used 40.636120080948 seconds, avg 6.1521621528334 events/second
2018-01-25T16:18:22.920833: Writer writer7-blog started
2018-01-25T16:19:03.936136: Writer writer7-blog wrote 250 events
2018-01-25T16:19:03.936207: Writer writer7-blog used 40.983820915222 seconds, avg 6.0999680951452 events/second
2018-01-25T16:18:22.820417: Writer writer7-comment started
2018-01-25T16:19:03.836531: Writer writer7-comment wrote 250 events
2018-01-25T16:19:03.836596: Writer writer7-comment used 40.980073213577 seconds, avg 6.100525948235 events/second
2018-01-25T16:18:22.884364: Writer writer8-user started
2018-01-25T16:19:03.397704: Writer writer8-user wrote 250 events
2018-01-25T16:19:03.397786: Writer writer8-user used 40.465598106384 seconds, avg 6.1780873556533 events/second
2018-01-25T16:18:22.842846: Writer writer8-post started
2018-01-25T16:19:04.624404: Writer writer8-post wrote 250 events
2018-01-25T16:19:04.624491: Writer writer8-post used 41.754002094269 seconds, avg 5.987450003848 events/second
2018-01-25T16:18:22.903737: Writer writer8-todo started
2018-01-25T16:19:01.868501: Writer writer8-todo wrote 250 events
2018-01-25T16:19:01.868550: Writer writer8-todo used 38.961124897003 seconds, avg 6.416652513522 events/second
2018-01-25T16:18:22.891583: Writer writer8-blog started
2018-01-25T16:19:03.067129: Writer writer8-blog wrote 250 events
2018-01-25T16:19:03.067191: Writer writer8-blog used 40.119808912277 seconds, avg 6.231335761011 events/second
2018-01-25T16:18:22.839027: Writer writer8-comment started
2018-01-25T16:19:02.591767: Writer writer8-comment wrote 250 events
2018-01-25T16:19:02.591809: Writer writer8-comment used 39.748537063599 seconds, avg 6.2895396527423 events/second
2018-01-25T16:18:22.827861: Writer writer9-user started
2018-01-25T16:19:04.641984: Writer writer9-user wrote 250 events
2018-01-25T16:19:04.642041: Writer writer9-user used 41.781563043594 seconds, avg 5.9835004195308 events/second
2018-01-25T16:18:22.765100: Writer writer9-post started
2018-01-25T16:19:03.528701: Writer writer9-post wrote 250 events
2018-01-25T16:19:03.528764: Writer writer9-post used 40.710300922394 seconds, avg 6.1409519049387 events/second
2018-01-25T16:18:22.958184: Writer writer9-todo started
2018-01-25T16:18:56.791040: Writer writer9-todo wrote 250 events
2018-01-25T16:18:56.791111: Writer writer9-todo used 33.829195022583 seconds, avg 7.3900664746267 events/second
2018-01-25T16:18:22.831988: Writer writer9-blog started
2018-01-25T16:19:03.484842: Writer writer9-blog wrote 250 events
2018-01-25T16:19:03.484904: Writer writer9-blog used 40.618093967438 seconds, avg 6.1548924526202 events/second
2018-01-25T16:18:22.835781: Writer writer9-comment started
2018-01-25T16:19:00.325268: Writer writer9-comment wrote 250 events
2018-01-25T16:19:00.325308: Writer writer9-comment used 37.453517913818 seconds, avg 6.6749404041366 events/second
2018-01-25T16:18:22.813164: Projection projectorsuser started
2018-01-25T16:19:04.860740: Projection projectorsuser read 2500 events
2018-01-25T16:19:04.860767: projection projectorsuser used 42.009256839752 seconds, avg 59.510693310678 events/second
2018-01-25T16:18:22.816104: Projection projectorspost started
2018-01-25T16:19:04.990297: Projection projectorspost read 2500 events
2018-01-25T16:19:04.990320: projection projectorspost used 42.134042024612 seconds, avg 59.334445020481 events/second
2018-01-25T16:18:22.966980: Projection projectorstodo started
2018-01-25T16:19:04.754163: Projection projectorstodo read 2500 events
2018-01-25T16:19:04.754195: projection projectorstodo used 41.782840967178 seconds, avg 59.833174148302 events/second
2018-01-25T16:18:22.860500: Projection projectorsblog started
2018-01-25T16:19:04.767903: Projection projectorsblog read 2500 events
2018-01-25T16:19:04.767951: projection projectorsblog used 41.84427690506 seconds, avg 59.745326838177 events/second
2018-01-25T16:18:22.926368: Projection projectorscomment started
2018-01-25T16:19:04.862579: Projection projectorscomment read 2500 events
2018-01-25T16:19:04.862602: projection projectorscomment used 41.91558098793 seconds, avg 59.643691941664 events/second
2018-01-25T16:18:22.825149: Projection projectorsall started
2018-01-25T16:18:48.101399: Projection projectorsall read 2500 events
2018-01-25T16:18:48.101431: projection projectorsall used 25.272212982178 seconds, avg 98.922876352895 events/second
arangodb real world test duration 42 seconds
arangodb avg writes 297 events/second
arangodb avg reads 595 events/second
Dumping logs arangodb!
Attaching to eventstorebenchmarks_database_1
[36mdatabase_1 |[0m automaticaly choosing storage engine
[36mdatabase_1 |[0m Initializing database...Hang on...
[36mdatabase_1 |[0m Database initialized...Starting System...
Name Command State Ports
-------------------------------------------------------------------------------------------------
eventstorebenchmarks_database_1 docker-entrypoint.sh -c ma ... Up 0.0.0.0:5432->5432/tcp
Docker Info
Containers: 351
Running: 1
Paused: 0
Stopped: 350
Images: 80
Server Version: 17.09.0-ce
Storage Driver: overlay2
Backing Filesystem: extfs
Supports d_type: true
Native Overlay Diff: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
Volume: local
Network: bridge host macvlan null overlay
Log: awslogs fluentd gcplogs gelf journald json-file logentries splunk syslog
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 06b9cb35161009dcb7123345749fef02f7cea8e0
runc version: 3f2f8b84a77f73d38244dd690525642a72156c64
init version: 949e6fa
Security Options:
apparmor
seccomp
Profile: default
Kernel Version: 4.13.0-31-generic
Operating System: Ubuntu 17.10
OSType: linux
Architecture: x86_64
CPUs: 8
Total Memory: 31.18GiB
Name: codebook
ID: QODG:6EEM:6T3U:CWGU:KMA6:NNP7:KM72:RYVB:2YGB:BW3E:454Y:EGKH
Docker Root Dir: /var/lib/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
Experimental: false
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
Hardware Info
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: 158
Model name: Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz
Stepping: 9
CPU MHz: 2800.000
CPU max MHz: 3800,0000
CPU min MHz: 800,0000
BogoMIPS: 5616.00
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 pdpe1gb rdtscp lm constant_tsc art arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf tsc_known_freq pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch cpuid_fault epb invpcid_single pti intel_pt tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid mpx rdseed adx smap clflushopt xsaveopt xsavec xgetbv1 xsaves dtherm ida arat pln pts hwp hwp_notify hwp_act_window hwp_epp
Using 4 CPUs for each service and 25341 MB memory for database.
Waiting for postgres database, lean back to enjoy the timer.
19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
Starting benchmark postgres!
2018-01-25T16:19:42.304231: postgres: set up event store tables on database event_store_tests
2018-01-25T16:19:43.433146: test 1 create 10 streams with 100 events in each stream, using 1 event per commit
2018-01-25T16:19:44.512306: test 1 using postgres took 1.0791218280792 seconds
2018-01-25T16:19:44.512348: test 1 using postgres writes 926.67942949495 events per second
2018-01-25T16:19:44.512366: test 2 create 10 streams with 100 events in each stream, using 5 events per commit
2018-01-25T16:19:45.229419: test 2 using postgres took 0.7170250415802 seconds
2018-01-25T16:19:45.229455: test 2 using postgres writes 1394.6514305779 events per second
2018-01-25T16:19:45.229469: test 3 create one stream with 2500 events using a single commit
2018-01-25T16:19:45.461239: test 3 using postgres took 0.23173689842224 seconds
2018-01-25T16:19:45.461259: test 3 using postgres writes 10788.096401656 events per second
2018-01-25T16:19:45.461264: test 4 load one stream with 2500 events
2018-01-25T16:19:45.466662: test 4 using postgres took 0.0053689479827881 seconds
2018-01-25T16:19:45.466679: test 4 using postgres loads 465640.57018518 events per second
2018-01-25T16:19:45.466683: test 5 project 1 stream with 2500 events
2018-01-25T16:19:45.565150: test 5 using postgres took 0.097209930419922 seconds
2018-01-25T16:19:45.565195: test 5 using postgres loads 25717.537181651 events per second
2018-01-25T16:19:45.565209: test 6 project 10 stream with 100 events
2018-01-25T16:19:45.729478: test 6 using postgres took 0.16418600082397 seconds
2018-01-25T16:19:45.729496: test 6 using postgres loads 6090.653252905 events per second
2018-01-25T16:19:45.749706: postgres: destroying event-store tables on database event_store_tests
Starting real world benchmark postgres!
2018-01-25T16:19:45.911615: postgres: set up event store tables on database event_store_tests
Waiting ... stay patient!
2018-01-25T16:19:47.313110: Writer writer0-user started
2018-01-25T16:19:57.929597: Writer writer0-user wrote 250 events
2018-01-25T16:19:57.929617: Writer writer0-user used 10.531270980835 seconds, avg 23.738825109994 events/second
2018-01-25T16:19:47.364257: Writer writer0-post started
2018-01-25T16:19:57.979922: Writer writer0-post wrote 250 events
2018-01-25T16:19:57.979941: Writer writer0-post used 10.604973077774 seconds, avg 23.573845795418 events/second
2018-01-25T16:19:47.305961: Writer writer0-todo started
2018-01-25T16:19:57.665002: Writer writer0-todo wrote 250 events
2018-01-25T16:19:57.665020: Writer writer0-todo used 10.347061872482 seconds, avg 24.161448252752 events/second
2018-01-25T16:19:47.297501: Writer writer0-blog started
2018-01-25T16:19:57.443009: Writer writer0-blog wrote 250 events
2018-01-25T16:19:57.443041: Writer writer0-blog used 10.134130954742 seconds, avg 24.66911086076 events/second
2018-01-25T16:19:47.310054: Writer writer0-comment started
2018-01-25T16:19:57.504229: Writer writer0-comment wrote 250 events
2018-01-25T16:19:57.504253: Writer writer0-comment used 10.175456047058 seconds, avg 24.568923382287 events/second
2018-01-25T16:19:47.389394: Writer writer1-user started
2018-01-25T16:19:57.757667: Writer writer1-user wrote 250 events
2018-01-25T16:19:57.757686: Writer writer1-user used 10.34476518631 seconds, avg 24.166812440639 events/second
2018-01-25T16:19:47.280808: Writer writer1-post started
2018-01-25T16:19:57.506009: Writer writer1-post wrote 250 events
2018-01-25T16:19:57.506035: Writer writer1-post used 10.208947181702 seconds, avg 24.488323384423 events/second
2018-01-25T16:19:47.345128: Writer writer1-todo started
2018-01-25T16:19:57.757608: Writer writer1-todo wrote 250 events
2018-01-25T16:19:57.757658: Writer writer1-todo used 10.363176107407 seconds, avg 24.1238783756 events/second
2018-01-25T16:19:47.323293: Writer writer1-blog started
2018-01-25T16:19:57.792823: Writer writer1-blog wrote 250 events
2018-01-25T16:19:57.792850: Writer writer1-blog used 10.400485038757 seconds, avg 24.037340476754 events/second
2018-01-25T16:19:47.314228: Writer writer1-comment started
2018-01-25T16:19:57.964196: Writer writer1-comment wrote 250 events
2018-01-25T16:19:57.964218: Writer writer1-comment used 10.589532136917 seconds, avg 23.608219585873 events/second
2018-01-25T16:19:47.344304: Writer writer2-user started
2018-01-25T16:19:57.789796: Writer writer2-user wrote 250 events
2018-01-25T16:19:57.789836: Writer writer2-user used 10.388623952866 seconds, avg 24.064784819845 events/second
2018-01-25T16:19:47.326784: Writer writer2-post started
2018-01-25T16:19:57.591254: Writer writer2-post wrote 250 events
2018-01-25T16:19:57.591276: Writer writer2-post used 10.245784044266 seconds, avg 24.400280048838 events/second
2018-01-25T16:19:47.406215: Writer writer2-todo started
2018-01-25T16:19:57.817162: Writer writer2-todo wrote 250 events
2018-01-25T16:19:57.817190: Writer writer2-todo used 10.397094964981 seconds, avg 24.045178085036 events/second
2018-01-25T16:19:47.312843: Writer writer2-blog started
2018-01-25T16:19:57.743600: Writer writer2-blog wrote 250 events
2018-01-25T16:19:57.743623: Writer writer2-blog used 10.365057229996 seconds, avg 24.119500206571 events/second
2018-01-25T16:19:47.321335: Writer writer2-comment started
2018-01-25T16:19:57.984179: Writer writer2-comment wrote 250 events
2018-01-25T16:19:57.984199: Writer writer2-comment used 10.646459817886 seconds, avg 23.481984084512 events/second
2018-01-25T16:19:47.323602: Writer writer3-user started
2018-01-25T16:19:57.871252: Writer writer3-user wrote 250 events
2018-01-25T16:19:57.871284: Writer writer3-user used 10.529412984848 seconds, avg 23.74301400845 events/second
2018-01-25T16:19:47.337622: Writer writer3-post started
2018-01-25T16:19:57.790088: Writer writer3-post wrote 250 events
2018-01-25T16:19:57.790108: Writer writer3-post used 10.414020061493 seconds, avg 24.006099328002 events/second
2018-01-25T16:19:47.317872: Writer writer3-todo started
2018-01-25T16:19:57.664912: Writer writer3-todo wrote 250 events
2018-01-25T16:19:57.664932: Writer writer3-todo used 10.236349105835 seconds, avg 24.422770014506 events/second
2018-01-25T16:19:47.319387: Writer writer3-blog started
2018-01-25T16:19:57.664632: Writer writer3-blog wrote 250 events
2018-01-25T16:19:57.664649: Writer writer3-blog used 10.313665866852 seconds, avg 24.239683855136 events/second
2018-01-25T16:19:47.350580: Writer writer3-comment started
2018-01-25T16:19:57.757924: Writer writer3-comment wrote 250 events
2018-01-25T16:19:57.757943: Writer writer3-comment used 10.344588041306 seconds, avg 24.167226283131 events/second
2018-01-25T16:19:47.316900: Writer writer4-user started
2018-01-25T16:19:57.603339: Writer writer4-user wrote 250 events
2018-01-25T16:19:57.603362: Writer writer4-user used 10.196046829224 seconds, avg 24.519306765388 events/second
2018-01-25T16:19:47.362149: Writer writer4-post started
2018-01-25T16:19:57.916548: Writer writer4-post wrote 250 events
2018-01-25T16:19:57.916574: Writer writer4-post used 10.530316829681 seconds, avg 23.740976083012 events/second
2018-01-25T16:19:47.316181: Writer writer4-todo started
2018-01-25T16:19:57.737091: Writer writer4-todo wrote 250 events
2018-01-25T16:19:57.737114: Writer writer4-todo used 10.40466094017 seconds, avg 24.027693111536 events/second
2018-01-25T16:19:47.314707: Writer writer4-blog started
2018-01-25T16:19:58.028462: Writer writer4-blog wrote 250 events
2018-01-25T16:19:58.028486: Writer writer4-blog used 10.671414136887 seconds, avg 23.427073187597 events/second
2018-01-25T16:19:47.324322: Writer writer4-comment started
2018-01-25T16:19:57.552637: Writer writer4-comment wrote 250 events
2018-01-25T16:19:57.552665: Writer writer4-comment used 10.216861963272 seconds, avg 24.469352810942 events/second
2018-01-25T16:19:47.383203: Writer writer5-user started
2018-01-25T16:19:57.854272: Writer writer5-user wrote 250 events
2018-01-25T16:19:57.854292: Writer writer5-user used 10.41517496109 seconds, avg 24.003437381894 events/second