Инструментарий централизованной настройки серверов для новых времен

Файл конфигурации сервера

# cat /etc/atuned/tuning/mysql_sysbench_server.yaml 

project: “mysql_sysbench”

maxiterations: 2048

startworkload: “`mysqld & ` & sleep 10” 

stopworkload: “mysqladmin -S/var/lib/mysql/mysql.sock shutdown -uroot -p123456” 

object : 

  –

    name : “kernel.numa_balancing”

    info :

        desc : “Specifies whether to enable NUMA automatic balancing.”

        get : “sysctl -n kernel.numa_balancing”

        set : “sysctl -w kernel.numa_balancing=$value”

        needrestart : “false”

        type : “discrete”

        options :

          – “0”

          – “1”

        dtype : “string”

  –

    name : “kernel.sched_autogroup_enabled”

    info :

        desc : “When enabled, the kernel creates task groups to optimize desktop program scheduling.

0: disabled

1: enabled”

        get : “sysctl -n kernel.sched_autogroup_enabled”

        set : “sysctl -w kernel.sched_autogroup_enabled=$value”

        needrestart : “false”

        type : “discrete”

        options :

          – “0”

          – “1”

        dtype : “string”

  –

    name : “kernel.sched_wakeup_granularity_ns”

    info :

        desc : “This variable indicates the base of the minimum time that a process should run after it is woken up. The smaller the base, the higher the probability of preemption.”

        get : “sysctl -n kernel.sched_wakeup_granularity_ns”

        set : “sysctl -w kernel.sched_wakeup_granularity_ns=$value”

        needrestart : “false”

        type : “discrete”

        scope :

          – 1000000

          – 100000000

        step : 1000000

        items : 

        dtype : “int”

  –

    name : “kernel.sched_min_granularity_ns”

    info :

        desc : “Minimum running time of a process on the CPU. During this time, the kernel does not proactively select other processes for scheduling (in nanoseconds).”

        get : “sysctl -n kernel.sched_min_granularity_ns”

        set : “sysctl -w kernel.sched_min_granularity_ns=$value”

        needrestart : “false”

        type : “discrete”

        scope :

          – 1000000

          – 100000000

        step : 1000000

        items : 

        dtype : “int”

  –

    name : “innodb_io_capacity”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_io_capacity’.”

        get : “cat /etc/my.cnf | grep ‘innodb_io_capacity’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_io_capacity.*$/innodb_io_capacity=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 100

          – 10000

        dtype : “int”

  –

    name : “innodb_write_io_threads”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_write_io_threads’.”

        get : “cat /etc/my.cnf | grep ‘innodb_write_io_threads’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_write_io_threads.*$/innodb_write_io_threads=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 2

          – 200

        dtype : “int”

  –

    name : “innodb_read_io_threads”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_read_io_threads’.”

        get : “cat /etc/my.cnf | grep ‘innodb_read_io_threads’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_read_io_threads.*$/innodb_read_io_threads=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 2

          – 30

        dtype : “int”

  –

    name : “innodb_spin_wait_delay”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_spin_wait_delay’.”

        get : “cat /etc/my.cnf | grep ‘innodb_spin_wait_delay’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_spin_wait_delay.*$/innodb_spin_wait_delay=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 2

          – 30

        dtype : “int”

  –

    name : “innodb_sync_spin_loops”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_sync_spin_loops’.”

        get : “cat /etc/my.cnf | grep ‘innodb_sync_spin_loops’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_sync_spin_loops.*$/innodb_sync_spin_loops=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 10

          – 500

        dtype : “int”

  –

    name : “innodb_log_file_size”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_log_file_size’.”

        get : “cat /etc/my.cnf | grep ‘innodb_log_file_size’ | awk -F ‘=’ ‘{print $2}’ | awk -F ‘M’ ‘{print $1}'”

        set : “sed -i ‘s/^innodb_log_file_size.*$/innodb_log_file_size=$valueM/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 10

          – 1024

        dtype : “int”

  –

    name : “innodb_log_files_in_group”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_log_files_in_group’.”

        get : “cat /etc/my.cnf | grep ‘innodb_log_files_in_group’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_log_files_in_group.*$/innodb_log_files_in_group=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 1

          – 20

        dtype : “int”

  –

    name : “innodb_buffer_pool_instances”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_buffer_pool_instances’.”

        get : “cat /etc/my.cnf | grep ‘innodb_buffer_pool_instances’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_buffer_pool_instances.*$/innodb_buffer_pool_instances=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 1

          – 20

        dtype : “int”

  –

    name : “innodb_log_buffer_size”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_log_buffer_size’.”

        get : “cat /etc/my.cnf | grep ‘innodb_log_buffer_size’ | awk -F ‘=’ ‘{print $2}’ | awk -F ‘M’ ‘{print $1}'”

        set : “sed -i ‘s/^innodb_log_buffer_size.*$/innodb_log_buffer_size=$valueM/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 8

          – 1024

        dtype : “int”

  –

    name : “innodb_page_cleaners”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_page_cleaners’.”

        get : “cat /etc/my.cnf | grep ‘innodb_page_cleaners’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_page_cleaners.*$/innodb_page_cleaners=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 1

          – 20

        dtype : “int”

  –

    name : “innodb_lru_scan_depth”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_lru_scan_depth’.”

        get : “cat /etc/my.cnf | grep ‘innodb_lru_scan_depth’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_lru_scan_depth.*$/innodb_lru_scan_depth=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 20

          – 2000

        dtype : “int”

  –

    name : “innodb_thread_concurrency”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_thread_concurrency’.”

        get : “cat /etc/my.cnf | grep ‘innodb_thread_concurrency’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_thread_concurrency.*$/innodb_thread_concurrency=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 0

          – 300

        dtype : “int”

  –

    name : “innodb_flush_log_at_trx_commit”

    info :

        desc : “MySQL [mysqld] parameters ‘innodb_flush_log_at_trx_commit’.”

        get : “cat /etc/my.cnf | grep ‘innodb_flush_log_at_trx_commit’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^innodb_flush_log_at_trx_commit.*$/innodb_flush_log_at_trx_commit=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 0

          – 2

        dtype : “int”

  –

    name : “sync_binlog”

    info :

        desc : “MySQL [mysqld] parameters ‘sync_binlog’.”

        get : “cat /etc/my.cnf | grep ‘sync_binlog’ | awk -F ‘=’ ‘{print $2}'”

        set : “sed -i ‘s/^sync_binlog.*$/sync_binlog=$value/g’ /etc/my.cnf”

        needrestart : “true”

        type : “continuous”

        scope :

          – 0

          – 2

        dtype : “int”