From patchwork Wed Oct 23 09:26:13 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Daniel Gomez via B4 Relay X-Patchwork-Id: 13846805 Received: from smtp.kernel.org (aws-us-west-2-korg-mail-1.web.codeaurora.org [10.30.226.201]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by smtp.subspace.kernel.org (Postfix) with ESMTPS id 92CDE19C56B for ; Wed, 23 Oct 2024 09:26:27 +0000 (UTC) Authentication-Results: smtp.subspace.kernel.org; arc=none smtp.client-ip=10.30.226.201 ARC-Seal: i=1; a=rsa-sha256; d=subspace.kernel.org; s=arc-20240116; t=1729675587; cv=none; b=t8jWZYSBuAx3/wpb6Mp+WkRY9zWa23oz2kkxNvUgDw3VphIebxa8sMYP6EnNqM+mSkA2Wg0bYSXFCGezGjQk9CZzOBp+l7smIhKT2akdTIEJEvr2wo96/4jdSSyMRTovnLDZrX023Hpksv0kBA9ud+THVQtXIoI0Xlv9nrRh1uY= ARC-Message-Signature: i=1; a=rsa-sha256; d=subspace.kernel.org; s=arc-20240116; t=1729675587; c=relaxed/simple; bh=FgGlflK+ly9RvAR1AS3jd4m4g5+C8WmPuYjNdn6U7zM=; h=From:Subject:Date:Message-Id:MIME-Version:Content-Type:To:Cc; b=t+rDLGWJPoEBxpTB7EPEEV6dzmRt8keW9RP9SQhGzakefi50G38/3oNkJ03Dl4v5GWIuhegpmmKTa5LIFI+cwQzhYemnJ6GeY6eYAgT/Gp/Vyqeq7mghphkzyLX4Qb6n/X5WC+kmCgFYJK7dGgvO9MPQXFhuHlsr2aahyj8A7As= ARC-Authentication-Results: i=1; smtp.subspace.kernel.org; dkim=pass (2048-bit key) header.d=kernel.org header.i=@kernel.org header.b=bejGp6Rq; arc=none smtp.client-ip=10.30.226.201 Authentication-Results: smtp.subspace.kernel.org; dkim=pass (2048-bit key) header.d=kernel.org header.i=@kernel.org header.b="bejGp6Rq" Received: by smtp.kernel.org (Postfix) with ESMTPS id 0CF94C4CEC6; Wed, 23 Oct 2024 09:26:27 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kernel.org; s=k20201202; t=1729675587; bh=FgGlflK+ly9RvAR1AS3jd4m4g5+C8WmPuYjNdn6U7zM=; h=From:Subject:Date:To:Cc:Reply-To:From; b=bejGp6RqvbWNdH4mZRJZwpAHoS/Ez+ie2O5xW1w1rNfXZQYMhVm+xDca/Xu2mdl0D 9eBI4T2LucdiPXc/vcntNse1CFJXpRTZtwfqxSx+b3JPOhnos/FN3oypDjNzOfGy/e VsuAGFmvdsGBY/sotE5jc9ceLh8Arb3xAkl5AUauTknH2TdvOVCAZ+kcN9XPPdkl6s FXWfiuC24rs9wd6Z1iB/e5K+MvONg4uuzZ+rAbhFxjCmVIXfRUmz/+KgeT3GTV//eJ nnt7ahbBarn54wmhp4ILAGhFTaA22yTt/S9aZREobBrpf6yDIIfi8RxS5OBXigVAOP 6IunDC+3Xownw== Received: from aws-us-west-2-korg-lkml-1.web.codeaurora.org (localhost.localdomain [127.0.0.1]) by smtp.lore.kernel.org (Postfix) with ESMTP id ED06FD2E02E; Wed, 23 Oct 2024 09:26:26 +0000 (UTC) From: Daniel Gomez via B4 Relay Subject: [PATCH v2 0/2] sysbench: add postgresql tps variability Date: Wed, 23 Oct 2024 11:26:13 +0200 Message-Id: <20241023-add-postgresql-tps-var-v2-0-ff2f3c6e1632@samsung.com> Precedence: bulk X-Mailing-List: kdevops@lists.linux.dev List-Id: List-Subscribe: List-Unsubscribe: MIME-Version: 1.0 X-B4-Tracking: v=1; b=H4sIADXBGGcC/4WNQQ7CIBBFr9LM2jFAkAZX3sN0gYVSEltaphJNw 93FXsDle8l/fwdyKTiCa7NDcjlQiHMFcWqgH83sHQZbGQQTkjPeorEWl0ibT47WJ24LYTYJ2cO 0vRislkpDHS/JDeF9hO9d5THQFtPn+Mn8Z/8mM0eGUmtl5UUKZYYbmYlesz/3cYKulPIFmgT5Y 74AAAA= To: kdevops@lists.linux.dev, mcgrof@kernel.org Cc: d+samsung@kruces.com, Daniel Gomez X-Mailer: b4 0.14.1 X-Developer-Signature: v=1; a=ed25519-sha256; t=1729675585; l=2457; i=da.gomez@samsung.com; s=20240621; h=from:subject:message-id; bh=FgGlflK+ly9RvAR1AS3jd4m4g5+C8WmPuYjNdn6U7zM=; b=dO/fsqeaWhZ/pWhFfjnsOfHOiPh2yHm6EuRClLAnoLUEUWyea2FN6uqcqNJj3pc3WwZ4exHi1 DtX1gqax5rdBam2IvAjO1gznbfXUJ/H5Gw5ljzK7xbotHXh5orXer3G X-Developer-Key: i=da.gomez@samsung.com; a=ed25519; pk=BqYk31UHkmv0WZShES6pIZcdmPPGay5LbzifAdZ2Ia4= X-Endpoint-Received: by B4 Relay for da.gomez@samsung.com/20240621 with auth_id=175 X-Original-From: Daniel Gomez Reply-To: da.gomez@samsung.com This patch set adds the PostgreSQL TPS variability benchmark using sysbench workload. Split sysbench workloads into two separate Ansible task YAML files, one for MySQL (docker) and one for PostgreSQL (native), to create self-contained workload files, enabling independent control of task workflows. To: kdevops@lists.linux.dev To: mcgrof@kernel.org Cc: d+samsung@kruces.com Signed-off-by: Daniel Gomez Acked-by: Luis Chamberlain --- Changes in v2: * Make sysbench PostgreSQL workload idempotence (sysbench vs sysbench-test). * Add/fix plots target (sysbench-plot). * Move 'tags' keyword to the top of the task for better control flow review. * Add results/-ab/ directory to place 'a vs b' plots. * Add 2 different configuration templates for PostgreSQL. Default with full_page_writes on/off based on kconfig (+ port). Extra with custom options + full_page_writes on/off based on kconfig (+ port). * Sysbench workflow test with 14 profiles (xfs and ext4). * Move command to shell when plotting to fix space/arg issue. * Merged patches: sysbench: fix kconfig tabs -- patch contents already upstream sysbench: fix typos -- patch contents already upstream sysbench: fix SYSBENCH_MYSQL_INNODB_REDO_LOG_CAPACITY typo * Add code-review trailers. - Link to v1: https://lore.kernel.org/r/20241017-add-postgresql-tps-var-v1-0-4996d45426af@samsung.com --- Daniel Gomez (2): 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 | 64 +- playbooks/roles/sysbench/tasks/main.yaml | 777 +------------------ .../roles/sysbench/tasks/mysql-docker/main.yaml | 773 +++++++++++++++++++ .../sysbench/tasks/postgresql-native/main.yaml | 735 ++++++++++++++++++ .../sysbench/templates/postgresql-conf-000.conf.j2 | 820 +++++++++++++++++++++ .../templates/postgresql-conf-default.conf.j2 | 820 +++++++++++++++++++++ workflows/sysbench/Kconfig | 47 ++ workflows/sysbench/Kconfig.fs | 30 + workflows/sysbench/Kconfig.native | 138 ++++ 10 files changed, 3446 insertions(+), 773 deletions(-) --- base-commit: 38746a0f1bced2e58d5c5d36618e111d348a7ae3 change-id: 20241017-add-postgresql-tps-var-0ba7c2fd9469 Best regards,