关于linux下super-smack对Mysql 5.0 的性能测试

最近做linux下mysql5.0的性能测试，用了一下super-smack工具
网上的资料很多，关于select-sky.smack文件的正确修改方案也有很多，但就是没找到关于update-select.smack文件的，而只是有提到用命令
super-smack -d mysql update-select.smack 10 1000

update-select.smack文件跟select-sky.smack很相似，只是多了

query "update_by_username"
{ }

在这里我把正确的select-sky.smack文件附上
[quote]
// this is will be used in the table section
client "admin"
{
user "root";//mysql 用户名
host "localhost";
db "test";//database name
pass "";//password
socket "/var/lib/mysql/mysql.sock"; // this only applies to MySQL and is
// ignored for PostgreSQL
}

// ensure the table exists and meets the conditions
table "http_auth"
{
client "admin"; // connect with this client
// if the table is not found or does not pass the checks, create it
// with the following, dropping the old one if needed
create "create table http_auth
(username char(25) not null primary key,
pass char(25),
uid integer not null,
gid integer not null
)";
min_rows "90000"; // the table must have at least that many rows
data_file "http_auth.dat"; // if the table is empty, load the data from
//this file
gen_data_file "gen-data -n 90000 -f %12-12s%n,%25-25s,%n,%d";
// if the file above does not exist, generate it with the above command
}


//define a dictionary
dictionary "word"
{
type "rand";
source_type "file";
source "words.dat";
delim " "; // 将","号改为"tab"
file_size_equiv "45000"; }

//define a query
query "select_by_username"
{
query "select * from http_auth where username = '$word'";
type "select_index";
has_result_set "y";
parsed "y";

}

query "update_by_username"
{
query "update http_auth set pass='$word' where username = '$word'";
type "update_index";
has_result_set "y";
parsed "y";
}


// define database client type

client "smacker2"
{
user "root"; //这里的设置同上
pass "";
host "localhost";
db "test";
socket "/var/lib/mysql/mysql.sock";
query_barrel "1 select_by_username 1 update_by_username";
// 运行一次select_by_username 和 query update_by_username
//运行次数可根据需要修改
}

main
{

smacker2.init(); //smacker2必须和你上面定义的client type用户名相同
//smacker2.set_num_rounds($2); //原文件多了一行，可能会使你的脚本无法运行，在这里删掉
smacker2.set_num_rounds($2);
smacker2.create_threads($1);
smacker2.connect();
smacker2.unload_query_barrel();
smacker2.disconnect();

}[/quote]