# Copyright (c) 2020 Huawei Technologies Co., Ltd.
# A-Tune is licensed under the Mulan PSL v2.
# You can use this software according to the terms and conditions of the Mulan PSL v2.
# You may obtain a copy of Mulan PSL v2 at:
#     http://license.coscl.org.cn/MulanPSL2
# THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR
# IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, MERCHANTABILITY OR FIT FOR A PARTICULAR
# PURPOSE.
# See the Mulan PSL v2 for more details.
# Create: 2020-07-23
#
# postgresql 2p sysbench A-Tune configuration
#
[main]
include = default-default

[kernel_config]
#TODO CONFIG

[bios]
#TODO CONFIG

[bootloader.grub2]
iommu.passthrough = 1

[sysfs]
#TODO CONFIG

[systemctl]
sysmonitor = stop
irqbalance = stop

[sysctl]
# schedule
kernel.sched_cfs_bandwidth_slice_us = 21000
kernel.sched_migration_cost_ns = 1381000
kernel.sched_latency_ns = 16110000
kernel.sched_min_granularity_ns = 8250000
kernel.sched_nr_migrate = 53
kernel.sched_wakeup_granularity_ns = 50410000

# network core
net.core.rmem_default = 21299200
net.core.rmem_max = 21299200
net.core.wmem_default = 21299200
net.core.wmem_max = 21299200
net.ipv4.tcp_rmem = 40960 8738000 62914560
net.ipv4.tcp_wmem = 40960 8738000 62914560
net.core.dev_weight = 97

# support more connections for mysql
net.ipv4.tcp_max_syn_backlog = 20480
net.core.somaxconn = 1280

[script]
prefetch = off

[ulimit]
{user}.hard.nofile = 102400
{user}.soft.nofile = 102400

[schedule_policy]
#TODO CONFIG

[check]
#TODO CONFIG

[tip]
use xfs and enable noatime or nodirname to prevent the inode access records from being updated = filesystem