这个定制化太历害了。 另写一个job file会合适些，新job能放到lab-z9 repo吗？ 因为它绑定机器了，明显不是个general job了，不适合放在通用化的lkp-tests里。

Thanks, Fengguang

On Wed, Feb 24, 2021 at 04:46:50PM +0800, Wei Jihui wrote:

1. change cluster to cs-s1-a102-c1
2. add kernel args
3. add mysql args
4. add sysctl for performance optimized
5. add server nic and device, this can be sured by cluster

Signed-off-by: Wei Jihui weijihuiall@163.com

jobs/sysbench-mysql.yaml | 29 +++++++++++++++++++++++++++-- 1 file changed, 27 insertions(+), 2 deletions(-)

diff --git a/jobs/sysbench-mysql.yaml b/jobs/sysbench-mysql.yaml index 83795a18..607acf12 100644 --- a/jobs/sysbench-mysql.yaml +++ b/jobs/sysbench-mysql.yaml @@ -1,10 +1,35 @@ suite: sysbench-mysql category: benchmark

-cluster: cs-lkp-hsw-ep5 +cluster: cs-s1-a102-c1 +kernel_version: 4.19.90-mysql +kernel_custom_params: sched_steal_node_limit=8

+mysql_user: +mysql_host: +mysql_port: +mysql_db: +mysql_password:

if role server:

• sysctl:
• sc_numa_balancing: 0
• sc_sched_autogroup_enabled: 0
• sc_sched_min_granularity_ns: 10000000
• sc_sched_wakeup_granularity_ns: 15000000
• sc_threads-max: 52130
• sc_tcp_max_syn_backlog: 360000
• sc_dirty_ratio: 5
• sc_somaxconn: 1024
• sc_rmem_max: 16777216
• sc_wmem_max: 16777216
• sc_swappiness: 1
• sc_ipv4_tcp_rmem: 4096 87380 16777216
• sc_ipv4_tcp_wmem: 4096 87380 16777216
• sc_sched_features: "NO_WAKEUP_PREEMPTION STEAL" mysql:
• nic: enp189s0f1
• device: nvme0n1

if role client: sysbench-mysql: @@ -17,6 +42,6 @@ if role client: runtime: 600 rand_type: special rand_spec_pct: 100

• oltp_read_only: off

• oltp_read_only: false report_interval: 1 events: 2000000000

-- 2.23.0