點擊下載
本文文檔

當前位置：首頁 - 科技 - 知識百科 - 正文

mysql高性能壓力測試

來源：懂視網責編：小采時間：2020-11-09 13:02:55

mysql高性能壓力測試

mysql高性能壓力測試:這里我說下測試方法和測試過程以及測試中出錯的問題估計很多人跟我一樣要測試mysql 的性能壓力，網上找了很多資料有很多，但是很亂，所以這里我做個總結，拿自己的真實服務器測試的。并且想測多少數據都能模擬出來！這里只介紹方法。 MySQL從5.

推薦度：

點擊下載本文 文檔為doc格式

導讀mysql高性能壓力測試:這里我說下測試方法和測試過程以及測試中出錯的問題估計很多人跟我一樣要測試mysql 的性能壓力，網上找了很多資料有很多，但是很亂，所以這里我做個總結，拿自己的真實服務器測試的。并且想測多少數據都能模擬出來！這里只介紹方法。 MySQL從5.

這里我說下測試方法和測試過程以及測試中出錯的問題估計很多人跟我一樣要測試mysql 的性能壓力，網上找了很多資料有很多，但是很亂，所以這里我做個總結，拿自己的真實服務器測試的。并且想測多少數據都能模擬出來！這里只介紹方法。 MySQL從5.1.4版

這里我說下測試方法和測試過程以及測試中出錯的問題

估計很多人跟我一樣要測試mysql 的性能壓力，網上找了很多資料有很多，但是很亂，所以這里我做個總結，拿自己的真實服務器測試的。并且想測多少數據都能模擬出來！這里只介紹方法。

MySQL從5.1.4版開始帶有一個壓力測試工具mysqlslap，通過模擬多個并發客戶端訪問
mysql來執行測試。

1 2	`[root@localhost smacks]# mysql -V` `mysql? Ver` `14.14` `Distrib` `5.1.69,` `for` `redhat-linux-gnu (x86_64) using readline` `5.1`

1	`mysqlslap --delimiter=";"` `--create="CREATE TABLE a (b int);INSERT INTO a VALUES (23)"` `--query="SELECT * FROM a"` `--concurrency=50 --iterations=200 -uadmin -p123456`

–auto-generate-sql, -a

自動生成測試表和數據

–auto-generate-sql-load-type=type

測試語句的類型。取值包括：read，key，write，update和mixed(默認)。

–number-char-cols=N, -x N

自動生成的測試表中包含多少個字符類型的列，默認1

–number-int-cols=N, -y N

自動生成的測試表中包含多少個數字類型的列，默認1

–number-of-queries=N

總的測試查詢次數(并發客戶數×每客戶查詢次數)

–query=name,-q

使用自定義腳本執行測試，例如可以調用自定義的一個存儲過程或者sql語句來執行測試。

–create-schema

測試的schema，MySQL中schema也就是database

–commint=N

多少條DML后提交一次

–compress, -C

如果服務器和客戶端支持都壓縮，則壓縮信息傳遞

–concurrency=N, -c N

并發量，也就是模擬多少個客戶端同時執行select?？芍付ǘ鄠€值，以逗號或者–delimiter參數指定的值做為分隔符

–engine=engine_name, -e engine_name

創建測試表所使用的存儲引擎，可指定多個

–iterations=N, -i N

測試執行的迭代次數

–detach=N

執行N條語句后斷開重連

–debug-info, -T

打印內存和CPU的信息

–only-print

只打印測試語句而不實際執行

自動生成一條測試用的語句，不用你寫sql進行測試
比如這句的結果是(分別測試了并發為50,和100時，總共進行1000次訪問花費的時間 )
這里列出了最大、最小、平均值。均為相同的值，因為只進行了一次測試

1	`mysqlslap -a --concurrency=50,100 --number-of-queries 1000 --iterations=5 --engine=myisam,innodb --debug-info -uadmin -p123456`

分別測試 myisam 和 innodb 引擎

Benchmark

Running for engine myisam

Average number of seconds to run all queries: 0.638 seconds

Minimum number of seconds to run all queries: 0.565 seconds

Maximum number of seconds to run all queries: 0.924 seconds

Number of clients running queries: 50

Average number of queries per client: 20

Benchmark

Running for engine myisam

Average number of seconds to run all queries: 0.691 seconds

Minimum number of seconds to run all queries: 0.686 seconds

Maximum number of seconds to run all queries: 0.696 seconds

Number of clients running queries: 100

Average number of queries per client: 10

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 13.189 seconds

Minimum number of seconds to run all queries: 12.886 seconds

Maximum number of seconds to run all queries: 13.337 seconds

Number of clients running queries: 50

Average number of queries per client: 20

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 12.449 seconds

Minimum number of seconds to run all queries: 12.299 seconds

Maximum number of seconds to run all queries: 12.592 seconds

Number of clients running queries: 100

Average number of queries per client: 10

這個工具無法自己規定多少數據，所以我后來有拿了 super smack 工具測試

要去網上下載 vegan.net/tony/supersmack/super-smack-1.3.tar.gz

tar zxvf super-smack-1.3.tar.gz

cd super-smack-1.3

./configure --prefix=/usr/local/super-smack-1.3 --with-mysql=/usr/local/mysql/ --with-mysql-lib=/usr/local/mysql/lib/mysql/ --with-mysql-include=/usr/local/mysql/include/mysql/

編譯過程后 make 會報錯

修改 dictionary.h 和 super-smack.cc 增加#include

重點說明一下--with-mysql的編譯配置：

編譯的時候要把/usr/lib64目錄下的libmysqlclient.so.16放到/usr/lib目錄下，否則會出現下面的錯誤：

configure: error: Could not find libmysqlclient in ' /usr/lib /usr/lib/mysql??????????????????? /usr/local/lib /usr/local/lib/mysql??????????????????? /usr/local/mysql/lib

configure: error: Could not find mysql.h in ' /usr/include /usr/include/mysql??????????????????????? /usr/local/include /usr/local/include/mysql??????????????????????? /usr/local/mysql/include'

由于我的mysql是自行編譯的，所以我這樣操作

cd /usr/include; ln -s /usr/local/mysql/include/mysql

cd /usr/lib; ln -s /usr/local/mysql/lib/mysql

而且還要修改配置文件

dictionary.h: In member function ‘void Unique_dictionary::set_template(const char*)’:

dictionary.h:93:28: error: ‘strlen’ was not declared in this scope

super-smack.cc: In function ‘void set_parse_file(char*)’:

super-smack.cc:65:55: warning: deprecated conversion from string constant to ‘char*’

super-smack.cc: In function ‘void set_db_type(const char*)’:

super-smack.cc:72:48: warning: deprecated conversion from string constant to ‘char*’

super-smack.cc: In function ‘void print_engines()’:

super-smack.cc:126:55: error: ‘strlen’ was not declared in this scope

