mongosql/benchmark/atlas_sql/normalized/workload_norm_sf0.1.yml at 92a969156a84d50ba294e5d05c8730d938eae3f3 · mongodb/mongosql · GitHub

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
SchemaVersion: 2018-07-01
Owner: "@10gen/sql-engines-team"
Description: |
  This workload runs the TPC-H Queries for
  the normalized scale factor .001 dataset

Clients:
  Default:
    QueryOptions:
      maxPoolSize: 100
      socketTimeoutMS: 86_400_000  # 1 day
    URI: "mongodb://localhost:27017"

Actors:
- Name: NewTest
  Type: RunCommand
  Threads: 1
  Phases:
  # Phase numbering starts with Phase 0
  - LoadConfig:
      Path: phase/q15_normalized.yml
      Key: TPCHNormalizedQuery15CreateView
  - LoadConfig:
      Path: phase/q1_normalized.yml
      Key: q1_normalized
  - LoadConfig:
      Path: phase/q2_normalized.yml
      Key: q2_normalized
  - LoadConfig:
      Path: phase/q3_normalized.yml
      Key: q3_normalized
  - LoadConfig:
      Path: phase/q4_normalized.yml
      Key: q4_normalized
  - LoadConfig:
      Path: phase/q5_normalized.yml
      Key: q5_normalized
  - LoadConfig:
      Path: phase/q6_normalized.yml
      Key: q6_normalized
  - LoadConfig:
      Path: phase/q7_normalized.yml
      Key: q7_normalized
  - LoadConfig:
      Path: phase/q8_normalized.yml
      Key: q8_normalized
  - LoadConfig:
      Path: phase/q9_normalized.yml
      Key: q9_normalized
  - LoadConfig:
      Path: phase/q10_normalized.yml
      Key: q10_normalized
  - LoadConfig:
      Path: phase/q11_normalized.yml
      Key: q11_normalized
  # skip reason: SQL-3178 (OR de-optimization regression, query times out)
  # - LoadConfig:
  #     Path: phase/q12_normalized.yml
  #     Key: q12_normalized
  - LoadConfig:
      Path: ../phase_noop.yml
      Key: NoopPhase
  - LoadConfig:
      Path: phase/q13_normalized.yml
      Key: q13_normalized
  - LoadConfig:
      Path: phase/q14_normalized.yml
      Key: q14_normalized
  # Q15 Uses `revenue` view from previous phase
  - LoadConfig:
      Path: phase/q15_normalized.yml
      Key: q15_normalized
  - LoadConfig:
      Path: phase/q16_normalized.yml
      Key: q16_normalized
  - LoadConfig:
      Path: phase/q17_normalized.yml
      Key: q17_normalized
  # skip reason: SQL-1635
  # - LoadConfig:
  #     Path: phase/q18_normalized.yml
  #     Key: q18_normalized
  - LoadConfig:
      Path: ../phase_noop.yml
      Key: NoopPhase
  - LoadConfig:
      Path: phase/q19_normalized.yml
      Key: q19_normalized

  # skip-reason: SQL-1906
  # - LoadConfig:
  #     Path: phase/q20_normalized.yml
  #     Key: q20_normalized

  - LoadConfig:
      Path: ../phase_noop.yml
      Key: NoopPhase
  - LoadConfig:
      Path: phase/q21_normalized.yml
      Key: q21_normalized
  - LoadConfig:
      Path: phase/q22_normalized.yml
      Key: q22_normalized

  # -- Start of Custom Queries --
  - LoadConfig:
      Path: phase/q19_custom_normalized.yml
      Key: q19_custom_normalized

  # Adding to end to keep phase number aligned with query number
  - LoadConfig:
      Path: phase/q15_normalized.yml
      Key: TPCHNormalizedQuery15DropView