Sysbench 1.0
Sysbench allows you to select a test model appropriate to your service requirements. Table 1 lists the test models and scenarios supported by Sysbench 1.0.
Test Model |
Test Scenario |
Use Case |
|---|---|---|
oltp_delete |
OLTP write: index column deletion |
DELETE FROM sbtest%u WHERE id=? |
oltp_insert |
OLTP write: data insertion |
INSERT INTO sbtest%u (id, k, c, pad) VALUES (?, ?, ?, ?) |
oltp_point_select |
OLTP read: point query |
SELECT c FROM sbtest%u WHERE id=? |
oltp_read_only |
OLTP read scenarios:
|
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 read scenarios:
|
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 write scenarios:
|
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 write: index column update |
UPDATE sbtest%u SET k=k+1 WHERE id=? |
oltp_update_non_index |
OLTP write: update of columns without indexes |
UPDATE sbtest%u SET c=? WHERE id=? |
oltp_write_only |
OLTP write scenarios:
|
UPDATE sbtest%u SET k=k+1 WHERE id=? UPDATE sbtest%u SET c=? WHERE id=? DELETE FROM sbtest%u WHERE id=? |