The Complete Production SOP: How to Deploy and Run Sysbench OLTP Database Benchmarking & Stress Testing in Autonomous AI Agents

---
name: "mysql-sysbench-oltp-benchmark"
description: "Simulate heavy transactional read/write workloads to benchmark database hardware and configurations."
metadata:
  author: "akopytov"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "benchmark mysql with sysbench"
  - "run sysbench oltp_read_write"
  - "measure mysql tps and latency"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: true
  net_access: true
---

# Sysbench OLTP Database Benchmarking & Stress Testing

Execute standardized OLTP stress tests against MySQL to determine concurrency limits and 95th/99th percentile response latencies.

#!/usr/bin/env bash
set -euo pipefail

if [ ! -f .env.sysbench ]; then
  echo "Error: .env.sysbench missing!" >&2
  exit 1
fi

source .env.sysbench

which sysbench > /dev/null 2>&1 || { echo "Sysbench binary not found in PATH"; exit 1; }

echo "Validating database connectivity..."
mysqladmin ping -h"$MYSQL_HOST" -P"$MYSQL_PORT" -u"$MYSQL_USER" -p"$MYSQL_PASSWORD" --silent || {
  echo "Cannot connect to target MySQL instance"; exit 1;
}

source .env.sysbench

# Phase 1: Prepare 10 tables with 100k rows each
sysbench oltp_read_write \
  --mysql-host="$MYSQL_HOST" --mysql-port="$MYSQL_PORT" \
  --mysql-user="$MYSQL_USER" --mysql-password="$MYSQL_PASSWORD" \
  --mysql-db="$MYSQL_DB" \
  --tables=10 --table-size=100000 \
  prepare

# Phase 2: Run benchmark with 16 concurrent threads
sysbench oltp_read_write \
  --mysql-host="$MYSQL_HOST" --mysql-port="$MYSQL_PORT" \
  --mysql-user="$MYSQL_USER" --mysql-password="$MYSQL_PASSWORD" \
  --mysql-db="$MYSQL_DB" \
  --tables=10 --table-size=100000 \
  --threads=16 --time=60 --report-interval=10 \
  run | tee sysbench_results.log

# Phase 3: Cleanup
sysbench oltp_read_write \
  --mysql-host="$MYSQL_HOST" --mysql-port="$MYSQL_PORT" \
  --mysql-user="$MYSQL_USER" --mysql-password="$MYSQL_PASSWORD" \
  --mysql-db="$MYSQL_DB" \
  --tables=10 \
  cleanup

const fs = require('fs');
const log = fs.readFileSync('sysbench_results.log', 'utf8');

const tpsMatch = log.match(/transactions:\s+\d+\s+\(([\d\.]+)\s+per\s+sec\.\)/);
const p95Match = log.match(/95th\s+percentile:\s+([\d\.]+)/);

if (!tpsMatch || !p95Match) {
  console.error('Failed to parse Sysbench metrics output');
  process.exit(1);
}

const tps = parseFloat(tpsMatch[1]);
const p95Latency = parseFloat(p95Match[1]);

console.log(`Measured TPS: ${tps}, 95th Percentile: ${p95Latency}ms`);

// SLA Verification: Fail if p95 latency is higher than 50ms
if (p95Latency > 50.0) {
  console.error(`Performance SLA Violation: p95 latency ${p95Latency}ms exceeds 50ms`);
  process.exit(1);
}

console.log('Benchmark verification passed successfully.');