make[2]: *** [super-smack.o] 錯誤 1

make[1]: *** [all-recursive] 錯誤 1

make: *** [all-recursive-am] 錯誤 2

要修改相應的配置文件才行

編譯之前修改文件super-smack-1.3/src/query.cc

第193行：

< int len = 0, num_recs = 0;

修改成：

> long len = 0; int num_recs = 0;

第199,200行

< int str_len = (*i).first.length();

< if((unsigned)p + str_len + 3 *sizeof(int) < (unsigned)p_end )

修改成：

> long str_len = (*i).first.length();

> if((long)p + str_len + 3 *sizeof(int) < (long)p_end )

第219行

< len = (unsigned)p - (unsigned)buf;

修改成：

> len = (long)p - (long)buf;

這個我是看了相應教程找了好久才發現的！

1 2	`make` `make` `install`

介紹相應參數：

開頭要修改密碼默認文件

1	`vi` `select-key.smack`

// this is will be used in the table section

client "client"

{

user "admin";

host "localhost";

db "test";

pass "123456";

socket "/tmp/mysql.sock"; // this only applies to MySQL and is

// ignored for PostgreSQL

}

改成你所需要的相應密碼

super-smack select-key.smack n m
其中super-smack類似于一個解釋執行器，解釋執行select-key.smack中的內容，n為該次測試的并發線程數，m為每個線程執行數據庫操作的次數

smack文件，類似于一個c源文件，具體包括一下幾個內容

1.clien，定義創建連接用到的參數，包括host，user，passwd，port，socket。包括兩種client，admin client和普通client，admin需要具有管理權限，需要創建表以及load數據等操作

2.表定義，自定義測試表的表結構，需要指定由哪個client創建表，以及表的記錄數，以及填充數據文件的位置，如果數據文件不存在，需要生成數據文件，可以自定義數據生成腳本

3.dictionary，定義了一批可選的字段，源碼實現得比較簡單，只提供了幾種next方法，讀取下一行數據，如果改行數據用逗號分開，只取第一個逗號前的字段，其他符號分隔則取整行數據。所以如果一個查詢里有幾個字段需要從外部獲取數據，就應該創建幾個dictionary

4.查詢，可以自定義查詢的語句，查詢類型(主要用于分類統計的作用)，查詢語句也可以為更新操作，如update。如果是查詢語句，has_result_set選項應該定義為y，否則會出現Commands out of sync錯誤，感覺這里是super-smack的一個bug

5.main，測試運行的入口，一般改動不大，主要是一些client名稱的改動

測試：

1 2	`gen-data -n 9000 -f %n > words.dat` `9000就是數據你可以改成相應的數值比如說 5000000`

1	`cp` `words.dat` `/var/smack-data/words.dat`

把文件復制過去。

然后進入

[root@localhost bin]# cd /usr/share/smacks/

select-key.smack???? update-select.smack

[root@localhost bin]# cd /usr/share/smacks/

[root@localhost smacks]# pwd

/usr/share/smacks

1	`super-smack -d mysql` `/usr/share/smacks/select-key.smack 10 1000`

運行命令開始測試

[root@localhost smacks]# super-smack -d mysql /usr/share/smacks/select-key.smack 10 1000

Query Barrel Report for client smacker

connect: max=6ms? min=0ms avg= 3ms from 10 clients

Query_type????? num_queries???? max_time??????? min_time??????? q_per_s

select_index??? 10000?? 3?????? 0?????? 526.21

update_index??? 10000?? 9?????? 0?????? 526.21

mysql> alter table http_auth engine innodb;

Query OK, 5000000 rows affected (2 min 32.28 sec)

Records: 5000000? Duplicates: 0? Warnings: 0

mysql> alter table http_auth engine MYISAM;

Query OK, 5000000 rows affected (2 min 29.94 sec)

Records: 5000000? Duplicates: 0? Warnings: 0

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

select * from http_auth;

| 4895123? | NULL??? |?? 0 |?? 0 |

| 4895124? | NULL??? |?? 0 |?? 0 |

| 4895125? | NULL??? |?? 0 |?? 0 |

| 4895126? | NULL??? |?? 0 |?? 0 |

| 4895127? | NULL??? |?? 0 |?? 0 |

| 4895128? | NULL??? |?? 0 |?? 0 |

| 4895129? | NULL??? |?? 0 |?? 0 |

| 489513?? | NULL??? |?? 0 |?? 0 |

| 4895130? | NULL??? |?? 0 |?? 0 |

| 4895131? | NULL??? |?? 0 |?? 0 |

| 4895132? | NULL??? |?? 0 |?? 0 |

| 4895133? | NULL??? |?? 0 |?? 0 |

| 4895134? | NULL??? |?? 0 |?? 0 |

| 4895135? | NULL??? |?? 0 |?? 0 |

| 4895136? | NULL??? |?? 0 |?? 0 |

| 4895137? | NULL??? |?? 0 |?? 0 |

| 4895138? | NULL??? |?? 0 |?? 0 |

| 4895139? | NULL??? |?? 0 |?? 0 |

| 489514?? | NULL??? |?? 0 |?? 0 |

| 4895140? | NULL??? |?? 0 |?? 0 |

| 4895141? | NULL??? |?? 0 |?? 0 |

| 4895142? | NULL??? |?? 0 |?? 0 |

| 4895143? | NULL??? |?? 0 |?? 0 |

| 4895144? | NULL??? |?? 0 |?? 0 |

| 4895145? | NULL??? |?? 0 |?? 0 |

| 4895146? | NULL??? |?? 0 |?? 0 |

| 4895147? | NULL??? |?? 0 |?? 0 |

| 4895148? | NULL??? |?? 0 |?? 0 |

| 4895149? | NULL??? |?? 0 |?? 0 |

| 489515?? | NULL??? |?? 0 |?? 0 |

| 4895150? | NULL??? |?? 0 |?? 0 |

| 4895151? | NULL??? |?? 0 |?? 0 |

| 4895152? | NULL??? |?? 0 |?? 0 |

| 4895153? | NULL??? |?? 0 |?? 0 |

| 4895154? | NULL??? |?? 0 |?? 0 |

| 4895155? | NULL??? |?? 0 |?? 0 |

| 4895156? | NULL??? |?? 0 |?? 0 |

| 4895157? | NULL??? |?? 0 |?? 0 |

| 4895158? | NULL??? |?? 0 |?? 0 |

| 4895159? | NULL??? |?? 0 |?? 0 |

| 489516?? | NULL??? |?? 0 |?? 0 |

| 4895160? | NULL??? |?? 0 |?? 0 |

| 4895161? | NULL??? |?? 0 |?? 0 |

| 4895162? | NULL??? |?? 0 |?? 0 |

| 4895163? | NULL??? |?? 0 |?? 0 |

| 4895164? | NULL??? |?? 0 |?? 0 |

| 4895165? | NULL??? |?? 0 |?? 0 |

