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
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
-
Ren Wen -
Wu Fengguang -
Zhang Yu