使用下來感覺super-smack在我的rhel5u1 server i386+ mysql 5.1.22上運行會有很多錯誤，我不得不手工修改配置文件select-key.smack，不停的修改，不停的測試，終于成功運行。
修改后的select-key.smack，這個文件默認測試MyISAM引擎的性能：
[Copy to clipboard] [ - ]CODE: // this is will be used in the table section 這一段做了修改，主要是連mysql server：
client "admin"
{
user "smack";
host "192.168.20.7";
db "smack";
pass "smack";
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
// 原本data_file的值是words.dat，后來改成smack庫里與http_auth同名的http_auth.dat文件，程序才能正常運行。（詳細說明在文檔尾部）
gen_data_file "gen-data -n 90000 -f %12-12s%n,%25-25s,%n,%d";
// gen-data命令后面的字段是以逗號分隔，但是mysqlimport不支持以逗號分隔的文件，必須以Tab分隔，所以生成這個文件以后把所有逗號替換成TAB。（注：直接在上面的命令中把逗號替換成TAB是無效的）。
// if the file above does not exist, generate it with the above shell command
// you can replace this command with anything that prints comma-delimited
// data to stdout, just make sure you have the right number of columns
}
//define a dictionary
dictionary "word"
{
type "rand"; // words are retrieved in random order
source_type "file"; // words come from a file
source "http_auth.dat"; // file location 這里的文件名也相應做改動
delim " "; // take the part of the line before , //把逗號改為一個TAB
file_size_equiv "45000"; // if the file is greater than this
//divive the real file size by this value obtaining N and take every Nth
//line skipping others. This is needed to be able to target a wide key
// range without using up too much memory with test keys
}
//define a query
query "select_by_username"
{
query "select * from http_auth where username = '$word'";
// $word will be substitute with the read from the 'word' dictionary
type "select_index";
// query stats will be grouped by type
has_result_set "y";
// the query is expected to return a result set
parsed "y";
// the query string should be first processed by super-smack to do
// dictionary substitution
}
// define database client type 不知道這一段是做什么的，把mysql server的連接信息填進去
client "smacker1"
{
user "smack"; // connect as this user
pass "smack"; // use this password
host "192.168.20.7"; // connect to this host
db "smack"; // switch to this database
socket "/var/lib/mysql/mysql.sock"; // this only applies to MySQL and is
// ignored for PostgreSQL
query_barrel "2 select_by_username"; // on each round,
// run select_by_username query 2 times
}
main
{
smacker1.init(); // initialize the client
smacker1.set_num_rounds($2); // second arg on the command line defines
// the number of rounds for each client
smacker1.create_threads($1);
// first argument on the command line defines how many client instances
// to fork. Anything after this will be done once for each client until
// you collect the threads
smacker1.connect();
// you must connect after you fork
smacker1.unload_query_barrel(); // for each client fire the query barrel
// it will now do the number of rounds specified by set_num_rounds()
// on each round, query_barrel of the client is executed
smacker1.collect_threads();
// the master thread waits for the children, each child reports the stats
// the stats are printed
smacker1.disconnect();
// the children now disconnect and exit
}
執行測試命令：
super-smack -d mysql select-key.smack 10 1000
系統輸出：
[Copy to clipboard] [ - ]CODE: super-smack -d mysql select-key.smack 10 1000
Table 'http_auth' does not meet condtions, will be dropped
Creating table 'http_auth'
Loading data from file '/var/smack-data/http_auth.dat' into table 'http_auth'
Error running query load data infile '/var/smack-data/http_auth.dat' into table http_auth fields terminated by ',':Can't get stat of '/var/smack-data/http_auth.dat' (Errcode: 2)
super-smack: aborting on failed query
http_auth.dat文件為空，數據沒有導入成功，手工導入數據：
gen-data -n 90000 -f %12-12s%n,%25-25s,%n,%d > /var/smack-data/http_auth.dat
把開文本編輯器，把這個文件中的所有逗號替換為TAB，在vi里使用命令：
:%s/,/\t/g
再次運行測試命令，雖然我已經把配置文件中的delim變量的值改為TAB，但是下面的出錯信息中仍然說字段分隔符是','，并且http_auth表沒有數據：
[Copy to clipboard] [ - ]CODE: Table 'http_auth' does not meet condtions, will be dropped
Creating table 'http_auth'
Loading data from file '/var/smack-data/http_auth.dat' into table 'http_auth'
Error running query load data infile '/var/smack-data/http_auth.dat' into table http_auth fields terminated by ',':Can't get stat of '/var/smack-data/http_auth.dat' (Errcode: 2)
super-smack: aborting on failed query
[code]
通過手工導入：
mysqlimport -L -usmack -psmack -h192.168.20.7 smack /var/smack-data/http_auth.dat
系統輸出說明數據已經導入：
smack.http_auth: Records: 90000 Deleted: 0 Skipped: 0 Warnings: 0
再次運行select測試命令：
super-smack -d mysql select-key.smack 10 1000
系統輸出：
[code]
Query Barrel Report for client smacker1
connect: max=112ms min=14ms avg= 59ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 20000 5 0 1967.19
運行update測試命令：
super-smack -d mysql update-select.smack 10 1000
系統輸出：
[Copy to clipboard] [ - ]CODE: Query Barrel Report for client smacker
connect: max=137ms min=17ms avg= 76ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 10000 6 1 932.57
update_index 10000 7 0 932.57
注：多次測試后發現每次輸出的值都會不一樣。
在mysql 集群上測試select的性能：
在配置文件中的建表語句中加入“engine ndb“，然后運行select測試語句，系統輸出：
[Copy to clipboard] [ - ]CODE: Query Barrel Report for client smacker1
connect: max=600ms min=20ms avg= 262ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 20000 12 2 650.54
運行update測試語句，系統輸出：
[Copy to clipboard] [ - ]CODE: Query Barrel Report for client smacker
connect: max=117ms min=15ms avg= 75ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 10000 17 3 291.17
update_index 10000 42 3 291.17
====================================================================================================
1. 關于data_file變量的設置：
經過研究發現super-smack先生成一個文件文件，文件名是由data_file變量指定，再把這個文件內容導入smack庫的http_auth表，這個變量原來的值是words.dat，我試著手工導入文件：
mysqlimport -L -usmack -psmack -h192.168.20.7 smack /var/smack-data/words.dat
然后系統會提示找不到smack.words表，也就是smack庫下的words表。mysqlimport導入文件的時候把文件擴展名去掉，把文件名剩下的部分做為表名導入數據，實際上smack庫里沒有words這個表，所以我把這個變量的值改為http_auth.dat，然后再試著手工導入就一切 ok了：
mysqlimport -L -usmack -psmack -h192.168.20.7 smack /var/smack-data/http_auth.dat
2. 關于http_auth.dat文件：
mysqlimport導入的文件，字段間必須以tab分隔，逗號或空格都不可以。
延伸閱讀
文章來源于領測軟件測試網 http://www.kjueaiud.com/