| 4895166? | NULL??? |?? 0 |?? 0 |

| 4895167? | NULL??? |?? 0 |?? 0 |

| 4895168? | NULL??? |?? 0 |?? 0 |

| 4895169? | NULL??? |?? 0 |?? 0 |

| 489517?? | NULL??? |?? 0 |?? 0 |

| 4895170? | NULL??? |?? 0 |?? 0 |

| 4895171? | NULL??? |?? 0 |?? 0 |

| 4895172? | NULL??? |?? 0 |?? 0 |

| 4895173? | NULL??? |?? 0 |?? 0 |

| 4895174? | NULL??? |?? 0 |?? 0 |

| 4895175? | NULL??? |?? 0 |?? 0 |

| 4895176? | NULL??? |?? 0 |?? 0 |

| 4895177? | NULL??? |?? 0 |?? 0 |

| 4895178? | NULL??? |?? 0 |?? 0 |

| 4895179? | NULL??? |?? 0 |?? 0 |

| 489518?? | NULL??? |?? 0 |?? 0 |

| 4895180? | NULL??? |?? 0 |?? 0 |

| 4895181? | NULL??? |?? 0 |?? 0 |

| 4895182? | NULL??? |?? 0 |?? 0 |

| 4895183? | NULL??? |?? 0 |?? 0 |

| 4895184? | NULL??? |?? 0 |?? 0 |

| 4895185? | NULL??? |?? 0 |?? 0 |

| 4895186? | NULL??? |?? 0 |?? 0 |

| 4895187? | NULL??? |?? 0 |?? 0 |

| 4895188? | NULL??? |?? 0 |?? 0 |

| 4895189? | NULL??? |?? 0 |?? 0 |

| 489519?? | NULL??? |?? 0 |?? 0 |

| 4895190? | NULL??? |?? 0 |?? 0 |

| 4895191? | NULL??? |?? 0 |?? 0 |

| 4895192? | NULL??? |?? 0 |?? 0 |

| 4895193? | NULL??? |?? 0 |?? 0 |

| 4895194? | NULL??? |?? 0 |?? 0 |

| 4895195? | NULL??? |?? 0 |?? 0 |

| 4895196? | NULL??? |?? 0 |?? 0 |

| 4895197? | NULL??? |?? 0 |?? 0 |

| 4895198? | NULL??? |?? 0 |?? 0 |

| 4895199? | NULL??? |?? 0 |?? 0 |

| 48952??? | NULL??? |?? 0 |?? 0 |

| 489520?? | NULL??? |?? 0 |?? 0 |

| 4895200? | NULL??? |?? 0 |?? 0 |

| 4895201? | NULL??? |?? 0 |?? 0 |

| 4895202? | NULL??? |?? 0 |?? 0 |

| 4895203? | NULL??? |?? 0 |?? 0 |

| 4895204? | NULL??? |?? 0 |?? 0 |

| 4895205? | NULL??? |?? 0 |?? 0 |

| 4895206? | NULL??? |?? 0 |?? 0 |

| 4895207? | NULL??? |?? 0 |?? 0 |

| 4895208? | NULL??? |?? 0 |?? 0 |

| 4895209? | NULL??? |?? 0 |?? 0 |

| 489521?? | NULL??? |?? 0 |?? 0 |

| 4895210? | NULL??? |?? 0 |?? 0 |

| 4895211? | NULL??? |?? 0 |?? 0 |

| 4895212? | NULL??? |?? 0 |?? 0 |

| 4895213? | NULL??? |?? 0 |?? 0 |

| 4895214? | NULL??? |?? 0 |?? 0 |

| 4895215? | NULL??? |?? 0 |?? 0 |

| 4895216? | NULL??? |?? 0 |?? 0 |

| 4895217? | NULL??? |?? 0 |?? 0 |

| 4895218? | NULL??? |?? 0 |?? 0 |

| 4895219? | NULL??? |?? 0 |?? 0 |

| 489522?? | NULL??? |?? 0 |?? 0 |

| 4895220? | NULL??? |?? 0 |?? 0 |

| 4895221? | NULL??? |?? 0 |?? 0 |

| 4895222? | NULL??? |?? 0 |?? 0 |

| 4895223? | NULL??? |?? 0 |?? 0 |

| 4895224? | NULL??? |?? 0 |?? 0 |

| 4895225? | NULL??? |?? 0 |?? 0 |

| 4895226? | NULL??? |?? 0 |?? 0 |

| 4895227? | NULL??? |?? 0 |?? 0 |

| 4895228? | NULL??? |?? 0 |?? 0 |

| 4895229? | NULL??? |?? 0 |?? 0 |

| 489523?? | NULL??? |?? 0 |?? 0 |

| 4895230? | NULL??? |?? 0 |?? 0 |

| 4895231? | NULL??? |?? 0 |?? 0 |

| 4895232? | NULL??? |?? 0 |?? 0 |

| 4895233? | NULL??? |?? 0 |?? 0 |

| 4895234? | NULL??? |?? 0 |?? 0 |

| 4895235? | NULL??? |?? 0 |?? 0 |

| 4895236? | NULL??? |?? 0 |?? 0 |

| 4895237? | NULL??? |?? 0 |?? 0 |

| 4895238? | NULL??? |?? 0 |?? 0 |

| 4895239? | NULL??? |?? 0 |?? 0 |

| 489524?? | NULL??? |?? 0 |?? 0 |

| 4895240? | NULL??? |?? 0 |?? 0 |

| 4895241? | NULL??? |?? 0 |?? 0 |

| 4895242? | NULL??? |?? 0 |?? 0 |

| 4895243? | NULL??? |?? 0 |?? 0 |

| 4895244? | NULL??? |?? 0 |?? 0 |

| 4895245? | NULL??? |?? 0 |?? 0 |

| 4895246? | NULL??? |?? 0 |?? 0 |

| 4895247? | NULL??? |?? 0 |?? 0 |

| 4895248? | NULL??? |?? 0 |?? 0 |

| 4895249? | NULL??? |?? 0 |?? 0 |

| 489525?? | NULL??? |?? 0 |?? 0 |

| 4895250? | NULL??? |?? 0 |?? 0 |

| 4895251? | NULL??? |?? 0 |?? 0 |

| 4895252? | NULL??? |?? 0 |?? 0 |

| 4895253? | NULL??? |?? 0 |?? 0 |

| 4895254? | NULL??? |?? 0 |?? 0 |

| 4895255? | NULL??? |?? 0 |?? 0 |

| 4895256? | NULL??? |?? 0 |?? 0 |

| 4895257? | NULL??? |?? 0 |?? 0 |

| 4895258? | NULL??? |?? 0 |?? 0 |

| 4895259? | NULL??? |?? 0 |?? 0 |

| 489526?? | NULL??? |?? 0 |?? 0 |

| 4895260? | NULL??? |?? 0 |?? 0 |

