[PATCH lkp-tests] jobs: add multi-device test parameters

Signed-off-by: Zhang Yu <2134782174@qq.com> --- jobs/sysbench-mysql.yaml | 31 ++++++++++++++++++++++++------- 1 file changed, 24 insertions(+), 7 deletions(-) diff --git a/jobs/sysbench-mysql.yaml b/jobs/sysbench-mysql.yaml index c060fc2a..097acad4 100644 --- a/jobs/sysbench-mysql.yaml +++ b/jobs/sysbench-mysql.yaml @@ -1,10 +1,27 @@ suite: sysbench-mysql category: benchmark -sysbench-mysql: - oltp_test_mode: complex - oltp_tables_count: 3 - oltp_table_size: 1000 - nr_threads: 64 - runtime: 120 - report_interval: 10 +cluster: cs-lkp-hsw-ep5 + +if role server: + mysql: + +if role client: + sysbench-mysql: + oltp_test_mode: complex + oltp_tables_count: 1000 + oltp_table_size: 100000 + nr_threads: 256 + runtime: 600 + report_interval: 1 + mysql_host: + mysql_port: + mysql_password: + mysql_user: + mysql_db: sysbench_1 + max_requests: 0 + mysql_table_engine: innodb + rand_type: special + rand_spec_pct: 100 + oltp_read_only: off + events: 2000000000 -- 2.23.0

On Thu, Nov 05, 2020 at 04:51:47PM +0800, Zhang Yu wrote:
Signed-off-by: Zhang Yu <2134782174@qq.com> --- jobs/sysbench-mysql.yaml | 31 ++++++++++++++++++++++++------- 1 file changed, 24 insertions(+), 7 deletions(-)
diff --git a/jobs/sysbench-mysql.yaml b/jobs/sysbench-mysql.yaml index c060fc2a..097acad4 100644 --- a/jobs/sysbench-mysql.yaml +++ b/jobs/sysbench-mysql.yaml @@ -1,10 +1,27 @@ suite: sysbench-mysql category: benchmark
-sysbench-mysql: - oltp_test_mode: complex - oltp_tables_count: 3 - oltp_table_size: 1000 - nr_threads: 64 - runtime: 120 - report_interval: 10 +cluster: cs-lkp-hsw-ep5 + +if role server: + mysql: + +if role client: + sysbench-mysql: + oltp_test_mode: complex + oltp_tables_count: 1000 + oltp_table_size: 100000 + nr_threads: 256 + runtime: 600 + report_interval: 1
It's awkward to define the below in job. The test scripts should have reasonable defaults?
+ mysql_host: + mysql_port: + mysql_password: + mysql_user: + mysql_db: sysbench_1
Some of the below params I cannot find in tests/sysbench-mysql:
+ max_requests: 0 + mysql_table_engine: innodb + rand_type: special + rand_spec_pct: 100 + oltp_read_only: off + events: 2000000000 -- 2.23.0

+ sysbench-mysql: + oltp_test_mode: complex + oltp_tables_count: 1000 + oltp_table_size: 100000 + nr_threads: 256 + runtime: 600 + report_interval: 1
It's awkward to define the below in job. The test scripts should have reasonable defaults?
Should i just give reasonable defaults in test script, instead of define them in job.yaml?
+ mysql_host: + mysql_port: + mysql_password: + mysql_user: + mysql_db: sysbench_1
Some of the below params I cannot find in tests/sysbench-mysql:
I'll add them to tests/sysbench-mysql later. Thanks, Zhangyu
+ max_requests: 0 + mysql_table_engine: innodb + rand_type: special + rand_spec_pct: 100 + oltp_read_only: off + events: 2000000000 -- 2.23.0

On Thu, Nov 05, 2020 at 05:26:23PM +0800, Zhang Yu wrote:
+ sysbench-mysql: + oltp_test_mode: complex + oltp_tables_count: 1000 + oltp_table_size: 100000 + nr_threads: 256 + runtime: 600 + report_interval: 1
It's awkward to define the below in job. The test scripts should have reasonable defaults?
Should i just give reasonable defaults in test script, instead of define them in job.yaml?
Yes.
+ mysql_host: + mysql_port: + mysql_password: + mysql_user: + mysql_db: sysbench_1
Some of the below params I cannot find in tests/sysbench-mysql:
I'll add them to tests/sysbench-mysql later.
OK, better do that before this patch. Thanks, Fengguang
+ max_requests: 0 + mysql_table_engine: innodb + rand_type: special + rand_spec_pct: 100 + oltp_read_only: off + events: 2000000000 -- 2.23.0

+cluster: cs-lkp-hsw-ep5
Did you write a right cluster file in repos? Cluster file will contains hostname and its' mac, should put it in repos? Thanks, RenWen
+ +if role server: + mysql: + +if role client: + sysbench-mysql: + oltp_test_mode: complex + oltp_tables_count: 1000 + oltp_table_size: 100000 + nr_threads: 256 + runtime: 600 + report_interval: 1 + mysql_host: + mysql_port: + mysql_password: + mysql_user: + mysql_db: sysbench_1 + max_requests: 0 + mysql_table_engine: innodb + rand_type: special + rand_spec_pct: 100 + oltp_read_only: off + events: 2000000000 -- 2.23.0
participants (3)
-
Ren Wen
-
Wu Fengguang
-
Zhang Yu