---
title: Sysbench 1.0
description: "Sysbench支持根据实际业务需要选择不同的测试模型进行测试。Sysbench 1.0支持的测试模型及其测试场景如表1所示。"
url: https://www.hikunpeng.com/document/detail/zh/kunpengdbs/testguide/tstg/kunpengsysbench_02_0012.html
sourcePath: /source/zh/kunpengdbs/testguide/tstg/kunpengsysbench_02_0012.html
indexId: eb852355081f586cb67479449bf00af897c0396e41862adfa8fd924ed0b4ca6e65
---
# Sysbench 1.0

Sysbench支持根据实际业务需要选择不同的测试模型进行测试。Sysbench 1.0支持的测试模型及其测试场景如表1所示。


**表1 Sysbench 1.0支持的测试模型及其测试场景说明**

| 测试模型名称 | 测试场景 | 用例 |
| --- | --- | --- |
| oltp\_delete | OLTP写场景：索引列删除 | DELETE FROM sbtest%u WHERE id=? |
| oltp\_insert | OLTP写场景：数据插入 | INSERT INTO sbtest%u (id, k, c, pad) VALUES (?, ?, ?, ?) |
| oltp\_point\_select | OLTP读场景：选点查询 | SELECT c FROM sbtest%u WHERE id=? |
| oltp\_read\_only | OLTP读场景： 选点查询 范围查询 求和查询 排序查询 去重查询 | SELECT c FROM sbtest%u WHERE id=? SELECT c FROM sbtest%u WHERE id BETWEEN ? AND ? SELECT SUM(k) FROM sbtest%u WHERE id BETWEEN ? AND ? SELECT c FROM sbtest%u WHERE id BETWEEN ? AND ? ORDER BY c SELECT DISTINCT c FROM sbtest%u WHERE id BETWEEN ? AND ? ORDER BY c |
| oltp\_read\_write | OLTP读场景： 选点查询 范围查询 求和查询 排序查询 去重查询 | SELECT c FROM sbtest%u WHERE id=? SELECT c FROM sbtest%u WHERE id BETWEEN ? AND ? SELECT SUM(k) FROM sbtest%u WHERE id BETWEEN ? AND ? SELECT c FROM sbtest%u WHERE id BETWEEN ? AND ? ORDER BY c SELECT DISTINCT c FROM sbtest%u WHERE id BETWEEN ? AND ? ORDER BY c |
| oltp\_read\_write | OLTP写场景： 索引列更新 无索引列更新 索引列删除 | UPDATE sbtest%u SET k=k+1 WHERE id=? UPDATE sbtest%u SET c=? WHERE id=? DELETE FROM sbtest%u WHERE id=? |
| oltp\_update\_index | OLTP写场景：索引列更新 | UPDATE sbtest%u SET k=k+1 WHERE id=? |
| oltp\_update\_non\_index | OLTP写场景：无索引列更新 | UPDATE sbtest%u SET c=? WHERE id=? |
| oltp\_write\_only | OLTP写场景： 索引列更新 无索引列更新 索引列删除 | UPDATE sbtest%u SET k=k+1 WHERE id=? UPDATE sbtest%u SET c=? WHERE id=? DELETE FROM sbtest%u WHERE id=? |