| 4895261? | NULL??? |?? 0 |?? 0 |

| 4895262? | NULL??? |?? 0 |?? 0 |

| 4895263? | NULL??? |?? 0 |?? 0 |

| 4895264? | NULL??? |?? 0 |?? 0 |

| 4895265? | NULL??? |?? 0 |?? 0 |

| 4895266? | NULL??? |?? 0 |?? 0 |

| 4895267? | NULL??? |?? 0 |?? 0 |

| 4895268? | NULL??? |?? 0 |?? 0 |

| 4895269? | NULL??? |?? 0 |?? 0 |

| 489527?? | NULL??? |?? 0 |?? 0 |

| 4895270? | NULL??? |?? 0 |?? 0 |

| 4895271? | NULL??? |?? 0 |?? 0 |

| 4895272? | NULL??? |?? 0 |?? 0 |

| 4895273? | NULL??? |?? 0 |?? 0 |

| 4895274? | NULL??? |?? 0 |?? 0 |

| 4895275? | NULL??? |?? 0 |?? 0 |

| 4895276? | NULL??? |?? 0 |?? 0 |

| 4895277? | NULL??? |?? 0 |?? 0 |

| 4895278? | NULL??? |?? 0 |?? 0 |

| 4895279? | NULL??? |?? 0 |?? 0 |

| 489528?? | NULL??? |?? 0 |?? 0 |

| 4895280? | NULL??? |?? 0 |?? 0 |

| 4895281? | NULL??? |?? 0 |?? 0 |

| 4895282? | NULL??? |?? 0 |?? 0 |

| 4895283? | NULL??? |?? 0 |?? 0 |

| 4895284? | NULL??? |?? 0 |?? 0 |

| 4895285? | NULL??? |?? 0 |?? 0 |

| 4895286? | NULL??? |?? 0 |?? 0 |

| 4895287? | NULL??? |?? 0 |?? 0 |

| 4895288? | NULL??? |?? 0 |?? 0 |

| 4895289? | NULL??? |?? 0 |?? 0 |

| 489529?? | NULL??? |?? 0 |?? 0 |

| 4895290? | NULL??? |?? 0 |?? 0 |

| 4895291? | NULL??? |?? 0 |?? 0 |

| 4895292? | NULL??? |?? 0 |?? 0 |

| 4895293? | NULL??? |?? 0 |?? 0 |

| 4895294? | NULL??? |?? 0 |?? 0 |

| 4895295? | NULL??? |?? 0 |?? 0 |

| 4895296? | NULL??? |?? 0 |?? 0 |

| 4895297? | NULL??? |?? 0 |?? 0 |

| 4895298? | NULL??? |?? 0 |?? 0 |

| 4895299? | NULL??? |?? 0 |?? 0 |

| 48953??? | NULL??? |?? 0 |?? 0 |

| 489530?? | NULL??? |?? 0 |?? 0 |

| 4895300? | NULL??? |?? 0 |?? 0 |

| 4895301? | NULL??? |?? 0 |?? 0 |

| 4895302? | NULL??? |?? 0 |?? 0 |

| 4895303? | NULL??? |?? 0 |?? 0 |

| 4895304? | NULL??? |?? 0 |?? 0 |

| 4895305? | NULL??? |?? 0 |?? 0 |

| 4895306? | NULL??? |?? 0 |?? 0 |

| 4895307? | NULL??? |?? 0 |?? 0 |

| 4895308? | NULL??? |?? 0 |?? 0 |

| 4895309? | NULL??? |?? 0 |?? 0 |

| 489531?? | NULL??? |?? 0 |?? 0 |

| 4895310? | NULL??? |?? 0 |?? 0 |

| 4895311? | NULL??? |?? 0 |?? 0 |

| 4895312? | NULL??? |?? 0 |?? 0 |

| 4895313? | NULL??? |?? 0 |?? 0 |

| 4895314? | NULL??? |?? 0 |?? 0 |

| 4895315? | NULL??? |?? 0 |?? 0 |

| 4895316? | NULL??? |?? 0 |?? 0 |

| 4895317? | NULL??? |?? 0 |?? 0 |

| 4895318? | NULL??? |?? 0 |?? 0 |

| 4895319? | NULL??? |?? 0 |?? 0 |

| 489532?? | NULL??? |?? 0 |?? 0 |

| 4895320? | NULL??? |?? 0 |?? 0 |

| 4895321? | NULL??? |?? 0 |?? 0 |

| 4895322? | NULL??? |?? 0 |?? 0 |

| 4895323? | NULL??? |?? 0 |?? 0 |

5000000 rows in set (10.72 sec)

這樣就能達到你的效果了，如果你需要改字段

// ensure the table exists and meets the conditions

table "http_auth"

{

client "client"; // 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 "5000000"; // the table must have at least that many rows

data_file "words.dat"; // if the table is empty, load the data from

//this file

gen_data_file "gen-data -n 5000000 -f %12-12s%n,%25-25s,%n,%d";

// if the file above does not exist, generate it with the above command

}

直接修改相應字段就可以了！這樣測試就方便多了，給大家方便快捷，也能達到任務需要！不管多少數據都能測試！ok 就寫到這，因為我也是剛用！慢慢熟悉吧！

根據需要每個列名都要有數據

1	`gen-data -n 5000000 -f %12-12s%n,%25-25s,%n,%d >` `/var/smack-data/words.dat`

1	`[root@localhost smacks]# super-smack -d mysql /usr/share/smacks/select-key.smack 10 1000`

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

select * from http_auth;

| aabbevmabgiq2034184 | vvlcduqibaihmmhhqwttywudu | 2034184 |? 674655809 |

| fxsnoojdtoxk2034185 | wymiibwrinqfjqcfvaqexjtnb | 2034185 | 2096770029 |

| susqhsptdawa2034186 | ripinabrharxeqiagjgygcpnu | 2034186 | 1683359057 |

| jxhiabqplgpn2034187 | yypqxvjivrtdqafipcryabjcc | 2034187 | 1641721901 |

| rohkeijtchpl2034188 | rnelqwlvgbxacacocgpwuyjbi | 2034188 | 1220581668 |

| umdmxubehtcu2034189 | qkyqmdtorxvjusleuvaridhia | 2034189 |? 886946585 |

| njerfwegqqjk2034190 | ieiengyymvuoqdtxmukcgovno | 2034190 | 1250124550 |

| tfsgpbkafxih2034191 | axdwmtbhtpcetkvpykrspkbhm | 2034191 |? 522496211 |

| jtksbmsfjfbm2034192 | mveqaxcxpbihvasxhfltyxodk | 2034192 |? 992099432 |

| iumlhchmskmu2034193 | idxtkwtfwemixmhorrvcoknwm | 2034193 |? 241604373 |

| lgixdsdemodj2034194 | tanhknvrcpmarbmfaadninonj | 2034194 | 1429041942 |

