tuning_params_mysql.yaml

project: "mysql"
maxiterations: 100
startworkload: ""
stopworkload: ""
object : 
  -
    name : "block.read_ahead_kb"
  -
    name : "transparent_hugepage.defrag"
  -
    name : "transparent_hugepage.enabled"
  -
    name : "block.queue_depth"
  -
    name : "block.nr_requests"
  -
    name : "vm.swappiness"
  -
    name : "vm.dirty_ratio"
  -
    name : "kernel.sched_cfs_bandwidth_slice_us"
  -
    name : "kernel.sched_migration_cost_ns"
  -
    name : "kernel.sched_latency_ns"
  -
    name : "kernel.sched_min_granularity_ns"
  -
    name : "kernel.sched_wakeup_granularity_ns"
  -
    name : "kernel.sched_autogroup_enabled"
  -
    name : "kernel.numa_balancing"
  -
    name : "net.core.rmem_default"
  -
    name : "net.core.rmem_max"
  -
    name : "net.core.wmem_default"
  -
    name : "net.core.wmem_max"
  -
    name : "net.ipv4.tcp_rmem"
  -
    name : "net.ipv4.tcp_wmem"
  -
    name : "net.core.dev_weight"
  -
    name : "net.ipv4.tcp_max_syn_backlog"
  -
    name : "net.core.somaxconn"
  -
    name : "net.ipv4.tcp_max_tw_buckets"
  -
    name : "mysql.innodb_io_capacity"
  -
    name : "mysql.innodb_write_io_threads"
  -
    name : "mysql.innodb_read_io_threads"
  -
    name : "mysql.innodb_spin_wait_delay"
  -
    name : "mysql.innodb_sync_spin_loops"
  -
    name : "mysql.innodb_log_file_size"
  -
    name : "mysql.innodb_log_files_in_group"
  -
    name : "mysql.innodb_buffer_pool_instances"
  -
    name : "mysql.innodb_log_buffer_size"
  -
    name : "mysql.innodb_page_cleaners"
  -
    name : "mysql.innodb_lru_scan_depth"
  -
    name : "mysql.innodb_thread_concurrency"