首页
课程
路径
文章
PHP培训
精品课
下载

技术文章  >  数据库 > mysql教程

mysql 高性能压力测试

原创
2016-06-07 16:39:49 3391浏览

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

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

–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 引擎

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

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

1

2

3

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

1

2

3

4

5

6

7

重点说明一下--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

而且还要修改配置文件

1

2

3

4

5

6

7

8

9

10

11

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

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

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

编译之前修改文件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

1

2

3

4

5

6

7

8

9

10

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

把 文件复制过去。

然后进入

1

2

3

4

5

[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

运行命令 开始测试

1

2

3

4

5

6

[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

1

2

3

4

5

6

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

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

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)

这样就能达到你的效果了，如果你需要改字段

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

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

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

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)

1

2

3

4

5

6

[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 高性能 压力 测试 这里 我说 测试 方法 过程PHP课程HTML视频教程CSS视频JS视频教程Vue视频教程
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。
上一条：MySQL字符集的一个坑 下一条：Python访问MySQL封装的常用类

相关文章

查看更多
  • 热门课程
打开APP，随时随地在线学习！