| txiwhfywokkm2034195 | eocqqtuebwehnowccgvwffvmm | 2034195 | 1057608646 |

| mbiwnmorgfld2034196 | loarxngvrlcokjvgyicllkkya | 2034196 |??? 7771351 |

| qghejuulntct2034197 | pvhtkrgiyhsdseqffqhxyoeil | 2034197 | 1340587400 |

| vyvxvludhhvp2034198 | suwlapsqvajfyivdshfphbpdo | 2034198 | 1907233685 |

| gyueonbmbcev2034199 | ucwfhvndbhljwukoacagbwnrm | 2034199 | 1409645639 |

| epslmopjtxhj2034200 | diqqtplhhljhumgkesylkuwwj | 2034200 | 2043058062 |

| gfmnosyijsax2034201 | ahllqixysdtuqfppcbcjgrywk | 2034201 |?? 63981550 |

| hvtktvriilqg2034202 | kklhhcmwroxwagqcfdcnyxxvu | 2034202 |? 734650092 |

| eddwlqjxxqcm2034203 | nwbntetmicpkpojnmehsjnque | 2034203 | 1150298450 |

| ueraqhwtxsxt2034204 | hivwtlnfbbjjvuwmrdppjhpaq | 2034204 | 1651462539 |

| vojwjqffnytd2034205 | eugpgdmfpfifutomtgdqwmpgf | 2034205 |? 321945120 |

| ouuixbfftmkg2034206 | raldiiwwwtfamdoclvwcqtkrx | 2034206 | 1248665491 |

| yrdjxwlmctuc2034207 | tsvyukekosgnuakgriysaecad | 2034207 |? 913737563 |

| mgikicfgdask2034208 | mhdvwavhipphirnksrahaitim | 2034208 | 1271873699 |

| qscjfoskkpkg2034209 | xtxndgitqdltklchvrgmmixra | 2034209 |? 373957541 |

| ckgotektuqbd2034210 | ktgxnsjsahkjvyttqtkuhqldx | 2034210 |? 820884072 |

| wsnxxxugviyh2034211 | bconlkmhgfcqclhoohnnabmxb | 2034211 |? 239509809 |

| gyrggvkwjvjy2034212 | fpghilurcjapacsobtxjsppbn | 2034212 | 1661636625 |

| axxjyebhnluj2034213 | dwudoughjjbhsvalynlynmkos | 2034213 |?? 90625363 |

| wgytrdrngiko2034214 | quxtetqefrusrihcaaqyjpsbs | 2034214 |? 416659962 |

| qcvcsmyrifnb2034215 | msthnlrvprxgqhykltwexsirh | 2034215 | 1626598707 |

| jqnyrarnjhyb2034216 | dptexklywytuerpmjawusmtmo | 2034216 | 2054494238 |

| bxxcbdruhsiv2034217 | rfuncbguqrupppclcqcdqairf | 2034217 |? 169891302 |

| pnuxlpfgdkkl2034218 | fdgcsxrujvnncgpkavmplipwa | 2034218 |??? 5445173 |

| ffiprnsarnxj2034219 | ijfxxheptflhwwrntrlawtrqj | 2034219 |? 639986363 |

| qbbommbtkyer2034220 | oxydfvcwjwqwyosqfcgyfiptu | 2034220 |? 416490541 |

| ohrsyhqxmywo2034221 | vinngmebglemklwbgtrwckpdt | 2034221 | 1305348333 |

| egjbwgjlvrac2034222 | tgnavyluctptqrgiuarbibcij | 2034222 |? 345011664 |

| thgtlcdacbbq2034223 | vdmlyefgmdggerkhavxvgerrh | 2034223 | 1909743645 |

| tlxucuapiavo2034224 | gktorxiehiafggmyyvvuhuqmr | 2034224 | 2041859391 |

| easaqbkmqelb2034225 | iukldqrrrsnoowjhjbandtnwu | 2034225 | 1017087051 |

| jnfupqsccvut2034226 | pnpdcgannkopatjqqhrbwyxop | 2034226 |? 627795668 |

| qtqoogcgjgmm2034227 | tcykryeepxnjbmlbcduuxljos | 2034227 | 1339637838 |

| uevjqpnrchrj2034228 | njhbvkqhlumgpkucyprvtohne | 2034228 | 1431069995 |

| fhfyssjawhkn2034229 | qxidfaoacppumljtyprhywgrp | 2034229 | 1394730742 |

| toygcpfmvmnk2034230 | mraeoopxlrqdbrcjktcgjdpnv | 2034230 | 1777161545 |

| brhqevigcxvr2034231 | xhlqmmjqwvkbcvgrkcolvxcav | 2034231 |? 847590812 |

| hxkfslmecbtl2034232 | rshetmbcglfvydvdgspnsdslq | 2034232 | 1788579432 |

| qskmhefokbdl2034233 | dkykixoeduytksyfgpowkyjrf | 2034233 |? 251755991 |

| jproevydgheu2034234 | ohrpdckejrvxohwbbctkumayi | 2034234 | 1052924976 |

| colimcqgrvld2034235 | buuwtlgsoivjusvurgyvwkfjo | 2034235 |?? 75891348 |

| qgteluyiusub2034236 | mljkwfducwbdsypxkevdlshwn | 2034236 | 1088911032 |

| gkcdmoqxbode2034237 | jidnlwmcwygtdtmktctcnwhcl | 2034237 | 1702026748 |

| apogtbqaoewd2034238 | itcpphlcshhmjwlsbxrbpijjj | 2034238 |? 318020452 |

| lahidpfihupt2034239 | akdhanglghlakblunwwyxgidw | 2034239 | 1904816588 |

| lgkeakqetqta2034240 | dchqfssqpgnohnvrruffbsled | 2034240 |? 843833878 |

| kxtexyiiqpdl2034241 | istyhbmftgabmctaixdsxayxy | 2034241 |?? 51410359 |

| grajdieyhobw2034242 | tuduxrysshsxcsxbqakatklav | 2034242 | 1202732291 |

| yffacywivvcw2034243 | qwglvievluxywuljwhavphyti | 2034243 |? 686997948 |

| chvhemenxcxc2034244 | bkayjwvwgsfirurqqbqtindoa | 2034244 | 1534573982 |

| ebmdfnpfobfl2034245 | xlgfwxcqotripcvstvcayodfc | 2034245 | 1796175795 |

| ktxpfyelgdmj2034246 | tddolushnmgpnfhskjqxdqpkp | 2034246 | 2124508369 |

| ywylitqnkdid2034247 | kxqspgywblhrjmlcabxyaxmkt | 2034247 | 1777201503 |

| xeiihvgaowin2034248 | tkcdenqppstottogfilfouoxq | 2034248 | 1558224570 |

| yfthvotxrylk2034249 | oediuyfjfmttriqiijgjoatmo | 2034249 |? 843066113 |

