表结构

CREATE TABLE btest (

id INTEGER IDENTITY(1,1) NOT　NULL,

k INTEGER DEFAULT '0' NOT NULL,

c CHAR(120) DEFAULT '' NOT NULL,

pad CHAR(60) DEFAULT '' NOT NULL,

PRIMARY KEY ( id)

)

读写比

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})