generate variations in start and end time

ali786XI · ali786XI · commit fe6fddb9fe63 · 2024-02-14T15:02:22.000+05:30
diff --git a/packages/mysql/_dev/benchmark/rally/slowlog-benchmark/config.yml b/packages/mysql/_dev/benchmark/rally/slowlog-benchmark/config.yml
@@ -141,3 +141,7 @@ fields:
     range:
       min: 0
       max: 100
+  - name: duration_start
+    enum: ["-1h", "-2h", "-3h", "-4h"]
+  - name: duration_end
+    enum: ["-30m", "-20m", "-10m", "-40m"]
diff --git a/packages/mysql/_dev/benchmark/rally/slowlog-benchmark/fields.yml b/packages/mysql/_dev/benchmark/rally/slowlog-benchmark/fields.yml
@@ -80,3 +80,7 @@
   type: keyword
 - name: log_slow_rate_limit
   type: long
+- name: duration_start
+  type: keyword
+- name: duration_end
+  type: keyword
diff --git a/packages/mysql/_dev/benchmark/rally/slowlog-benchmark/template.ndjson b/packages/mysql/_dev/benchmark/rally/slowlog-benchmark/template.ndjson
@@ -29,8 +29,10 @@
 {{- $createdTmpDiskTables := generate "created_tmp_disk_tables" }}
 {{- $createdTmpTables := generate "created_tmp_tables" }}
 {{- $tmpTableSizes := generate "tmp_table_sizes" }}
-{{- $startTime := generate "timestamp" | date_modify "-5m" }}
-{{- $endTime := generate "timestamp" | date_modify "-2m" }}
+{{- $duration_start := generate "duration_start" }}
+{{- $duration_end := generate "duration_end" }}
+{{- $startTime := generate "timestamp" | date_modify (print $duration_start) }}
+{{- $endTime := generate "timestamp" | date_modify (print $duration_end) }}
 {{- $innodbTrxId := generate "innodb_trx_id" }}
 {{- $mergePasses := generate "merge_passes" }}
 {{- $innodbIoROps := generate "innodb_io_r_ops" }}