| mjmbvefcoabt2034250 | lhifddptlxdritscjjrvshwpl | 2034250 | 1740413804 |

| ragswtchyfkq2034251 | bwpeqablekvvgqdggqmarvvqp | 2034251 | 2010978498 |

| xrglijkxobar2034252 | pecldkcgqlxgnrcjktkklsvuc | 2034252 | 1974232231 |

| uskvkaconfar2034253 | msdmytgddqxnbjiaeliaeuxrw | 2034253 |? 993131900 |

| gkggducijbep2034254 | higfxjohlvuuxbpvsnvcaekfb | 2034254 | 1556984087 |

| qkquaxfifeuv2034255 | ngrkdpltnhjkjjqvrslifcdic | 2034255 |? 115634686 |

| qhpndfwxpapb2034256 | vekfqvrhsjcetiiyqmkjtcayh | 2034256 |? 620264722 |

| yywpbttlbkks2034257 | rdewjxftaxgkjcnjbwibwgsac | 2034257 | 1263963412 |

| ndyxwsddpmew2034258 | geumqhogssecvdiodkdqncrmu | 2034258 |? 560958720 |

| sliwiqbggrnw2034259 | bipfkniselfhevjvkftdscadu | 2034259 |? 478505153 |

| jbxybykseuho2034260 | qlcvvgtfffmyihdjlaowcmyfl | 2034260 |? 553638609 |

| xrehgutitprn2034261 | wwskxetdnfdedhrcmdnlvruep | 2034261 | 2117060364 |

| njghygeuseym2034262 | hosmsxukcjqpwojssyjgksnky | 2034262 | 2075963369 |

| fraegjuywnyt2034263 | ybdrsbgdtycdipvxawuhqunxh | 2034263 |? 384434658 |

| yevyawcdoveu2034264 | yawdgfseducacsvpsfxslwrlt | 2034264 | 1820812969 |

| olrviqxfwemp2034265 | lslnspiqgcvguhdosakkldivv | 2034265 |? 367627933 |

| espqlbjyqfoy2034266 | vwdsexajovjaiwfstbbxuqqir | 2034266 |??? 5493428 |

| hiivketnwaoa2034267 | jdxtfgqkbmocmltetnhbypyjt | 2034267 |? 777952970 |

| wtunvhrtdycv2034268 | mdjbhvmbairhjqykctgypdplk | 2034268 | 1927246982 |

| fnijkuovxvrm2034269 | auuregkermaanpddbqmigvtss | 2034269 | 1260089433 |

| orejegeaxkgk2034270 | oawqalgeqjwetdcpwuxnmfwrl | 2034270 | 1080708728 |

| tmocwfdwydkf2034271 | jbrghnkjejfewtjwnxahmqmjy | 2034271 | 1401139565 |

| ixusfhwwnena2034272 | orjvxjpkgeiinuaagyprwnkcu | 2034272 | 2009022832 |

| ciopldjwbhgq2034273 | roucxjyxliycaxrmamwewlviq | 2034273 | 2010740080 |

| irpoijegoern2034274 | cdvbhxyylbniiltevkmeeevmn | 2034274 |? 594151402 |

| scgmskqqnxpo2034275 | abpnjayffxrrcvvxilceqiqjs | 2034275 |? 444742984 |

| agiruisnxenx2034276 | juvdmaykbkydqpmhbhtdqcvnm | 2034276 |? 982803441 |

| bkvrkhmincjm2034277 | okynnpfcagmtmdxksmbwyyokj | 2034277 | 1240726553 |

| swhelwolkfbs2034278 | jbbvunbuxwhcthdktmnolvtxu | 2034278 | 1637029883 |

| jhpmaaocxlrc2034279 | jsyquuaxftnujbsdynnkxexxg | 2034279 | 1452936814 |

| cgcuilnjfkgh2034280 | klcahnccsbqiooomoudtehomv | 2034280 | 1991047779 |

| ybqfkdtmedci2034281 | fulxgaouoestxwcolxukbnslq | 2034281 | 2129550587 |

| bwrffwdtvjtk2034282 | elqwfqthhghcskrnwlcaitfqr | 2034282 | 1334067658 |

| kprgcyrtvxms2034283 | hubpytariyfkynhhgbrsqkasl | 2034283 | 1909458292 |

| ojrecaydrxar2034284 | rktwwunecvfupxhrtslkceohg | 2034284 | 1884534213 |

| mxompiyjiwfx2034285 | djvleljnffirqlxfuevhcmwtw | 2034285 |? 644741723 |

| ghwnfbycmgpx2034286 | tvgdpwqpenvcwaqttoucvrres | 2034286 |?? 81426869 |

| ghaxivvoynnr2034287 | dtfywdynyvetadouhjoptopck | 2034287 | 1017236737 |

| smaiegcmfyrh2034288 | pqdvnfyeainoxhfolqdgddojl | 2034288 |? 982985142 |

| vrspbijghylg2034289 | dmpqdpbjgoajvfpmqbepuxfvi | 2034289 | 1081326839 |

| epnqyqfqkign2034290 | tpetbcbqpsutkrtpqfhuwulvo | 2034290 |? 329761443 |

| obcxovnssovv2034291 | inqfjbygtplbnkxbjmuxnyveu | 2034291 |? 721932961 |

| apdxonlfsujt2034292 | bfkogaaebjtvjjugqstskwqyk | 2034292 |? 664486529 |

| hfbsadxmtemv2034293 | knfgmrsjxjctcpruqcyxkaskf | 2034293 | 1129740466 |

| wcwlxkygqnxj2034294 | xxucrwrjtjosjyvflbvkdvvcg | 2034294 |? 529267572 |

| kyliljgglxgg2034295 | karbtdarinshxydvdjsnkevvp | 2034295 |? 418173504 |

| declmolephjr2034296 | yufucfvhbyqwoddkatqfasqmk | 2034296 |? 142270704 |

| samcsnyxibge2034297 | ihfbgtfkghgwmgsfudjpdvtvm | 2034297 |? 616358794 |

| wuudcgmjjveo2034298 | gmxokkwfpriahnxdmkwjiuomb | 2034298 |? 651314328 |

| vmycchpcvcps2034299 | hfmrhvfiaruwdfrrruxqiwsmf | 2034299 | 1299310210 |

| qbogwvojnvgv2034300 | ggpcftjancwluflptsbltptso | 2034300 |? 385650008 |

| dehlanrsrymc2034301 | ycgwqbecqbutoqmikbrphybko | 2034301 |? 270079945 |

| djtrltttqkww2034302 | opxjkmdyvpcpfjqgtfbwowocq | 2034302 |? 963271711 |

| vjxuhnlhwxuc2034303 | wsrykwkbffgiexgvawhyjftqu | 2034303 | 1652200405 |

| xufuwcppdaoo2034304 | buvkfailvklfjunenilnfrldv | 2034304 | 1792470626 |

