CREATE TABLE `sbtest` ( `id` int(10) unsigned NOT NULL auto_increment, `k` int(10) unsigned NOT NULL default '0', `c` char(120) NOT NULL default '', `pad` char(60) NOT NULL default '', PRIMARY KEY (`id`), KEY `k` (`k`)); 在run階段
simple模式 SELECT c FROM sbtest WHERE id=N Point queries SELECT c FROM sbtest WHERE id=N Range queries: SELECT c FROM sbtest WHERE id BETWEEN N AND M Range SUM() queries SELECT SUM(K) FROM sbtest WHERE id BETWEEN N and M Range ORDER BY queries SELECT c FROM sbtest WHERE id between N and M ORDER BY c Range DISTINCT queries SELECT DISTINCT c FROM sbtest WHERE id BETWEEN N and M ORDER BY c UPDATEs on index column UPDATE sbtest SET k=k+1 WHERE id=N UPDATEs on non-index column: UPDATE sbtest SET c=N WHERE id=M DELETE queries DELETE FROM sbtest WHERE id=N INSERT queries INSERT INTO sbtest VALUES (...) oltp test 模式通用參數 選項 描述 默認值 --oltp-table-name 表的名字 sbtest --oltp-table-size 表的行數 10000 --oltp-tables-count 表的個數 1 --oltp-dist-type 熱點數據分布{uniform(均勻分布),Gaussian(高斯分布),special(空間分布)}。默認是special special --oltp-dist-pct special：熱點數據產生的比例 1 --oltp-dist-res special：熱點數據的訪問頻率 75 --oltp-test-mode simple，complex（以上介紹） complex --oltp-read-only 只有select 請求 off --oltp-skip-trx 不用事務 off --oltp-point-selects 一個事務中簡單select查詢數量 10 --oltp-simple-ranges 一個事務中簡單range查詢的數量 1 --oltp-sum-ranges sum range的數量 1 --oltp-order=ranges order range的數量 1 mysql test 參數 --mysql-host=[LIST,...] MySQL server host [localhost] --mysql-port=[LIST,...] MySQL server port [3306] --mysql-socket=[LIST,...] MySQL socket --mysql-user=STRING MySQL user [sbtest] --mysql-password=STRING MySQL password [] --mysql-db=STRING MySQL database name [sbtest] --mysql-table-engine=STRING storage engine to use for the test table {myisam,innodb,bdb,heap,ndbcluster,federated} [innodb] --mysql-engine-trx=STRING whether storage engine used is transactional or not {yes,no,auto} [auto] --mysql-ssl=[on|off] use SSL connections, if available in the client library [off] --mysql-ssl-cipher=STRING use specific cipher for SSL connections [] --mysql-compression=[on|off] use compression, if available in the client library [off] --myisam-max-rows=N max-rows parameter for MyISAM tables [1000000] --mysql-debug=[on|off] dump all client library calls [off] --mysql-ignore-errors=[LIST,...]list of errors to ignore, or "all" [1213,1020,1205] --mysql-dry-run=[on|off] Dry run, pretent that all MySQL client API calls are successful without executing them [off] 以上0.4版本的語法介紹完畢。
