• 表结构
CREATE TABLE `sbtest32` ( `id` int(11) NOT NULL AUTO_INCREMENT, `k` int(11) NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `k_32` (`k`) ) ENGINE=InnoDB AUTO_INCREMENT=25001 DEFAULT CHARSET=utf8mb4
• OLTP读写比
Sysbench默认提交的事务中包含18条SQL语句，具体执行语句和条数如下：
表2 OLTP读写比例表
SQL类型 | 比例 | SQL语句 |
point_selects | 10 | SELECT c FROM sbtest32 WHERE id=? |
simple_ranges | 1 | SELECT c FROM sbtest32 WHERE id BETWEEN ? AND ? |
sum_ranges | 1 | SELECT SUM(k) FROM sbtest32 WHERE id BETWEEN ? AND ? |
order_ranges | 1 | SELECT c FROM sbtest32 WHERE id BETWEEN ? AND ? ORDER BY c |
distinct_ranges | 1 | SELECT DISTINCT c FROM sbtest32 WHERE id BETWEEN ? AND ? ORDER BY c |
index_updates | 1 | UPDATE sbtest32 SET k=k+1 WHERE id=? |
non_index_updates | 1 | UPDATE sbtest32 SET c=? WHERE id=? |
deletes | 1 | DELETE FROM sbtest32 WHERE id=? |
inserts_ignore | 1 | INSERT IGNORE INTO sbtest32 (id, k, c, pad) VALUES (?, ?, ?, ?) |