mbox series

[0/5] sysbench: add postgresql tps variability

Message ID 20241017-add-postgresql-tps-var-v1-0-4996d45426af@samsung.com (mailing list archive)
Headers show
Series sysbench: add postgresql tps variability | expand

Message

Daniel Gomez via B4 Relay Oct. 17, 2024, 12:42 p.m. UTC 
This patch set adds the PostgreSQL TPS variability benchmark using
sysbench workload.

I decided to split the sysbench workloads in 2: MySQL (docker) and
PostgreSQL (native). Some tasks are copy-pasted from MySQL task list but
I think this allows every workload to be self-contained. Althought it
duplicates code. What do you think?

I'm also using ansible lsp and lint and found quite some interesting
things fixed in the postgres yaml. Are you guys using anything similar?

Note: Plots and telemetry is still work in progress.

To: kdevops@lists.linux.dev
To: mcgrof@kernel.org
Cc: d+samsung@kruces.com

Signed-off-by: Daniel Gomez <da.gomez@samsung.com>
---
Daniel Gomez (5):
      sysbench: fix kconfig tabs
      sysbench: fix typos
      sysbench: fix SYSBENCH_MYSQL_INNODB_REDO_LOG_CAPACITY typo
      sysbench: split mysql-docker benchmark
      sysbench: add postgresql native TPS variablity support

 playbooks/roles/sysbench/defaults/main.yml         |  15 +
 .../sysbench/tasks/install-deps/debian/main.yml    |  47 ++
 playbooks/roles/sysbench/tasks/main.yaml           | 777 +------------------
 .../roles/sysbench/tasks/mysql-docker/main.yaml    | 773 +++++++++++++++++++
 .../sysbench/tasks/postgresql-native/main.yaml     | 708 ++++++++++++++++++
 playbooks/roles/sysbench/templates/mysql.conf.j2   |   2 +-
 .../sysbench/templates/postgresql-conf-000.conf.j2 | 820 +++++++++++++++++++++
 .../templates/postgresql-conf-default.conf.j2      | 820 +++++++++++++++++++++
 workflows/sysbench/Kconfig                         |  51 +-
 workflows/sysbench/Kconfig.docker                  |   8 +-
 workflows/sysbench/Kconfig.fs                      |  36 +-
 workflows/sysbench/Kconfig.native                  | 120 +++
 workflows/sysbench/Kconfig.xfs                     |   4 +-
 13 files changed, 3398 insertions(+), 783 deletions(-)
---
base-commit: 30a309572af702fddae3309933ca0fda92a24246
change-id: 20241017-add-postgresql-tps-var-0ba7c2fd9469

Best regards,