agentsclimarketplace
Sign in

Testing and benchmark

Skill oceanbase/oceanbase-skills/skills/oceanbase-deploy/testing-and-benchmark

Run OceanBase performance benchmarks and functional tests using obd test. Supports Sysbench, TPC-H, TPC-C benchmarks and mysqltest functional tests. Use when users want to benchmark, stress test, run functional tests, or evaluate OceanBase cluster performance. Also use when users mention sysbench, TPC-H, TPC-C, mysqltest, or obd test.From its SKILL.md

Install
npx -y skills add oceanbase/oceanbase-skills --skill testing-and-benchmark

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 7 stars7 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

3.1 KB, as published. Nobody here has run it

OceanBase Testing & Benchmark (obd test)

Run performance benchmarks (Sysbench, TPC-H, TPC-C) and functional tests (mysqltest) on OceanBase clusters using obd test.

When to Use This Skill

  • Running performance benchmarks: Sysbench, TPC-H, TPC-C
  • Running functional tests: mysqltest
  • Evaluating cluster performance under load

For cluster deployment and management: Use cluster-management. For tenant creation (needed before testing): Use tenant-management.

Important Rules

  1. Do NOT install test tools via yum. OBD auto-downloads ob-sysbench, obtpch, and obtpcc when online.
  2. Non-interactive mode: Set auto-confirm before scripted runs: 
    obd env set IO_DEFAULT_CONFIRM 1
  3. Full test suite: Do not abort on first failure. Run all test cases to completion, then produce a single report summarizing pass/fail/skip.

Test Commands

MySQL Test (Functional)

obd test mysqltest <deploy_name> --test-set <test_set>

Sysbench (Benchmark)

obd test sysbench <deploy_name> --tenant=<tenant> --script-name=<script>

TPC-H (Benchmark)

obd test tpch <deploy_name> --tenant=<tenant> --remote-tbl-dir=<server_dir>

--remote-tbl-dir is required — specifies where TPC-H table files are stored on the server.

TPC-C (Benchmark)

obd test tpcc <deploy_name> --tenant=<tenant> --warehouses=<n> --run-mins=<minutes>

Use --run-mins (not --running-minutes) to cap duration. Java may need to be installed separately.

See references/test-commands.md for detailed parameters and examples.

Usage Examples

Sysbench Quick Test

obd test sysbench test-cluster --tenant=mysql --script-name=oltp_read_write.lua

TPC-H Benchmark

obd test tpch test-cluster --tenant=mysql --remote-tbl-dir=/tmp/tpch

TPC-C Benchmark

obd test tpcc test-cluster --tenant=mysql --warehouses=10 --run-mins=5

Skill Functional Test

To run a full skill validation covering cluster/tenant/backup and all test types:

Run all OBD functional tests covered by this skill and output a test report.

When testing OCP-related functionality, default to ocp-ce. If a test mentions ocp-express, note that it has been replaced by obshell dashboard.

Related Skills

Keep looking

Skills are one crate of 627,801. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.