Sysbench 1.0
Sysbench支持根据实际业务需要选择不同的测试模型进行测试。Sysbench 1.0支持的测试模型及其测试场景如表1所示。
测试模型名称 |
测试场景 |
用例 |
|---|---|---|
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写场景：
|
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=? |