| uaejohgmrmmc2034305 | alnlswiidxtrmyjachdwhhjxp | 2034305 | 1167551340 |

| kjcaodlcqgbc2034306 | phajyoikonrsmccvarmneqnsv | 2034306 | 1036434176 |

| wpharyhriihr2034307 | uxhnqtrtqrnfhtvuouxlkioeh | 2034307 | 1959118246 |

| vqhfkcerrulj2034308 | qcefjlyijodjcprqtaprsyadb | 2034308 |? 850369104 |

| uvbifsnlawxb2034309 | fjrksuannvnfqgeqliuiexqlq | 2034309 | 1751126329 |

| xqexujjmuejw2034310 | ravffmnmdywahdxborhoklofv | 2034310 | 1010167448 |

| ssdepwenfkas2034311 | yfuvhebghpaphkbvsyultapmw | 2034311 |?? 82737222 |

| achbxiisgqyh2034312 | yhyywgladecarvakiyhjcqmay | 2034312 | 1599384070 |

| uhntomdnnawa2034313 | dcefcydejmdqxfhmhihepxbgk | 2034313 | 1331065654 |

| vyhsbkuhrygu2034314 | dpjhijopvyagdpegxqlupupqh | 2034314 | 1582937061 |

| bykhvoxixgrm2034315 | yonywtrbaprlkkibdpoeqbmnr | 2034315 | 1142274212 |

| xpupfvguxdop2034316 | ephydsjmvoemtvniliujaryho | 2034316 | 2105986756 |

| dmlreshlrlgd2034317 | acreqnahvnpswrlyaahdosusl | 2034317 |?? 19094930 |

| efqlkqpdwhsx2034318 | qpliilatkavrdkmbfbgkgwvrp | 2034318 |? 830905088 |

| wmwpmnhbvsow2034319 | oyylsdxheeikorjmlbcipaadp | 2034319 |? 122577260 |

| godunrvmfqpe2034320 | xvkjibbrpmurwlrwokhwymtmf | 2034320 | 1346381265 |

| ykgrqgpbpycq2034321 | srfokcaecqolnpyjceyeqhvin | 2034321 | 1696724986 |

| jgmoygifusjw2034322 | alnqxdhwmldnptwnckaosofsu | 2034322 |? 323348913 |

| arjjqjvgcvjl2034323 | sxxxnprkewxgnquslsglkpveb | 2034323 |? 186465969 |

| kgpurkupijic2034324 | tmbrsojnjugsjtkfxoyiuofmb | 2034324 |? 457289128 |

| fjmnniapbugm2034325 | isjrlslvalmbvhpewshcctrse | 2034325 | 2118759442 |

| ifmqtwjeouyc2034326 | tcnidkqvonoxrttjmxdwernao | 2034326 | 1454250248 |

| ggugiqkyanlq2034327 | jcgyaxuthhrmexetyurfbpnmg | 2034327 | 1835425048 |

| liowbxyhybft2034328 | uodobhnhemdvtgnkswkgfyfha | 2034328 | 2093719104 |

| oyhwvcnyrrjh2034329 | yntclplaaewnlcmqlmxdmhakk | 2034329 |?? 43433415 |

| jehslhihluyw2034330 | ucetprxcikringqpqdfajnvuw | 2034330 |? 392587279 |

| eiydivfmpweq2034331 | aobraqasiqvnqhbmearijsnrp | 2034331 |? 951275096 |

| ghsmaubdodto2034332 | vcftsybvnfwfpgbeasciauuds | 2034332 | 1986089846 |

| ghabyxfgsxfv2034333 | utctbracxcuakxxhdqdjafmbg | 2034333 |? 104338995 |

| iysnwpjyjltl2034334 | ptpnwcnujqnpanwprdkaefpcx | 2034334 | 1057170075 |

| djnyvdtnsqqg2034335 | nawbraqppiuakahbefbjpqjlt | 2034335 |? 405298080 |

| bnvrvluvmmvf2034336 | enqapbawcgdfpsxygsehiccep | 2034336 |? 634693524 |

| cenaksnbsfeu2034337 | fjbkqqdpslkyuseyytxcbmclf | 2034337 |? 945342893 |

| oaxsufevpvou2034338 | ljgxleqpdrlevmqyaxtoxtkua | 2034338 |? 132242441 |

| spmjlattxfxq2034339 | wejkihabgabcrbwevwuookxck | 2034339 |? 624211444 |

| wlbwcxdnlnvl2034340 | oenrhfselqdhhrrguectpequc | 2034340 | 1573048520 |

| inigbalprsun2034341 | yjecqmtkuqqwkhbeegymvjtxl | 2034341 | 1077444582 |

| ngcktbvafoob2034342 | ylssjfamjguksruorgxhmatid | 2034342 |? 635649591 |

| lifamhmfaxmc2034343 | kwighdaeurnsycvslylykrywy | 2034343 |? 664371313 |

| eylsdyplhaoh2034344 | ejyrfawbukchjoyinayrykncl | 2034344 | 1546614778 |

| psfeakqbevbb2034345 | ywnbewqfigfhbgtoigrayxgck | 2034345 | 1420320822 |

| dqufuveixigq2034346 | pqwuxxbtolchlehrgtrlkmsfj | 2034346 | 1069670447 |

| qjhycwpbrpcs2034347 | jqeoarshkybcmoqgvadmlnlnk | 2034347 |? 530763128 |

| rfstafkftlym2034348 | ujnynanhiljmbvcmlmsdtlwus | 2034348 |? 986664760 |

| cmxbbsnordrh2034349 | katuouqqjegciaqhujrwyrbal | 2034349 |? 725151639 |

| pfrjndljxbgq2034350 | truawfdpnayhxaaybnpsshcim | 2034350 | 1447927488 |

| tkqcdlwbntgs2034351 | jvtkgtlisovkhqrjcfyvrqbxe | 2034351 |? 579682048 |

| ytrfndejpkdd2034352 | sxrqibhcmjhmicfjaljyfbgug | 2034352 | 1789140535 |

| exwhephxgpaq2034353 | smccbkggvirfjaiqwqdcrblvs | 2034353 | 1931175444 |

| tclvsgjulkir2034354 | tgbnmknwdnojpgkdefyxhluct | 2034354 | 1114861081 |

| xfsiamobbdnq2034355 | btgpdvxnccubcdoyflhfqbnsp | 2034355 |? 551188005 |

| tsikkjeqbhpb2034356 | wtfruiwmjdxrkqubkkggeoqqb | 2034356 | 1329756197 |

| jcgygfulxqtw2034357 | fgafanvuogfwpjniaogktolau | 2034357 |? 758852282 |

| lsairfoukoig2034358 | jypovhbjpbyxnunauihgdjouo | 2034358 |? 736209605 |

| pbtxjfybwuix2034359 | fybgwpbkpvuyexivvyblaxmjd | 2034359 | 1433412386 |

