mysql 高性能压力测试

这里我说下测试方法和 测试过程以及测试中出错的问题 估计很多人 跟我一样 要测试mysql 的性能 压力，网上找了很多资料有很多，但是很乱，所以这里我做个总结，拿自己的真实服务器测试的。并且 想测多少数据 都能模拟出来！这里只介绍方法。 MySQL从5.1.4版

这里我说下测试方法和 测试过程以及测试中出错的问题

估计很多人 跟我一样 要测试mysql 的性能 压力，网上找了很多资料有很多，但是很乱，所以这里我做个总结，拿自己的真实服务器测试的。并且 想测多少数据 都能模拟出来！这里只介绍方法。

MySQL从5.1.4版开始带有一个压力测试工具mysqlslap，通过模拟多个并发客户端访问
mysql来执行测试。

1 2	[root@localhost smacks]# mysql -V mysql? Ver 14.14Distrib 5.1.69, forredhat-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 forengine 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 forengine 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 forengine 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 forengine 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

tarzxvf super-smack-1.3.tar.gz cdsuper-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 inthis 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 inthis 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行： 修改成： > long len = 0; int num_recs = 0; 第199,200行 <code>if((unsigned)p + str_len + 3 *sizeof(int) 修改成： > long str_len = (*i).first.length(); > <code>if((long)p + str_len + 3 *sizeof(int) 第219行 修改成： > len = (long)p - (long)buf;

这个我是看了相应教程 找了好久才发现的！

1 2	make makeinstall

介绍相应参数：

开头要修改 密码默认文件

1	viselect-key.smack

1 2 3 4 5 6 7 8 9 10

//this is will be used inthe table section client "client" { user "admin"; host "localhost"; db "test"; pass "123456"; socket "/tmp/mysql.sock"; //this only applies to MySQL and is //ignored forPostgreSQL }

改成你所需要的相应密码

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	cpwords.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 forclient 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 inset(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 //the table is not found or does not pass the checks, create it //with the following, dropping the old one <code>ifneeded 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"; //the table is empty, load the data from //thisfile gen_data_file "gen-data -n 5000000 -f %12-12s%n,%25-25s,%n,%d"; //the fileabove 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 inset(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 forclient 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 高性能压力测试, 感谢原作者分享。