表結構

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默(mo)認提交的事務中包含18條(tiao)SQL語句，具體執行語句和條(tiao)數如下：

主鍵SELECT語(yu)句，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條(tiao)：

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條(tiao)：

INSERT INTO  {rand_table_name} (id, k, c, pad) VALUES (** {rand_id},** {rand_k},**{rand_str_c},${rand_str_pad})