Sysbench 0.5

OLTP DISTINCT

OLTP读场景：去重查询。

SELECT DISTINCT c FROM table_name WHERE id BETWEEN range_start AND range_start + (oltp_range_size - 1) ORDER BY c

OLTP INDEX

OLTP写场景：索引列更新。

UPDATE table_name SET k=k+1 WHERE id = sb_rand(1, oltp_table_size)

OLTP NONINDEX

OLTP写场景：无索引列更新。

UPDATE table_name SET c='c_val' WHERE id=sb_rand(1, oltp_table_size)

OLTP ORDER

OLTP读场景：排序查询。

SELECT c FROM table_name WHERE id BETWEEN range_start AND range_start+(oltp_range_size - 1) ORDER BY c

OLTP POINT

OLTP读场景：选点查询。

SELECT c FROM table_name WHERE id=sb_rand(1, oltp_table_size)

OLTP SIMPLE

OLTP读场景：范围查询。

SELECT c FROM table_name WHERE id BETWEEN range_start AND range_start+(oltp_range_size - 1)

OLTP SUM

OLTP读场景：求和查询。

SELECT SUM(K) FROM table_name HERE id BETWEEN range_start AND range_start + (oltp_range_size - 1)

OLTP DELETE

OLTP写场景：索引列删除、数据插入。

DELETE FROM table_name WHERE id=sb_rand(1, oltp_table_size)I

INSERT INTO table_name (id, k, c, pad) VALUES string.format((%d, %d, '%s', '%s'),i, sb_rand(1, oltp_table_size) , c_val, pad_val)

OLTP MIX

OLTP混合场景：以上八个模型混合，一个事务包含17条SQL，默认POINT场景占10条SQL，其他七个场景各占1条SQL。

以上场景混合。