[PATCH 5/6] sysbench: add monitoring framework integration

From: Daniel Gomez <[email protected]>

Add monitoring support to sysbench workflow following fstests/blktests
pattern:
- Start monitoring before database tests, stop and collect data after
- Use import_tasks for proper variable scoping with modular structure
- Update documentation to include sysbench support

Enables system monitoring during database performance testing. Works
with the new modular monitoring architecture.

Generated-by: Claude AI
Signed-off-by: Daniel Gomez <[email protected]>
---
 docs/monitoring.md                                |  1 +
 playbooks/roles/monitoring/tasks/common/setup.yml |  1 +
 playbooks/roles/sysbench/tasks/main.yaml          | 12 ++++++++++++
 3 files changed, 14 insertions(+)

diff --git a/docs/monitoring.md b/docs/monitoring.md
index 1e05bbd5..9eb10da8 100644
--- a/docs/monitoring.md
+++ b/docs/monitoring.md
@@ -50,6 +50,7 @@ make menuconfig
 
 - **fstests**: Filesystem testing framework
 - **blktests**: Block layer testing framework
+- **sysbench**: Database performance testing framework
 
 ### How Workflows Integrate Monitoring
 
diff --git a/playbooks/roles/monitoring/tasks/common/setup.yml b/playbooks/roles/monitoring/tasks/common/setup.yml
index 22a43a80..aaea0796 100644
--- a/playbooks/roles/monitoring/tasks/common/setup.yml
+++ b/playbooks/roles/monitoring/tasks/common/setup.yml
@@ -10,6 +10,7 @@
       enable_monitoring: {{ enable_monitoring | default(false) }}
       kdevops_run_fstests: {{ kdevops_run_fstests | default(false) }}
       kdevops_run_blktests: {{ kdevops_run_blktests | default(false) }}
+      kdevops_workflow_enable_sysbench: {{ kdevops_workflow_enable_sysbench | default(false) }}
 
 - name: Set workflow-appropriate monitoring results path
   ansible.builtin.set_fact:
diff --git a/playbooks/roles/sysbench/tasks/main.yaml b/playbooks/roles/sysbench/tasks/main.yaml
index 77c57d6a..4ce75f49 100644
--- a/playbooks/roles/sysbench/tasks/main.yaml
+++ b/playbooks/roles/sysbench/tasks/main.yaml
@@ -30,6 +30,12 @@
     name: create_data_partition
   tags: ["mkfs"]
 
+# Start monitoring services before running tests
+- ansible.builtin.import_tasks: ../../monitoring/tasks/monitor_run.yml
+  when:
+    - enable_monitoring|default(false)|bool
+  tags: ["sysbench", "run_sysbench", "monitoring", "monitor_run"]
+
 - name: MySQL Docker
   ansible.builtin.import_tasks: mysql-docker/main.yaml
   when: sysbench_type_mysql_docker | bool
@@ -37,3 +43,9 @@
 - name: PostgreSQL Native
   ansible.builtin.import_tasks: postgresql-native/main.yaml
   when: sysbench_type_postgresql_native | bool
+
+# Stop monitoring services and collect data after running tests
+- ansible.builtin.import_tasks: ../../monitoring/tasks/monitor_collect.yml
+  when:
+    - enable_monitoring|default(false)|bool
+  tags: ["sysbench", "results", "monitoring", "monitor_collect"]

-- 
2.50.1