前言：根据业务需要，需测试mysql 性能和压力测试.

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

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

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

mysql来执行测试。

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

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

–auto-generate-sql, -a自动生成测试表和数据–auto-generate-sql-load-type=type测试语句的类型。取值包括：read，key，write，update和mixed(默认)。–number-char-cols=N, -x N自动生成的测试表中包含多少个字符类型的列，默认1–number-int-cols=N, -y N自动生成的测试表中包含多少个数字类型的列，默认1–number-of-queries=N总的测试查询次数(并发客户数×每客户查询次数)–query=name,-q使用自定义脚本执行测试，例如可以调用自定义的一个存储过程或者sql语句来执行测试。–create-schema测试的schema，MySQL中schema也就是database–commint=N多少条DML后提交一次–compress, -C如果服务器和客户端支持都压缩，则压缩信息传递–concurrency=N, -c N并发量，也就是模拟多少个客户端同时执行select。可指定多个值，以逗号或者–delimiter参数指定的值做为分隔符–engine=engine_name, -e engine_name创建测试表所使用的存储引擎，可指定多个–iterations=N, -i N测试执行的迭代次数–detach=N执行N条语句后断开重连–debug-info, -T打印内存和CPU的信息–only-print只打印测试语句而不实际执行

自动生成一条测试用的语句，不用你写sql进行测试

比如这句的结果是(分别测试了并发为50,和100时，总共进行1000次访问花费的时间 )

这里列出了最大、最小、平均值。均为相同的值，因为只进行了一次测试

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

分别 测试 myisam 和 innodb 引擎

Benchmark        Running for engine myisam        Average number of seconds to run all queries: 0.638 seconds        Minimum number of seconds to run all queries: 0.565 seconds        Maximum number of seconds to run all queries: 0.924 seconds        Number of clients running queries: 50        Average number of queries per client: 20Benchmark        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: 10Benchmark        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: 20Benchmark        Running for engine innodb        Average number of seconds to run all queries: 12.449 seconds        Minimum number of seconds to run all queries: 12.299 seconds        Maximum number of seconds to run all queries: 12.592 seconds        Number of clients running queries: 100        Average number of queries per client: 10

这个工具 无法 自己规定 多少数据，所以我后来 有拿了 super smack 工具测试

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

tar zxvf super-smack-1.3.tar.gzcd 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 <string.h>

重点说明一下--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/libconfigure: 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/mysqlcd /usr/lib; ln -s /usr/local/mysql/lib/mysql

而且还要修改配置文件

dictionary.h: In member function ‘void Unique_dictionary::set_template(const char*)’:dictionary.h:93:28: error: ‘strlen’ was not declared in this scopesuper-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 scopemake[2]: *** [super-smack.o] 错误 1make[1]: *** [all-recursive] 错误 1make: *** [all-recursive-am] 错误 2

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

编译之前修改文件super-smack-1.3/src/query.cc第193行：    < int len = 0, num_recs = 0;修改成：    > long len = 0; int num_recs = 0;第199,200行    < int str_len = (*i).first.length();    < if((unsigned)p + str_len + 3 *sizeof(int) < (unsigned)p_end )修改成：    > long str_len = (*i).first.length();    > if((long)p + str_len + 3 *sizeof(int) < (long)p_end )第219行    < len = (unsigned)p - (unsigned)buf;修改成：    > len = (long)p - (long)buf;

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

makemake install

介绍相应参数：

开头要修改 密码默认文件

vi select-key.smack

// this is will be used in the table sectionclient "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方法，读取下一行数据，如果改行数据用逗号分开，只取第一个逗号前的字段，其他符号分隔则取整行数据。所以如果一个查询里有几个字段需要从外部获取数据，就应该创建几个dictionary4.查询，可以自定义查询的语句，查询类型(主要用于分类统计的作用)，查询语句也可以为更新操作，如update。如果是查询语句，has_result_set选项应该定义为y，否则会出现Commands out of sync错误，感觉这里是super-smack的一个bug5.main，测试运行的入口，一般改动不大，主要是一些client名称的改动

测试：

