搜索
热门搜索 :
考研考公
首页 热点资讯 义务教育 高等教育 出国留学 考研考公
您的当前位置：首页正文

mysql高性能压力测试

2020-11-09 来源：伴沃教育

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

1、填充测试数据比物理内存还要大，至少超过innodb_buffer_pool_size 值，不能将数据全部装载到内存中，除非你的本意就想测试全内存状态下的MySQL性能。2、每轮测试完成后，都重启mysqld实例，并且用下面的方法删除系统cache，释放swap（如果用到了swap的话），甚至可以重启整个OS。[root@imysql.com]# ...

如何使用MySQL自带的性能压力测试工具mysqlslap

方法/步骤 使用--auto-generate-sql参数表示用mysqlslap工具自己生成的SQL脚本来测试并发压力 mysqlslap --auto-generate-sql -uroot -p123456 并发测试，使用–concurrency来模拟并发连接，连接数可以多个，用逗号隔开 mysqlslap --auto-generate-sql --concurrency=100 -uroot -p123456 mysqlslap --auto...

如何使用MySQL自带的性能压力测试工具mysqlslap

--query=name,-q 使用自定义脚本执行测试，例如可以调用自定义的一个存储过程或者sql语句来执行测试。--create-schema 代表自定义的测试库名称，测试的schema，MySQL中schema也就是database。--commint=N 多少条DML后提交一次。--compress, -C 如果服务器和客户端支持都压缩，则压缩信息传递。--concurre...

如何测试mysql的性能和稳定性

应该在MySQL 4.1或者更新的版本中都可以使用。测试时可以执行并发连接数，并指定SQL 语句（可以在命令行上执行，也可以把SQL 语句写入到参数文件中）。如果没有指定SQL 语句，mysqlslap 会自动生成查询schema 的SELECT 语句。

如何使用MySQL自带的性能压力测试工具mysqlslap

如何使用MySQL自带的性能压力测试工具mysqlslap 首先mysql/bin 目录里应该有mysqlslap.exe,我的版本是 5.5.11，里面是有这玩意的 在执行之前需要在mysql里建一个mysqlslap的database use mysqlslap 然后建表news，classify输数据... 在命令行里输入: C:\Program Files\MySQL\MySQL Server 5.5\.

如何使用MySQL自带的性能压力测试工具mysqlslap

使用语法如下：mysqlslap [options]常用参数 [options] 详细说明：--auto-generate-sql, -a 自动生成测试表和数据，表示用mysqlslap工具自己生成的SQL脚本来测试并发压力。--auto-generate-sql-load-type=type 测试语句的类型。代表要测试的环境是读操作还是写操作还是两者混合的。取值包括：read，key，...

高性能MySQL:集成式测试工具

JMeter 比ab 和_load 都要复杂得多 例如 它可以通过控制预热时间等参数 更加灵活地模拟真实用户的访问 JMeter 拥有绘图接口（带有内置的图形化处理的功能） 还可以对测试进行记录 然后离线重演测试结果 更多信息请参考//jakarta apache /jmeter/ 返回目录 高性能MySQL 编辑推荐 ASP NET开发培训视频教程 ...

如何使用MySQL自带的性能压力测试工具mysqlslap

1 使用--auto-generate-sql参数表示用mysqlslap工具自己生成的SQL脚本来测试并发压力 mysqlslap --auto-generate-sql -uroot -p123456 2 并发测试，使用–concurrency来模拟并发连接，连接数可以多个，用逗号隔开 mysqlslap --auto-generate-sql ...

如何用mysqlslap进行压力测试

压力测试工具mysqlslap 使用帮助--help介绍的很详细，下面是一些常用的选项。根据帮助文档就可以自己敲命令进行压力测试了。--concurrency代表并发数量，多个可以用逗号隔开，当然你也可以用自己的分隔符隔开，这个时候要用到--delimiter开关。--engines代表要测试的引擎，可以有多个，用分隔符隔开。--...

mysql 开启binlog 影响性能吗

第二步：进行压力测试。sysbench --mysql-host=192.168.100.10 --mysql-port=3306 --mysql-user=sysbench \--mysql-password=sysbench --tables=120 --table_size=100000 --mysql-db=tempdb \--time=3600 --threads=240 oltp_point_select run 性能表现。资源消耗情况。结论 开启 binlog 压缩...

猜你还关注

Copyright © 2019- bangwoyixia.com 版权所有
湘ICP备2023022004号-2

Top