mysql 高性能压力测试

php中文网

发布时间：2016-06-07 16:39:49

5712人浏览过

来源于php中文网

原创

这里我说下测试方法和测试过程以及测试中出错的问题估计很多人跟我一样要测试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行：

修改成：

> long len = 0; int num_recs = 0;

第199,200行

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

修改成：

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

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

第219行

修改成：

> 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

124124

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 |

| 4895124124? | 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 |

MVM mall 网上购物系统

采用 php+mysql 数据库方式运行的强大网上商店系统，执行效率高速度快，支持多语言，模板和代码分离，轻松创建属于自己的个性化用户界面 v3.5更新： 1).进一步静态化了活动商品. 2).提供了一些重要UFT-8转换文件 3).修复了除了网银在线支付其它支付显示错误的问题. 4).修改了LOGO广告管理,增加LOGO链接后主页LOGO路径错误的问题 5).修改了公告无法发布的问题,可能是打压

下载

| 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

124124

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 | 1250124124550 |

| 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 | 1241248665491 |

| 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 | 2124124508369 |

| 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 | 1241240726553 |

| 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 | 2124124832757 |

| 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 高性能压力测试, 感谢原作者分享。

mysql中使用SELECT FOR UPDATE进行事务锁定

mysql中访问日志与权限管理的配合使用

mysql字段和列有什么区别_mysql字段类型说明

mysql的InnoDB存储引擎日志与文件优化

mysql权限配置常见错误有哪些_mysql权限问题汇总

数码产品性能查询

该软件包括了市面上所有手机CPU，手机跑分情况，电脑CPU，电脑产品信息等等，方便需要大家查阅数码产品最新情况，了解产品特性，能够进行对比选择最具性价比的商品。

下载