前言：根據業務需要，需測試mysql 性能和壓力測試.

這里我說下測試方法和 測試過程以及測試中出錯的問題

估計很多人 跟我一樣 要測試mysql 的性能 壓力，網上找了很多資料有很多，但是很亂，所以這里我做個總結，拿自己的真實服務器測試的。并且 想測多少數據 都能模擬出來！這里只介紹方法。

MySQL從5.1.4版開始帶有一個壓力測試工具mysqlslap，通過模擬多個并發客戶端訪問
mysql來執行測試。

[root@localhost smacks]# mysql -V mysql 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 引擎

BenchmarkRunning for engine myisamAverage number of seconds to run all queries: 0.638 secondsMinimum number of seconds to run all queries: 0.565 secondsMaximum number of seconds to run all queries: 0.924 secondsNumber of clients running queries: 50Average number of queries per client: 20 BenchmarkRunning for engine myisamAverage number of seconds to run all queries: 0.691 secondsMinimum number of seconds to run all queries: 0.686 secondsMaximum number of seconds to run all queries: 0.696 secondsNumber of clients running queries: 100Average number of queries per client: 10 BenchmarkRunning for engine innodbAverage number of seconds to run all queries: 13.189 secondsMinimum number of seconds to run all queries: 12.886 secondsMaximum number of seconds to run all queries: 13.337 secondsNumber of clients running queries: 50Average number of queries per client: 20 BenchmarkRunning for engine innodbAverage number of seconds to run all queries: 12.449 secondsMinimum number of seconds to run all queries: 12.299 secondsMaximum number of seconds to run all queries: 12.592 secondsNumber of clients running queries: 100Average number of queries per client: 10

這個工具 無法 自己規定 多少數據，所以我后來 有拿了 super smack 工具測試

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

tar zxvf super-smack-1.3.tar.gz cd super-smack-1.3 ./configure --prefix=/usr/local/super-smack-1.3 --with-mysql=/usr/local/mysql/ --with-mysql-lib=/usr/local/mysql/lib/mysql/ --with-mysql-include=/usr/local/mysql/include/mysql/

編譯過程后 make 會報錯

修改 dictionary.h 和 super-smack.cc 增加#include <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/lib configure: error: Could not find mysql.h in ' /usr/include /usr/include/mysql /usr/local/include /usr/local/include/mysql /usr/local/mysql/include' 由于我的mysql是自行編譯的，所以我這樣操作 cd /usr/include; ln -s /usr/local/mysql/include/mysql cd /usr/lib; ln -s /usr/local/mysql/lib/mysql

而且還要修改配置文件

dictionary.h: In member function ‘void Unique_dictionary::set_template(const char*)’: dictionary.h:93:28: error: ‘strlen’ was not declared in this scope super-smack.cc: In function ‘void set_parse_file(char*)’: super-smack.cc:65:55: warning: deprecated conversion from string constant to ‘char*’ super-smack.cc: In function ‘void set_db_type(const char*)’: super-smack.cc:72:48: warning: deprecated conversion from string constant to ‘char*’ super-smack.cc: In function ‘void print_engines()’: super-smack.cc:126:55: error: ‘strlen’ was not declared in this scope make[2]: *** [super-smack.o] 錯誤 1 make[1]: *** [all-recursive] 錯誤 1 make: *** [all-recursive-am] 錯誤 2

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

編譯之前修改文件super-smack-1.3/src/query.cc 第193行：< 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;

這個我是看了相應教程 找了好久才發現的！

make make install

介紹相應參數：

開頭要修改 密碼默認文件

vi select-key.smack

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

改成你所需要的相應密碼

super-smack select-key.smack n m
其中super-smack類似于一個解釋執行器，解釋執行select-key.smack中的內容，n為該次測試的并發線程數，m為每個線程執行數據庫操作的次數

smack文件，類似于一個c源文件，具體包括一下幾個內容

1.clien，定義創建連接用到的參數，包括host，user，passwd，port，socket。包括兩種client，admin client和普通client，admin需要具有管理權限，需要創建表以及load數據等操作

2.表定義，自定義測試表的表結構，需要指定由哪個client創建表，以及表的記錄數，以及填充數據文件的位置，如果數據文件不存在，需要生成數據文件，可以自定義數據生成腳本

3.dictionary，定義了一批可選的字段，源碼實現得比較簡單，只提供了幾種next方法，讀取下一行數據，如果改行數據用逗號分開，只取第一個逗號前的字段，其他符號分隔則取整行數據。所以如果一個查詢里有幾個字段需要從外部獲取數據，就應該創建幾個dictionary

4.查詢，可以自定義查詢的語句，查詢類型(主要用于分類統計的作用)，查詢語句也可以為更新操作，如update。如果是查詢語句，has_result_set選項應該定義為y，否則會出現Commands out of sync錯誤，感覺這里是super-smack的一個bug

5.main，測試運行的入口，一般改動不大，主要是一些client名稱的改動

測試：

gen-data -n 9000 -f %n > words.dat 9000就是數據 你可以改成相應的數值 比如說 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/smackssuper-smack -d mysql /usr/share/smacks/select-key.smack 10 1000

運行命令 開始測試

[root@localhost smacks]# super-smack -d mysql /usr/share/smacks/select-key.smack 10 1000 Query Barrel Report for client smacker connect: max=6ms min=0ms avg= 3ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 10000 3 0 526.21 update_index 10000 9 0 526.21mysql> 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: 0select * 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 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 neededcreate "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 rowsdata_file "words.dat"; // if the table is empty, load the data from //this filegen_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 1000select * 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)[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

結語：因為午休時間寫的，沒有做排版！等有重新整理下博客！

轉載于:https://blog.51cto.com/chenhao6/1314418

總結

以上是生活随笔為你收集整理的mysql 高性能压力测试（总结了好久）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。