gen-data -n 9000 -f %n > words.dat9000就是数据 你可以改成相应的数值 比如说 5000000

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

把 文件复制过去。

然后进入

[root@localhost bin]# cd /usr/share/smacks/select-key.smack     update-select.smack[root@localhost bin]# cd /usr/share/smacks/[root@localhost smacks]# pwd/usr/share/smacks

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

运行命令 开始测试

[root@localhost smacks]# super-smack -d mysql /usr/share/smacks/select-key.smack 10 1000Query Barrel Report for client smackerconnect: max=6ms  min=0ms avg= 3ms from 10 clientsQuery_type      num_queries     max_time        min_time        q_per_sselect_index    10000   3       0       526.21update_index    10000   9       0       526.21

mysql> alter table http_auth engine innodb;Query OK, 5000000 rows affected (2 min 32.28 sec)Records: 5000000  Duplicates: 0  Warnings: 0mysql> alter table http_auth engine MYISAM;Query OK, 5000000 rows affected (2 min 29.94 sec)Records: 5000000  Duplicates: 0  Warnings: 0

select * from http_auth;| 4895123  | NULL    |   0 |   0 || 4895124  | NULL    |   0 |   0 || 4895125  | NULL    |   0 |   0 || 4895126  | NULL    |   0 |   0 || 4895127  | NULL    |   0 |   0 || 4895128  | NULL    |   0 |   0 || 4895129  | NULL    |   0 |   0 || 489513   | NULL    |   0 |   0 || 4895130  | NULL    |   0 |   0 || 4895131  | NULL    |   0 |   0 || 4895132  | NULL    |   0 |   0 || 4895133  | NULL    |   0 |   0 || 4895134  | NULL    |   0 |   0 || 4895135  | NULL    |   0 |   0 || 4895136  | NULL    |   0 |   0 || 4895137  | NULL    |   0 |   0 || 4895138  | NULL    |   0 |   0 || 4895139  | NULL    |   0 |   0 || 489514   | NULL    |   0 |   0 || 4895140  | NULL    |   0 |   0 || 4895141  | NULL    |   0 |   0 || 4895142  | NULL    |   0 |   0 || 4895143  | NULL    |   0 |   0 || 4895144  | NULL    |   0 |   0 || 4895145  | NULL    |   0 |   0 || 4895146  | NULL    |   0 |   0 || 4895147  | NULL    |   0 |   0 || 4895148  | NULL    |   0 |   0 || 4895149  | NULL    |   0 |   0 || 489515   | NULL    |   0 |   0 || 4895150  | NULL    |   0 |   0 || 4895151  | NULL    |   0 |   0 || 4895152  | NULL    |   0 |   0 || 4895153  | NULL    |   0 |   0 || 4895154  | NULL    |   0 |   0 || 4895155  | NULL    |   0 |   0 || 4895156  | NULL    |   0 |   0 || 4895157  | NULL    |   0 |   0 || 4895158  | NULL    |   0 |   0 || 4895159  | NULL    |   0 |   0 || 489516   | NULL    |   0 |   0 || 4895160  | NULL    |   0 |   0 || 4895161  | NULL    |   0 |   0 || 4895162  | NULL    |   0 |   0 || 4895163  | NULL    |   0 |   0 || 4895164  | NULL    |   0 |   0 || 4895165  | NULL    |   0 |   0 || 4895166  | NULL    |   0 |   0 || 4895167  | NULL    |   0 |   0 || 4895168  | NULL    |   0 |   0 || 4895169  | NULL    |   0 |   0 || 489517   | NULL    |   0 |   0 || 4895170  | NULL    |   0 |   0 || 4895171  | NULL    |   0 |   0 || 4895172  | NULL    |   0 |   0 || 4895173  | NULL    |   0 |   0 || 4895174  | NULL    |   0 |   0 || 4895175  | NULL    |   0 |   0 || 4895176  | NULL    |   0 |   0 || 4895177  | NULL    |   0 |   0 || 4895178  | NULL    |   0 |   0 || 4895179  | NULL    |   0 |   0 || 489518   | NULL    |   0 |   0 || 4895180  | NULL    |   0 |   0 || 4895181  | NULL    |   0 |   0 || 4895182  | NULL    |   0 |   0 || 4895183  | NULL    |   0 |   0 || 4895184  | NULL    |   0 |   0 || 4895185  | NULL    |   0 |   0 || 4895186  | NULL    |   0 |   0 || 4895187  | NULL    |   0 |   0 || 4895188  | NULL    |   0 |   0 || 4895189  | NULL    |   0 |   0 || 489519   | NULL    |   0 |   0 || 4895190  | NULL    |   0 |   0 || 4895191  | NULL    |   0 |   0 || 4895192  | NULL    |   0 |   0 || 4895193  | NULL    |   0 |   0 || 4895194  | NULL    |   0 |   0 || 4895195  | NULL    |   0 |   0 || 4895196  | NULL    |   0 |   0 || 4895197  | NULL    |   0 |   0 || 4895198  | NULL    |   0 |   0 || 4895199  | NULL    |   0 |   0 || 48952    | NULL    |   0 |   0 || 489520   | NULL    |   0 |   0 || 4895200  | NULL    |   0 |   0 || 4895201  | NULL    |   0 |   0 || 4895202  | NULL    |   0 |   0 || 4895203  | NULL    |   0 |   0 || 4895204  | NULL    |   0 |   0 || 4895205  | NULL    |   0 |   0 || 4895206  | NULL    |   0 |   0 || 4895207  | NULL    |   0 |   0 || 4895208  | NULL    |   0 |   0 || 4895209  | NULL    |   0 |   0 || 489521   | NULL    |   0 |   0 || 4895210  | NULL    |   0 |   0 || 4895211  | NULL    |   0 |   0 || 4895212  | NULL    |   0 |   0 || 4895213  | NULL    |   0 |   0 || 4895214  | NULL    |   0 |   0 || 4895215  | NULL    |   0 |   0 || 4895216  | NULL    |   0 |   0 || 4895217  | NULL    |   0 |   0 || 4895218  | NULL    |   0 |   0 || 4895219  | NULL    |   0 |   0 || 489522   | NULL    |   0 |   0 || 4895220  | NULL    |   0 |   0 || 4895221  | NULL    |   0 |   0 || 4895222  | NULL    |   0 |   0 || 4895223  | NULL    |   0 |   0 || 4895224  | NULL    |   0 |   0 || 4895225  | NULL    |   0 |   0 || 4895226  | NULL    |   0 |   0 || 4895227  | NULL    |   0 |   0 || 4895228  | NULL    |   0 |   0 || 4895229  | NULL    |   0 |   0 || 489523   | NULL    |   0 |   0 || 4895230  | NULL    |   0 |   0 || 4895231  | NULL    |   0 |   0 || 4895232  | NULL    |   0 |   0 || 4895233  | NULL    |   0 |   0 || 4895234  | NULL    |   0 |   0 || 4895235  | NULL    |   0 |   0 || 4895236  | NULL    |   0 |   0 || 4895237  | NULL    |   0 |   0 || 4895238  | NULL    |   0 |   0 || 4895239  | NULL    |   0 |   0 || 489524   | NULL    |   0 |   0 || 4895240  | NULL    |   0 |   0 || 4895241  | NULL    |   0 |   0 || 4895242  | NULL    |   0 |   0 || 4895243  | NULL    |   0 |   0 || 4895244  | NULL    |   0 |   0 || 4895245  | NULL    |   0 |   0 || 4895246  | NULL    |   0 |   0 || 4895247  | NULL    |   0 |   0 || 4895248  | NULL    |   0 |   0 || 4895249  | NULL    |   0 |   0 || 489525   | NULL    |   0 |   0 || 4895250  | NULL    |   0 |   0 || 4895251  | NULL    |   0 |   0 || 4895252  | NULL    |   0 |   0 || 4895253  | NULL    |   0 |   0 || 4895254  | NULL    |   0 |   0 || 4895255  | NULL    |   0 |   0 || 4895256  | NULL    |   0 |   0 || 4895257  | NULL    |   0 |   0 || 4895258  | NULL    |   0 |   0 || 4895259  | NULL    |   0 |   0 || 489526   | NULL    |   0 |   0 || 4895260  | NULL    |   0 |   0 || 4895261  | NULL    |   0 |   0 || 4895262  | NULL    |   0 |   0 || 4895263  | NULL    |   0 |   0 || 4895264  | NULL    |   0 |   0 || 4895265  | NULL    |   0 |   0 || 4895266  | NULL    |   0 |   0 || 4895267  | NULL    |   0 |   0 || 4895268  | NULL    |   0 |   0 || 4895269  | NULL    |   0 |   0 || 489527   | NULL    |   0 |   0 || 4895270  | NULL    |   0 |   0 || 4895271  | NULL    |   0 |   0 || 4895272  | NULL    |   0 |   0 || 4895273  | NULL    |   0 |   0 || 4895274  | NULL    |   0 |   0 || 4895275  | NULL    |   0 |   0 || 4895276  | NULL    |   0 |   0 || 4895277  | NULL    |   0 |   0 || 4895278  | NULL    |   0 |   0 || 4895279  | NULL    |   0 |   0 || 489528   | NULL    |   0 |   0 || 4895280  | NULL    |   0 |   0 || 4895281  | NULL    |   0 |   0 || 4895282  | NULL    |   0 |   0 || 4895283  | NULL    |   0 |   0 || 4895284  | NULL    |   0 |   0 || 4895285  | NULL    |   0 |   0 || 4895286  | NULL    |   0 |   0 || 4895287  | NULL    |   0 |   0 || 4895288  | NULL    |   0 |   0 || 4895289  | NULL    |   0 |   0 || 489529   | NULL    |   0 |   0 || 4895290  | NULL    |   0 |   0 || 4895291  | NULL    |   0 |   0 || 4895292  | NULL    |   0 |   0 || 4895293  | NULL    |   0 |   0 || 4895294  | NULL    |   0 |   0 || 4895295  | NULL    |   0 |   0 || 4895296  | NULL    |   0 |   0 || 4895297  | NULL    |   0 |   0 || 4895298  | NULL    |   0 |   0 || 4895299  | NULL    |   0 |   0 || 48953    | NULL    |   0 |   0 || 489530   | NULL    |   0 |   0 || 4895300  | NULL    |   0 |   0 || 4895301  | NULL    |   0 |   0 || 4895302  | NULL    |   0 |   0 || 4895303  | NULL    |   0 |   0 || 4895304  | NULL    |   0 |   0 || 4895305  | NULL    |   0 |   0 || 4895306  | NULL    |   0 |   0 || 4895307  | NULL    |   0 |   0 || 4895308  | NULL    |   0 |   0 || 4895309  | NULL    |   0 |   0 || 489531   | NULL    |   0 |   0 || 4895310  | NULL    |   0 |   0 || 4895311  | NULL    |   0 |   0 || 4895312  | NULL    |   0 |   0 || 4895313  | NULL    |   0 |   0 || 4895314  | NULL    |   0 |   0 || 4895315  | NULL    |   0 |   0 || 4895316  | NULL    |   0 |   0 || 4895317  | NULL    |   0 |   0 || 4895318  | NULL    |   0 |   0 || 4895319  | NULL    |   0 |   0 || 489532   | NULL    |   0 |   0 || 4895320  | NULL    |   0 |   0 || 4895321  | NULL    |   0 |   0 || 4895322  | NULL    |   0 |   0 || 4895323  | NULL    |   0 |   0 |5000000 rows in set (10.72 sec)

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

// ensure the table exists and meets the conditionstable "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 就写到这，因为我也是刚用！慢慢熟悉吧！

根据需要每个列名都要有数据

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

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

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 rowsin set (7 min 1.64 sec)

[root@localhost smacks]# super-smack -d mysql /usr/share/smacks/select-key.smack 10 1000Query Barrel Report for client smackerconnect: max=5ms  min=4ms avg= 5ms from 10 clientsQuery_type      num_queries     max_time        min_time        q_per_sselect_index    10000   5       0       1205.07update_index    10000   2       0       1205.07

结语：因为午休时间写的，没有做排版！等有重新整理下博客！