1、表結構
CREATE TABLE sbtest (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
k INTEGER UNSIGNED DEFAULT '0' NOT NULL,
c CHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB
2、讀寫比
Sysbench默認提交的事務中包含18條SQL語句，具體執行語句和條數如下：
主鍵SELECT語句，10條：
SELECT c FROM ?{rand_table_name} where id={rand_id};
范圍SELECT語句，4條：
SELECT c FROM ?{rand_table_name} WHERE id BETWEEN {rand_id_start} AND ${rand_id_end};
SELECT SUM(K) FROM ?{rand_table_name} WHERE id BETWEEN {rand_id_start} AND ${rand_id_end};
SELECT c FROM ?{rand_table_name} WHERE id BETWEEN {rand_id_start} AND ${rand_id_end} ORDER BY c;
SELECT DISTINCT c FROM ?{rand_table_name} WHERE id BETWEEN {rand_id_start} AND ${rand_id_end} ORDER BY c;
UPDATE語句，2條：
UPDATE ?{rand_table_name} SET k=k+1 WHERE id={rand_id}
UPDATE ?{rand_table_name} SET c={rand_str} WHERE id=${rand_id}
DELETE語句，1條：
DELETE FROM ?{rand_table_name} WHERE id={rand_id}
INSERT語句，1條：
INSERT INTO ?{rand_table_name} (id, k, c, pad) VALUES ({rand_id},?{rand_k},{rand_str_c},${rand_str_pad})
