sysbench 命令

常用示例

说明

sysbench is a multi-threaded benchmarking tool for evaluating system performance across CPU, memory, file I/O, and database workloads. It provides consistent, reproducible measurements that allow meaningful comparisons between different hardware configurations, kernel versions, or tuning parameters. The tool includes built-in test types for common benchmarks. CPU tests stress processors using prime number calculations to measure computational throughput. Memory tests measure bandwidth and latency across sequential and random access patterns. File I/O tests support multiple modes including sequential writes, sequential reads, and random read/write mixes, requiring a preparation step to create test files before running and a cleanup step afterward. Database benchmarks simulate OLTP (Online Transaction Processing) workloads against MySQL or PostgreSQL, executing realistic mixes of select, insert, update, and delete queries. All test types support multi-threaded execution to measure how performance scales with parallelism, revealing bottlenecks and contention points. Custom Lua scripts can define additional workloads beyond the built-in tests.

参数

cpu

CPU test.

memory

Memory test.

fileio

File I/O test.

oltp_read_write

Database OLTP test.

oltp_read_only

Read-only database test.

threads

Thread scheduler performance test.

mutex

Mutex contention performance test.

--threads _N_

Number of threads (default: 1).

--time _SECONDS_

Test duration (default: 10).

--events _N_

Maximum number of events (default: 0, unlimited).

--file-total-size _SIZE_

Total file size.

--file-test-mode _MODE_

I/O mode (seqwr, seqrd, rndrw, etc.).

--mysql-host _HOST_

MySQL host.

--mysql-user _USER_

MySQL user.

--mysql-password _PASS_

MySQL password.

--mysql-db _DB_

MySQL database name.

--cpu-max-prime _N_

Upper limit for prime number calculation in CPU test (default: 10000).

--memory-block-size _SIZE_

Size of memory block for memory test (default: 1K).

--memory-total-size _SIZE_

Total size of data to transfer in memory test (default: 100G).

--memory-oper _OP_

Memory operation type: read or write (default: write).

--memory-access-mode _MODE_

Memory access mode: seq or rnd (default: seq).

--file-num _N_

Number of files to create (default: 128).

--file-extra-flags _FLAGS_

Additional flags for opening files: sync, dsync, direct.

--percentile _N_

Percentile to calculate in latency statistics (default: 95).