| lcjtcouewsta2034360 | flvbmcbwxwvajxaxjfluiurkl | 2034360 | 2099058487 |

| qihminxgqmjr2034361 | jhphjbflbprmmcigmtvgddsns | 2034361 |?? 13165694 |

| ulggesnvaayi2034362 | laadmmfuvurrbuwvkspfewlkp | 2034362 | 1877184902 |

| ireharjaxwpf2034363 | tlclddicatupbcopoetxyxhyr | 2034363 | 1706281492 |

| apqpvkdxygeh2034364 | igdgxhinwwtqwsqhuiyubrmwe | 2034364 | 1635086340 |

| wdxbnijsoiaw2034365 | xwwtpvpidkrehuvvrbnqgluvt | 2034365 | 1722482229 |

| plopkophlfgd2034366 | ojniowdmuwpipyvkurrkdibox | 2034366 | 1802222391 |

| xlxeoooeyfdc2034367 | txbkgtjeeevvrafuofloslthb | 2034367 |? 959931060 |

| larofloixwch2034368 | bhowfgymdptofmcbvdljgdalq | 2034368 |? 810526764 |

| vplyyoinmpvn2034369 | dyeyplosmkxauefurvkolxpln | 2034369 | 1444561748 |

| bcnarsbxurjj2034370 | mxtmxqtfoncycpytborfsifld | 2034370 | 2044857256 |

| jxatjotgcuwx2034371 | allcmqsokvdfdwpkksttttpdl | 2034371 | 1880378035 |

| lpfjnfwykmrf2034372 | bddgkhfarpulmoicutogjvrye | 2034372 |? 628291917 |

| aqesvhxynigv2034373 | kblhmayudtotcaswywocpuulc | 2034373 |? 433188595 |

| mrftnpucwjev2034374 | fjrvewwwtxvkalfwyjrldwhto | 2034374 | 2052337052 |

| xoocmtmhrqeo2034375 | papnkrbrpadjngjvaxaaoodck | 2034375 | 1259233165 |

| jdiptarjpeeq2034376 | vtsbfghoeknfkevpghfrkpjgp | 2034376 |? 463349276 |

| qffuxdqqevao2034377 | ngybnlhkeotligcsmttfaccaf | 2034377 |?? 15668845 |

| tkrtyfcaiqnp2034378 | drgwerdgkragxciafovyypuaw | 2034378 |? 866656097 |

| ahnnyqiipmau2034379 | uknwsnccphsngrfbtcatlojnh | 2034379 | 1033075892 |

| vagvubikybxb2034380 | fqkxeqrktlothdkrqujmuqirt | 2034380 |? 288215768 |

| dutdvaviadys2034381 | nueepojagawrmrkwmfpramwyo | 2034381 | 1009454519 |

| howjhmeosvdd2034382 | yldvdsqqrdvkuxwrylnjcksmy | 2034382 |? 608896849 |

| dsvgvutbqwtj2034383 | pmmnwjmvcnjrwldrxcrbwnjsk | 2034383 | 2076206953 |

| uddqnudajckx2034384 | xolhgjvlbvquankjjupgbuwop | 2034384 | 1147177003 |

| qbhdygtlpdwn2034385 | oakhvkxgvhenpfkotdrmeaqei | 2034385 | 1457917985 |

| panoofoymklk2034386 | thtxxldibylslquewdroefdsm | 2034386 | 1410265942 |

| taffmyojymue2034387 | vvfjrscmxyspnywsrklnmssbt | 2034387 |? 101228059 |

| kswiyugeexwh2034388 | nuigmyfmrywfmlxhmrqampklk | 2034388 | 1511272966 |

| pprpyfmjnaiu2034389 | mdtliiyjrndkpqbaeltwdlmes | 2034389 | 1103835449 |

| ogbwbpawdlhc2034390 | wyqajgsmjayfweqjjlkxrmwuc | 2034390 | 1760561700 |

| tgnbkkcbmnkg2034391 | bvgcbditorfyrynrvqtryhsjt | 2034391 | 1342964022 |

| ngmaonvwryab2034392 | squaspyghuwdmxmhkggxosxej | 2034392 | 1696821921 |

| bdwegpucpprq2034393 | wbnvgcuslfyrfnmftxbvcacip | 2034393 |? 495620724 |

| mhpgamjnippf2034394 | ibkjupahutixrkxtupviyloyx | 2034394 | 1953127149 |

| miqeoahbletl2034395 | oqiwrahrwciumjgcjgdxotffv | 2034395 | 1105805537 |

| jirdvgtedlhm2034396 | egoobcxhgjnliehnmecvotykc | 2034396 |? 937016345 |

| rfjyrnfjegnc2034397 | pvofhwlomxuovljuwnsqtcpnr | 2034397 |? 827050972 |

| yvfoaukoarnl2034398 | jamepiqbgpoyikbxbuwcscrsw | 2034398 |?? 40715954 |

| kywxkiywoqgh2034399 | rmyinhvqhwlebegsyfxjewkrf | 2034399 |? 853844136 |

| ovcwevldgylc2034400 | psbdadjixjqvuuufocseywddu | 2034400 | 1837998665 |

| icqtgjpimrnw2034401 | aliqkdofldkgjjepoyfwbxtkh | 2034401 |? 885327661 |

| sudgtftcwehn2034402 | muqycdkgsyfaxjxttifofkwyq | 2034402 | 1603547941 |

| dpxmdmivlkyv2034403 | qtwxtujurdfytkkqldkqskdxw | 2034403 | 1067024161 |

| tivveorbnoxw2034404 | jrdqrybesojdfenicmuxusvbk | 2034404 | 1043402189 |

| eadeyowcfqei2034405 | uwwgcckrkmehmydjcnagndkmt | 2034405 | 2124832757 |

| ryaxhwuedwin2034406 | qscudpvgbxvbelgqaabrybpiy | 2034406 | 1128566462 |

5000000 rows

in set (7 min 1.64 sec)

[root@localhost smacks]# super-smack -d mysql /usr/share/smacks/select-key.smack 10 1000

Query Barrel Report for client smacker

connect: max=5ms? min=4ms avg= 5ms from 10 clients

Query_type????? num_queries???? max_time??????? min_time??????? q_per_s

select_index??? 10000?? 5?????? 0?????? 1205.07

update_index??? 10000?? 2?????? 0?????? 1205.07

原文地址：mysql 高性能壓力測試, 感謝原作者分享。

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

mysql高性能壓力測試

推薦度：

點擊下載本文 文檔為doc格式

標簽：方法過程測試

熱門焦點

国产99久久精品_欧美日本韩国一区二区_激情小说综合网_欧美一级二级视频_午夜av电影_日本久久精品视频

mysql高性能壓力測試

mysql高性能壓力測試

mysql高性能壓力測試

最新推薦

猜你喜歡

熱門推薦