workloadb.yaml

# Copyright 2021 Google LLC

# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at

#     https://www.apache.org/licenses/LICENSE-2.0

# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

# Spanner throughput benchmark PKB configuration (workloadb)
benchmarks:
- cloud_spanner_ycsb:
    flags:
      # Spanner Provisioning
      cloud_spanner_config: regional-us-east4
      cloud_spanner_nodes: 3
      cloud_spanner_ycsb_readmode: 'read'

      # GCE Provisioning: 5 In-Region VMs per Spanner Node
      ycsb_client_vms: 25
      machine_type: n1-standard-2
      gce_network_name: default
      zone: us-east4-a

      # Data: 1000M 1kb rows (1TB total)
      ycsb_record_count: 1000000000
      ycsb_field_count: 1
      ycsb_field_length: 1000

      # Use 25 threads/VM in Load phase
      ycsb_preload_threads: '25'

      # Sleep 1hr between Load and Run phases
      ycsb_sleep_after_load_in_sec: 3600

      # Execute workloadb for 30minutes
      ycsb_workload_files: workloadb
      ycsb_timelimit: 1800
      ycsb_operation_count: 2000000000 # Opcount high so we hit timelimit
      ycsb_threads_per_client: '25'

      # Target 1,440 QPS/VM (12,000 QPS / Spanner Node)
      ycsb_run_parameters: target=1440,requestdistribution=zipfian,dataintegrity=True

      # Output the results as a histogram
      ycsb_measurement_type: hdrhistogram