<span id="mktg5"></span>

<i id="mktg5"><meter id="mktg5"></meter></i>

        <label id="mktg5"><meter id="mktg5"></meter></label>
        最新文章專題視頻專題問答1問答10問答100問答1000問答2000關(guān)鍵字專題1關(guān)鍵字專題50關(guān)鍵字專題500關(guān)鍵字專題1500TAG最新視頻文章推薦1 推薦3 推薦5 推薦7 推薦9 推薦11 推薦13 推薦15 推薦17 推薦19 推薦21 推薦23 推薦25 推薦27 推薦29 推薦31 推薦33 推薦35 推薦37視頻文章20視頻文章30視頻文章40視頻文章50視頻文章60 視頻文章70視頻文章80視頻文章90視頻文章100視頻文章120視頻文章140 視頻2關(guān)鍵字專題關(guān)鍵字專題tag2tag3文章專題文章專題2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章專題3
        問答文章1 問答文章501 問答文章1001 問答文章1501 問答文章2001 問答文章2501 問答文章3001 問答文章3501 問答文章4001 問答文章4501 問答文章5001 問答文章5501 問答文章6001 問答文章6501 問答文章7001 問答文章7501 問答文章8001 問答文章8501 問答文章9001 問答文章9501
        當(dāng)前位置: 首頁 - 科技 - 知識百科 - 正文

        mysql高性能壓力測試

        來源:懂視網(wǎng) 責(zé)編:小采 時間:2020-11-09 13:02:55
        文檔

        mysql高性能壓力測試

        mysql高性能壓力測試:這里我說下測試方法和 測試過程以及測試中出錯的問題 估計很多人 跟我一樣 要測試mysql 的性能 壓力,網(wǎng)上找了很多資料有很多,但是很亂,所以這里我做個總結(jié),拿自己的真實服務(wù)器測試的。并且 想測多少數(shù)據(jù) 都能模擬出來!這里只介紹方法。 MySQL從5.
        推薦度:
        導(dǎo)讀mysql高性能壓力測試:這里我說下測試方法和 測試過程以及測試中出錯的問題 估計很多人 跟我一樣 要測試mysql 的性能 壓力,網(wǎng)上找了很多資料有很多,但是很亂,所以這里我做個總結(jié),拿自己的真實服務(wù)器測試的。并且 想測多少數(shù)據(jù) 都能模擬出來!這里只介紹方法。 MySQL從5.

        這里我說下測試方法和 測試過程以及測試中出錯的問題 估計很多人 跟我一樣 要測試mysql 的性能 壓力,網(wǎng)上找了很多資料有很多,但是很亂,所以這里我做個總結(jié),拿自己的真實服務(wù)器測試的。并且 想測多少數(shù)據(jù) 都能模擬出來!這里只介紹方法。 MySQL從5.1.4版

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

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

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

        1

        2

        [root@localhost smacks]# mysql -V

        mysql? Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86_64) using readline 5.1

        1

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

        1

        2

        3

        4

        5

        6

        7

        8

        9

        10

        11

        12

        13

        14

        15

        16

        17

        18

        19

        20

        21

        22

        23

        24

        25

        26

        27

        28

        29

        30

        –auto-generate-sql, -a

        自動生成測試表和數(shù)據(jù)

        –auto-generate-sql-load-type=type

        測試語句的類型。取值包括:read,key,write,update和mixed(默認(rèn))。

        –number-char-cols=N, -x N

        自動生成的測試表中包含多少個字符類型的列,默認(rèn)1

        –number-int-cols=N, -y N

        自動生成的測試表中包含多少個數(shù)字類型的列,默認(rèn)1

        –number-of-queries=N

        總的測試查詢次數(shù)(并發(fā)客戶數(shù)×每客戶查詢次數(shù))

        –query=name,-q

        使用自定義腳本執(zhí)行測試,例如可以調(diào)用自定義的一個存儲過程或者sql語句來執(zhí)行測試。

        –create-schema

        測試的schema,MySQL中schema也就是database

        –commint=N

        多少條DML后提交一次

        –compress, -C

        如果服務(wù)器和客戶端支持都壓縮,則壓縮信息傳遞

        –concurrency=N, -c N

        并發(fā)量,也就是模擬多少個客戶端同時執(zhí)行select。可指定多個值,以逗號或者–delimiter參數(shù)指定的值做為分隔符

        –engine=engine_name, -e engine_name

        創(chuàng)建測試表所使用的存儲引擎,可指定多個

        –iterations=N, -i N

        測試執(zhí)行的迭代次數(shù)

        –detach=N

        執(zhí)行N條語句后斷開重連

        –debug-info, -T

        打印內(nèi)存和CPU的信息

        –only-print

        只打印測試語句而不實際執(zhí)行

        自動生成一條測試用的語句,不用你寫sql進行測試
        比如這句的結(jié)果是(分別測試了并發(fā)為50,和100時,總共進行1000次訪問花費的時間 )
        這里列出了最大、最小、平均值。均為相同的值,因為只進行了一次測試

        1

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

        分別 測試 myisam 和 innodb 引擎

        1

        2

        3

        4

        5

        6

        7

        8

        9

        10

        11

        12

        13

        14

        15

        16

        17

        18

        19

        20

        21

        22

        23

        24

        25

        26

        27

        28

        Benchmark

        Running for engine myisam

        Average number of seconds to run all queries: 0.638 seconds

        Minimum number of seconds to run all queries: 0.565 seconds

        Maximum number of seconds to run all queries: 0.924 seconds

        Number of clients running queries: 50

        Average number of queries per client: 20

        Benchmark

        Running for engine myisam

        Average number of seconds to run all queries: 0.691 seconds

        Minimum number of seconds to run all queries: 0.686 seconds

        Maximum number of seconds to run all queries: 0.696 seconds

        Number of clients running queries: 100

        Average number of queries per client: 10

        Benchmark

        Running for engine innodb

        Average number of seconds to run all queries: 13.189 seconds

        Minimum number of seconds to run all queries: 12.886 seconds

        Maximum number of seconds to run all queries: 13.337 seconds

        Number of clients running queries: 50

        Average number of queries per client: 20

        Benchmark

        Running for engine innodb

        Average number of seconds to run all queries: 12.449 seconds

        Minimum number of seconds to run all queries: 12.299 seconds

        Maximum number of seconds to run all queries: 12.592 seconds

        Number of clients running queries: 100

        Average number of queries per client: 10

        這個工具 無法 自己規(guī)定 多少數(shù)據(jù),所以我后來 有拿了 super smack 工具測試

        要去網(wǎng)上下載 vegan.net/tony/supersmack/super-smack-1.3.tar.gz

        1

        2

        3

        tar zxvf super-smack-1.3.tar.gz

        cd super-smack-1.3

        ./configure --prefix=/usr/local/super-smack-1.3 --with-mysql=/usr/local/mysql/ --with-mysql-lib=/usr/local/mysql/lib/mysql/ --with-mysql-include=/usr/local/mysql/include/mysql/

        編譯過程后 make 會報錯

        修改 dictionary.h 和 super-smack.cc 增加#include

        1

        2

        3

        4

        5

        6

        7

        重點說明一下--with-mysql的編譯配置:

        編譯的時候要把/usr/lib64目錄下的libmysqlclient.so.16放到/usr/lib目錄下,否則會出現(xiàn)下面的錯誤:

        configure: error: Could not find libmysqlclient in ' /usr/lib /usr/lib/mysql??????????????????? /usr/local/lib /usr/local/lib/mysql??????????????????? /usr/local/mysql/lib

        configure: error: Could not find mysql.h in ' /usr/include /usr/include/mysql??????????????????????? /usr/local/include /usr/local/include/mysql??????????????????????? /usr/local/mysql/include'

        由于我的mysql是自行編譯的,所以我這樣操作

        cd /usr/include; ln -s /usr/local/mysql/include/mysql

        cd /usr/lib; ln -s /usr/local/mysql/lib/mysql

        而且還要修改配置文件

        1

        2

        3

        4

        5

        6

        7

        8

        9

        10

        11

        dictionary.h: In member function ‘void Unique_dictionary::set_template(const char*)’:

        dictionary.h:93:28: error: ‘strlen’ was not declared in this scope

        super-smack.cc: In function ‘void set_parse_file(char*)’:

        super-smack.cc:65:55: warning: deprecated conversion from string constant to ‘char*’

        super-smack.cc: In function ‘void set_db_type(const char*)’:

        super-smack.cc:72:48: warning: deprecated conversion from string constant to ‘char*’

        super-smack.cc: In function ‘void print_engines()’:

        super-smack.cc:126:55: error: ‘strlen’ was not declared in this scope

        make[2]: *** [super-smack.o] 錯誤 1

        make[1]: *** [all-recursive] 錯誤 1

        make: *** [all-recursive-am] 錯誤 2

        要修改相應(yīng)的配置文件才行

        1

        2

        3

        4

        5

        6

        7

        8

        9

        10

        11

        12

        13

        14

        15

        編譯之前修改文件super-smack-1.3/src/query.cc

        第193行:

        < int len = 0, num_recs = 0;

        修改成:

        > long len = 0; int num_recs = 0;

        第199,200行

        < int str_len = (*i).first.length();

        < if((unsigned)p + str_len + 3 *sizeof(int) < (unsigned)p_end )

        修改成:

        > long str_len = (*i).first.length();

        > if((long)p + str_len + 3 *sizeof(int) < (long)p_end )

        第219行

        < len = (unsigned)p - (unsigned)buf;

        修改成:

        > len = (long)p - (long)buf;

        這個我是看了相應(yīng)教程 找了好久才發(fā)現(xiàn)的!

        1

        2

        make

        make install

        介紹相應(yīng)參數(shù):

        開頭要修改 密碼默認(rèn)文件

        1

        vi select-key.smack

        1

        2

        3

        4

        5

        6

        7

        8

        9

        10

        // this is will be used in the table section

        client "client"

        {

        user "admin";

        host "localhost";

        db "test";

        pass "123456";

        socket "/tmp/mysql.sock"; // this only applies to MySQL and is

        // ignored for PostgreSQL

        }

        改成你所需要的相應(yīng)密碼

        super-smack select-key.smack n m
        其中super-smack類似于一個解釋執(zhí)行器,解釋執(zhí)行select-key.smack中的內(nèi)容,n為該次測試的并發(fā)線程數(shù),m為每個線程執(zhí)行數(shù)據(jù)庫操作的次數(shù)

        smack文件,類似于一個c源文件,具體包括一下幾個內(nèi)容

        1.clien,定義創(chuàng)建連接用到的參數(shù),包括host,user,passwd,port,socket。包括兩種client,admin client和普通client,admin需要具有管理權(quán)限,需要創(chuàng)建表以及l(fā)oad數(shù)據(jù)等操作

        2.表定義,自定義測試表的表結(jié)構(gòu),需要指定由哪個client創(chuàng)建表,以及表的記錄數(shù),以及填充數(shù)據(jù)文件的位置,如果數(shù)據(jù)文件不存在,需要生成數(shù)據(jù)文件,可以自定義數(shù)據(jù)生成腳本

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

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

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

        測試:

        1

        2

        gen-data -n 9000 -f %n > words.dat

        9000就是數(shù)據(jù) 你可以改成相應(yīng)的數(shù)值 比如說 5000000

        1

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

        把 文件復(fù)制過去。

        然后進入

        1

        2

        3

        4

        5

        [root@localhost bin]# cd /usr/share/smacks/

        select-key.smack???? update-select.smack

        [root@localhost bin]# cd /usr/share/smacks/

        [root@localhost smacks]# pwd

        /usr/share/smacks

        1

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

        運行命令 開始測試

        1

        2

        3

        4

        5

        6

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

        Query Barrel Report for client smacker

        connect: max=6ms? min=0ms avg= 3ms from 10 clients

        Query_type????? num_queries???? max_time??????? min_time??????? q_per_s

        select_index??? 10000?? 3?????? 0?????? 526.21

        update_index??? 10000?? 9?????? 0?????? 526.21

        1

        2

        3

        4

        5

        6

        mysql> alter table http_auth engine innodb;

        Query OK, 5000000 rows affected (2 min 32.28 sec)

        Records: 5000000? Duplicates: 0? Warnings: 0

        mysql> alter table http_auth engine MYISAM;

        Query OK, 5000000 rows affected (2 min 29.94 sec)

        Records: 5000000? Duplicates: 0? Warnings: 0

        1

        2

        3

        4

        5

        6

        7

        8

        9

        10

        11

        12

        13

        14

        15

        16

        17

        18

        19

        20

        21

        22

        23

        24

        25

        26

        27

        28

        29

        30

        31

        32

        33

        34

        35

        36

        37

        38

        39

        40

        41

        42

        43

        44

        45

        46

        47

        48

        49

        50

        51

        52

        53

        54

        55

        56

        57

        58

        59

        60

        61

        62

        63

        64

        65

        66

        67

        68

        69

        70

        71

        72

        73

        74

        75

        76

        77

        78

        79

        80

        81

        82

        83

        84

        85

        86

        87

        88

        89

        90

        91

        92

        93

        94

        95

        96

        97

        98

        99

        100

        101

        102

        103

        104

        105

        106

        107

        108

        109

        110

        111

        112

        113

        114

        115

        116

        117

        118

        119

        120

        121

        122

        123

        124

        125

        126

        127

        128

        129

        130

        131

        132

        133

        134

        135

        136

        137

        138

        139

        140

        141

        142

        143

        144

        145

        146

        147

        148

        149

        150

        151

        152

        153

        154

        155

        156

        157

        158

        159

        160

        161

        162

        163

        164

        165

        166

        167

        168

        169

        170

        171

        172

        173

        174

        175

        176

        177

        178

        179

        180

        181

        182

        183

        184

        185

        186

        187

        188

        189

        190

        191

        192

        193

        194

        195

        196

        197

        198

        199

        200

        201

        202

        203

        204

        205

        206

        207

        208

        209

        210

        211

        212

        213

        214

        215

        216

        217

        218

        219

        220

        221

        222

        223

        224

        225

        select * from http_auth;

        | 4895123? | NULL??? |?? 0 |?? 0 |

        | 4895124? | NULL??? |?? 0 |?? 0 |

        | 4895125? | NULL??? |?? 0 |?? 0 |

        | 4895126? | NULL??? |?? 0 |?? 0 |

        | 4895127? | NULL??? |?? 0 |?? 0 |

        | 4895128? | NULL??? |?? 0 |?? 0 |

        | 4895129? | NULL??? |?? 0 |?? 0 |

        | 489513?? | NULL??? |?? 0 |?? 0 |

        | 4895130? | NULL??? |?? 0 |?? 0 |

        | 4895131? | NULL??? |?? 0 |?? 0 |

        | 4895132? | NULL??? |?? 0 |?? 0 |

        | 4895133? | NULL??? |?? 0 |?? 0 |

        | 4895134? | NULL??? |?? 0 |?? 0 |

        | 4895135? | NULL??? |?? 0 |?? 0 |

        | 4895136? | NULL??? |?? 0 |?? 0 |

        | 4895137? | NULL??? |?? 0 |?? 0 |

        | 4895138? | NULL??? |?? 0 |?? 0 |

        | 4895139? | NULL??? |?? 0 |?? 0 |

        | 489514?? | NULL??? |?? 0 |?? 0 |

        | 4895140? | NULL??? |?? 0 |?? 0 |

        | 4895141? | NULL??? |?? 0 |?? 0 |

        | 4895142? | NULL??? |?? 0 |?? 0 |

        | 4895143? | NULL??? |?? 0 |?? 0 |

        | 4895144? | NULL??? |?? 0 |?? 0 |

        | 4895145? | NULL??? |?? 0 |?? 0 |

        | 4895146? | NULL??? |?? 0 |?? 0 |

        | 4895147? | NULL??? |?? 0 |?? 0 |

        | 4895148? | NULL??? |?? 0 |?? 0 |

        | 4895149? | NULL??? |?? 0 |?? 0 |

        | 489515?? | NULL??? |?? 0 |?? 0 |

        | 4895150? | NULL??? |?? 0 |?? 0 |

        | 4895151? | NULL??? |?? 0 |?? 0 |

        | 4895152? | NULL??? |?? 0 |?? 0 |

        | 4895153? | NULL??? |?? 0 |?? 0 |

        | 4895154? | NULL??? |?? 0 |?? 0 |

        | 4895155? | NULL??? |?? 0 |?? 0 |

        | 4895156? | NULL??? |?? 0 |?? 0 |

        | 4895157? | NULL??? |?? 0 |?? 0 |

        | 4895158? | NULL??? |?? 0 |?? 0 |

        | 4895159? | NULL??? |?? 0 |?? 0 |

        | 489516?? | NULL??? |?? 0 |?? 0 |

        | 4895160? | NULL??? |?? 0 |?? 0 |

        | 4895161? | NULL??? |?? 0 |?? 0 |

        | 4895162? | NULL??? |?? 0 |?? 0 |

        | 4895163? | NULL??? |?? 0 |?? 0 |

        | 4895164? | NULL??? |?? 0 |?? 0 |

        | 4895165? | NULL??? |?? 0 |?? 0 |

        | 4895166? | NULL??? |?? 0 |?? 0 |

        | 4895167? | NULL??? |?? 0 |?? 0 |

        | 4895168? | NULL??? |?? 0 |?? 0 |

        | 4895169? | NULL??? |?? 0 |?? 0 |

        | 489517?? | NULL??? |?? 0 |?? 0 |

        | 4895170? | NULL??? |?? 0 |?? 0 |

        | 4895171? | NULL??? |?? 0 |?? 0 |

        | 4895172? | NULL??? |?? 0 |?? 0 |

        | 4895173? | NULL??? |?? 0 |?? 0 |

        | 4895174? | NULL??? |?? 0 |?? 0 |

        | 4895175? | NULL??? |?? 0 |?? 0 |

        | 4895176? | NULL??? |?? 0 |?? 0 |

        | 4895177? | NULL??? |?? 0 |?? 0 |

        | 4895178? | NULL??? |?? 0 |?? 0 |

        | 4895179? | NULL??? |?? 0 |?? 0 |

        | 489518?? | NULL??? |?? 0 |?? 0 |

        | 4895180? | NULL??? |?? 0 |?? 0 |

        | 4895181? | NULL??? |?? 0 |?? 0 |

        | 4895182? | NULL??? |?? 0 |?? 0 |

        | 4895183? | NULL??? |?? 0 |?? 0 |

        | 4895184? | NULL??? |?? 0 |?? 0 |

        | 4895185? | NULL??? |?? 0 |?? 0 |

        | 4895186? | NULL??? |?? 0 |?? 0 |

        | 4895187? | NULL??? |?? 0 |?? 0 |

        | 4895188? | NULL??? |?? 0 |?? 0 |

        | 4895189? | NULL??? |?? 0 |?? 0 |

        | 489519?? | NULL??? |?? 0 |?? 0 |

        | 4895190? | NULL??? |?? 0 |?? 0 |

        | 4895191? | NULL??? |?? 0 |?? 0 |

        | 4895192? | NULL??? |?? 0 |?? 0 |

        | 4895193? | NULL??? |?? 0 |?? 0 |

        | 4895194? | NULL??? |?? 0 |?? 0 |

        | 4895195? | NULL??? |?? 0 |?? 0 |

        | 4895196? | NULL??? |?? 0 |?? 0 |

        | 4895197? | NULL??? |?? 0 |?? 0 |

        | 4895198? | NULL??? |?? 0 |?? 0 |

        | 4895199? | NULL??? |?? 0 |?? 0 |

        | 48952??? | NULL??? |?? 0 |?? 0 |

        | 489520?? | NULL??? |?? 0 |?? 0 |

        | 4895200? | NULL??? |?? 0 |?? 0 |

        | 4895201? | NULL??? |?? 0 |?? 0 |

        | 4895202? | NULL??? |?? 0 |?? 0 |

        | 4895203? | NULL??? |?? 0 |?? 0 |

        | 4895204? | NULL??? |?? 0 |?? 0 |

        | 4895205? | NULL??? |?? 0 |?? 0 |

        | 4895206? | NULL??? |?? 0 |?? 0 |

        | 4895207? | NULL??? |?? 0 |?? 0 |

        | 4895208? | NULL??? |?? 0 |?? 0 |

        | 4895209? | NULL??? |?? 0 |?? 0 |

        | 489521?? | NULL??? |?? 0 |?? 0 |

        | 4895210? | NULL??? |?? 0 |?? 0 |

        | 4895211? | NULL??? |?? 0 |?? 0 |

        | 4895212? | NULL??? |?? 0 |?? 0 |

        | 4895213? | NULL??? |?? 0 |?? 0 |

        | 4895214? | NULL??? |?? 0 |?? 0 |

        | 4895215? | NULL??? |?? 0 |?? 0 |

        | 4895216? | NULL??? |?? 0 |?? 0 |

        | 4895217? | NULL??? |?? 0 |?? 0 |

        | 4895218? | NULL??? |?? 0 |?? 0 |

        | 4895219? | NULL??? |?? 0 |?? 0 |

        | 489522?? | NULL??? |?? 0 |?? 0 |

        | 4895220? | NULL??? |?? 0 |?? 0 |

        | 4895221? | NULL??? |?? 0 |?? 0 |

        | 4895222? | NULL??? |?? 0 |?? 0 |

        | 4895223? | NULL??? |?? 0 |?? 0 |

        | 4895224? | NULL??? |?? 0 |?? 0 |

        | 4895225? | NULL??? |?? 0 |?? 0 |

        | 4895226? | NULL??? |?? 0 |?? 0 |

        | 4895227? | NULL??? |?? 0 |?? 0 |

        | 4895228? | NULL??? |?? 0 |?? 0 |

        | 4895229? | NULL??? |?? 0 |?? 0 |

        | 489523?? | NULL??? |?? 0 |?? 0 |

        | 4895230? | NULL??? |?? 0 |?? 0 |

        | 4895231? | NULL??? |?? 0 |?? 0 |

        | 4895232? | NULL??? |?? 0 |?? 0 |

        | 4895233? | NULL??? |?? 0 |?? 0 |

        | 4895234? | NULL??? |?? 0 |?? 0 |

        | 4895235? | NULL??? |?? 0 |?? 0 |

        | 4895236? | NULL??? |?? 0 |?? 0 |

        | 4895237? | NULL??? |?? 0 |?? 0 |

        | 4895238? | NULL??? |?? 0 |?? 0 |

        | 4895239? | NULL??? |?? 0 |?? 0 |

        | 489524?? | NULL??? |?? 0 |?? 0 |

        | 4895240? | NULL??? |?? 0 |?? 0 |

        | 4895241? | NULL??? |?? 0 |?? 0 |

        | 4895242? | NULL??? |?? 0 |?? 0 |

        | 4895243? | NULL??? |?? 0 |?? 0 |

        | 4895244? | NULL??? |?? 0 |?? 0 |

        | 4895245? | NULL??? |?? 0 |?? 0 |

        | 4895246? | NULL??? |?? 0 |?? 0 |

        | 4895247? | NULL??? |?? 0 |?? 0 |

        | 4895248? | NULL??? |?? 0 |?? 0 |

        | 4895249? | NULL??? |?? 0 |?? 0 |

        | 489525?? | NULL??? |?? 0 |?? 0 |

        | 4895250? | NULL??? |?? 0 |?? 0 |

        | 4895251? | NULL??? |?? 0 |?? 0 |

        | 4895252? | NULL??? |?? 0 |?? 0 |

        | 4895253? | NULL??? |?? 0 |?? 0 |

        | 4895254? | NULL??? |?? 0 |?? 0 |

        | 4895255? | NULL??? |?? 0 |?? 0 |

        | 4895256? | NULL??? |?? 0 |?? 0 |

        | 4895257? | NULL??? |?? 0 |?? 0 |

        | 4895258? | NULL??? |?? 0 |?? 0 |

        | 4895259? | NULL??? |?? 0 |?? 0 |

        | 489526?? | NULL??? |?? 0 |?? 0 |

        | 4895260? | NULL??? |?? 0 |?? 0 |

        | 4895261? | NULL??? |?? 0 |?? 0 |

        | 4895262? | NULL??? |?? 0 |?? 0 |

        | 4895263? | NULL??? |?? 0 |?? 0 |

        | 4895264? | NULL??? |?? 0 |?? 0 |

        | 4895265? | NULL??? |?? 0 |?? 0 |

        | 4895266? | NULL??? |?? 0 |?? 0 |

        | 4895267? | NULL??? |?? 0 |?? 0 |

        | 4895268? | NULL??? |?? 0 |?? 0 |

        | 4895269? | NULL??? |?? 0 |?? 0 |

        | 489527?? | NULL??? |?? 0 |?? 0 |

        | 4895270? | NULL??? |?? 0 |?? 0 |

        | 4895271? | NULL??? |?? 0 |?? 0 |

        | 4895272? | NULL??? |?? 0 |?? 0 |

        | 4895273? | NULL??? |?? 0 |?? 0 |

        | 4895274? | NULL??? |?? 0 |?? 0 |

        | 4895275? | NULL??? |?? 0 |?? 0 |

        | 4895276? | NULL??? |?? 0 |?? 0 |

        | 4895277? | NULL??? |?? 0 |?? 0 |

        | 4895278? | NULL??? |?? 0 |?? 0 |

        | 4895279? | NULL??? |?? 0 |?? 0 |

        | 489528?? | NULL??? |?? 0 |?? 0 |

        | 4895280? | NULL??? |?? 0 |?? 0 |

        | 4895281? | NULL??? |?? 0 |?? 0 |

        | 4895282? | NULL??? |?? 0 |?? 0 |

        | 4895283? | NULL??? |?? 0 |?? 0 |

        | 4895284? | NULL??? |?? 0 |?? 0 |

        | 4895285? | NULL??? |?? 0 |?? 0 |

        | 4895286? | NULL??? |?? 0 |?? 0 |

        | 4895287? | NULL??? |?? 0 |?? 0 |

        | 4895288? | NULL??? |?? 0 |?? 0 |

        | 4895289? | NULL??? |?? 0 |?? 0 |

        | 489529?? | NULL??? |?? 0 |?? 0 |

        | 4895290? | NULL??? |?? 0 |?? 0 |

        | 4895291? | NULL??? |?? 0 |?? 0 |

        | 4895292? | NULL??? |?? 0 |?? 0 |

        | 4895293? | NULL??? |?? 0 |?? 0 |

        | 4895294? | NULL??? |?? 0 |?? 0 |

        | 4895295? | NULL??? |?? 0 |?? 0 |

        | 4895296? | NULL??? |?? 0 |?? 0 |

        | 4895297? | NULL??? |?? 0 |?? 0 |

        | 4895298? | NULL??? |?? 0 |?? 0 |

        | 4895299? | NULL??? |?? 0 |?? 0 |

        | 48953??? | NULL??? |?? 0 |?? 0 |

        | 489530?? | NULL??? |?? 0 |?? 0 |

        | 4895300? | NULL??? |?? 0 |?? 0 |

        | 4895301? | NULL??? |?? 0 |?? 0 |

        | 4895302? | NULL??? |?? 0 |?? 0 |

        | 4895303? | NULL??? |?? 0 |?? 0 |

        | 4895304? | NULL??? |?? 0 |?? 0 |

        | 4895305? | NULL??? |?? 0 |?? 0 |

        | 4895306? | NULL??? |?? 0 |?? 0 |

        | 4895307? | NULL??? |?? 0 |?? 0 |

        | 4895308? | NULL??? |?? 0 |?? 0 |

        | 4895309? | NULL??? |?? 0 |?? 0 |

        | 489531?? | NULL??? |?? 0 |?? 0 |

        | 4895310? | NULL??? |?? 0 |?? 0 |

        | 4895311? | NULL??? |?? 0 |?? 0 |

        | 4895312? | NULL??? |?? 0 |?? 0 |

        | 4895313? | NULL??? |?? 0 |?? 0 |

        | 4895314? | NULL??? |?? 0 |?? 0 |

        | 4895315? | NULL??? |?? 0 |?? 0 |

        | 4895316? | NULL??? |?? 0 |?? 0 |

        | 4895317? | NULL??? |?? 0 |?? 0 |

        | 4895318? | NULL??? |?? 0 |?? 0 |

        | 4895319? | NULL??? |?? 0 |?? 0 |

        | 489532?? | NULL??? |?? 0 |?? 0 |

        | 4895320? | NULL??? |?? 0 |?? 0 |

        | 4895321? | NULL??? |?? 0 |?? 0 |

        | 4895322? | NULL??? |?? 0 |?? 0 |

        | 4895323? | NULL??? |?? 0 |?? 0 |

        5000000 rows in set (10.72 sec)

        這樣就能達(dá)到你的效果了,如果你需要改字段

        1

        2

        3

        4

        5

        6

        7

        8

        9

        10

        11

        12

        13

        14

        15

        16

        17

        18

        // ensure the table exists and meets the conditions

        table "http_auth"

        {

        client "client"; // connect with this client

        // if the table is not found or does not pass the checks, create it

        // with the following, dropping the old one if needed

        create "create table http_auth

        (username char(25) not null primary key,

        pass char(25),

        uid integer not null,

        gid integer not null

        )";

        min_rows "5000000"; // the table must have at least that many rows

        data_file "words.dat"; // if the table is empty, load the data from

        //this file

        gen_data_file "gen-data -n 5000000 -f %12-12s%n,%25-25s,%n,%d";

        // if the file above does not exist, generate it with the above command

        }

        直接修改相應(yīng)字段就可以了!這樣測試就方便多了,給大家方便快捷,也能達(dá)到任務(wù)需要!不管多少數(shù)據(jù)都能測試!ok 就寫到這,因為我也是剛用!慢慢熟悉吧!

        根據(jù)需要每個列名都要有數(shù)據(jù)

        1

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

        1

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

        1

        2

        3

        4

        5

        6

        7

        8

        9

        10

        11

        12

        13

        14

        15

        16

        17

        18

        19

        20

        21

        22

        23

        24

        25

        26

        27

        28

        29

        30

        31

        32

        33

        34

        35

        36

        37

        38

        39

        40

        41

        42

        43

        44

        45

        46

        47

        48

        49

        50

        51

        52

        53

        54

        55

        56

        57

        58

        59

        60

        61

        62

        63

        64

        65

        66

        67

        68

        69

        70

        71

        72

        73

        74

        75

        76

        77

        78

        79

        80

        81

        82

        83

        84

        85

        86

        87

        88

        89

        90

        91

        92

        93

        94

        95

        96

        97

        98

        99

        100

        101

        102

        103

        104

        105

        106

        107

        108

        109

        110

        111

        112

        113

        114

        115

        116

        117

        118

        119

        120

        121

        122

        123

        124

        125

        126

        127

        128

        129

        130

        131

        132

        133

        134

        135

        136

        137

        138

        139

        140

        141

        142

        143

        144

        145

        146

        147

        148

        149

        150

        151

        152

        153

        154

        155

        156

        157

        158

        159

        160

        161

        162

        163

        164

        165

        166

        167

        168

        169

        170

        171

        172

        173

        174

        175

        176

        177

        178

        179

        180

        181

        182

        183

        184

        185

        186

        187

        188

        189

        190

        191

        192

        193

        194

        195

        196

        197

        198

        199

        200

        201

        202

        203

        204

        205

        206

        207

        208

        209

        210

        211

        212

        213

        214

        215

        216

        217

        218

        219

        220

        221

        222

        223

        224

        225

        226

        select * from http_auth;

        | aabbevmabgiq2034184 | vvlcduqibaihmmhhqwttywudu | 2034184 |? 674655809 |

        | fxsnoojdtoxk2034185 | wymiibwrinqfjqcfvaqexjtnb | 2034185 | 2096770029 |

        | susqhsptdawa2034186 | ripinabrharxeqiagjgygcpnu | 2034186 | 1683359057 |

        | jxhiabqplgpn2034187 | yypqxvjivrtdqafipcryabjcc | 2034187 | 1641721901 |

        | rohkeijtchpl2034188 | rnelqwlvgbxacacocgpwuyjbi | 2034188 | 1220581668 |

        | umdmxubehtcu2034189 | qkyqmdtorxvjusleuvaridhia | 2034189 |? 886946585 |

        | njerfwegqqjk2034190 | ieiengyymvuoqdtxmukcgovno | 2034190 | 1250124550 |

        | tfsgpbkafxih2034191 | axdwmtbhtpcetkvpykrspkbhm | 2034191 |? 522496211 |

        | jtksbmsfjfbm2034192 | mveqaxcxpbihvasxhfltyxodk | 2034192 |? 992099432 |

        | iumlhchmskmu2034193 | idxtkwtfwemixmhorrvcoknwm | 2034193 |? 241604373 |

        | lgixdsdemodj2034194 | tanhknvrcpmarbmfaadninonj | 2034194 | 1429041942 |

        | txiwhfywokkm2034195 | eocqqtuebwehnowccgvwffvmm | 2034195 | 1057608646 |

        | mbiwnmorgfld2034196 | loarxngvrlcokjvgyicllkkya | 2034196 |??? 7771351 |

        | qghejuulntct2034197 | pvhtkrgiyhsdseqffqhxyoeil | 2034197 | 1340587400 |

        | vyvxvludhhvp2034198 | suwlapsqvajfyivdshfphbpdo | 2034198 | 1907233685 |

        | gyueonbmbcev2034199 | ucwfhvndbhljwukoacagbwnrm | 2034199 | 1409645639 |

        | epslmopjtxhj2034200 | diqqtplhhljhumgkesylkuwwj | 2034200 | 2043058062 |

        | gfmnosyijsax2034201 | ahllqixysdtuqfppcbcjgrywk | 2034201 |?? 63981550 |

        | hvtktvriilqg2034202 | kklhhcmwroxwagqcfdcnyxxvu | 2034202 |? 734650092 |

        | eddwlqjxxqcm2034203 | nwbntetmicpkpojnmehsjnque | 2034203 | 1150298450 |

        | ueraqhwtxsxt2034204 | hivwtlnfbbjjvuwmrdppjhpaq | 2034204 | 1651462539 |

        | vojwjqffnytd2034205 | eugpgdmfpfifutomtgdqwmpgf | 2034205 |? 321945120 |

        | ouuixbfftmkg2034206 | raldiiwwwtfamdoclvwcqtkrx | 2034206 | 1248665491 |

        | yrdjxwlmctuc2034207 | tsvyukekosgnuakgriysaecad | 2034207 |? 913737563 |

        | mgikicfgdask2034208 | mhdvwavhipphirnksrahaitim | 2034208 | 1271873699 |

        | qscjfoskkpkg2034209 | xtxndgitqdltklchvrgmmixra | 2034209 |? 373957541 |

        | ckgotektuqbd2034210 | ktgxnsjsahkjvyttqtkuhqldx | 2034210 |? 820884072 |

        | wsnxxxugviyh2034211 | bconlkmhgfcqclhoohnnabmxb | 2034211 |? 239509809 |

        | gyrggvkwjvjy2034212 | fpghilurcjapacsobtxjsppbn | 2034212 | 1661636625 |

        | axxjyebhnluj2034213 | dwudoughjjbhsvalynlynmkos | 2034213 |?? 90625363 |

        | wgytrdrngiko2034214 | quxtetqefrusrihcaaqyjpsbs | 2034214 |? 416659962 |

        | qcvcsmyrifnb2034215 | msthnlrvprxgqhykltwexsirh | 2034215 | 1626598707 |

        | jqnyrarnjhyb2034216 | dptexklywytuerpmjawusmtmo | 2034216 | 2054494238 |

        | bxxcbdruhsiv2034217 | rfuncbguqrupppclcqcdqairf | 2034217 |? 169891302 |

        | pnuxlpfgdkkl2034218 | fdgcsxrujvnncgpkavmplipwa | 2034218 |??? 5445173 |

        | ffiprnsarnxj2034219 | ijfxxheptflhwwrntrlawtrqj | 2034219 |? 639986363 |

        | qbbommbtkyer2034220 | oxydfvcwjwqwyosqfcgyfiptu | 2034220 |? 416490541 |

        | ohrsyhqxmywo2034221 | vinngmebglemklwbgtrwckpdt | 2034221 | 1305348333 |

        | egjbwgjlvrac2034222 | tgnavyluctptqrgiuarbibcij | 2034222 |? 345011664 |

        | thgtlcdacbbq2034223 | vdmlyefgmdggerkhavxvgerrh | 2034223 | 1909743645 |

        | tlxucuapiavo2034224 | gktorxiehiafggmyyvvuhuqmr | 2034224 | 2041859391 |

        | easaqbkmqelb2034225 | iukldqrrrsnoowjhjbandtnwu | 2034225 | 1017087051 |

        | jnfupqsccvut2034226 | pnpdcgannkopatjqqhrbwyxop | 2034226 |? 627795668 |

        | qtqoogcgjgmm2034227 | tcykryeepxnjbmlbcduuxljos | 2034227 | 1339637838 |

        | uevjqpnrchrj2034228 | njhbvkqhlumgpkucyprvtohne | 2034228 | 1431069995 |

        | fhfyssjawhkn2034229 | qxidfaoacppumljtyprhywgrp | 2034229 | 1394730742 |

        | toygcpfmvmnk2034230 | mraeoopxlrqdbrcjktcgjdpnv | 2034230 | 1777161545 |

        | brhqevigcxvr2034231 | xhlqmmjqwvkbcvgrkcolvxcav | 2034231 |? 847590812 |

        | hxkfslmecbtl2034232 | rshetmbcglfvydvdgspnsdslq | 2034232 | 1788579432 |

        | qskmhefokbdl2034233 | dkykixoeduytksyfgpowkyjrf | 2034233 |? 251755991 |

        | jproevydgheu2034234 | ohrpdckejrvxohwbbctkumayi | 2034234 | 1052924976 |

        | colimcqgrvld2034235 | buuwtlgsoivjusvurgyvwkfjo | 2034235 |?? 75891348 |

        | qgteluyiusub2034236 | mljkwfducwbdsypxkevdlshwn | 2034236 | 1088911032 |

        | gkcdmoqxbode2034237 | jidnlwmcwygtdtmktctcnwhcl | 2034237 | 1702026748 |

        | apogtbqaoewd2034238 | itcpphlcshhmjwlsbxrbpijjj | 2034238 |? 318020452 |

        | lahidpfihupt2034239 | akdhanglghlakblunwwyxgidw | 2034239 | 1904816588 |

        | lgkeakqetqta2034240 | dchqfssqpgnohnvrruffbsled | 2034240 |? 843833878 |

        | kxtexyiiqpdl2034241 | istyhbmftgabmctaixdsxayxy | 2034241 |?? 51410359 |

        | grajdieyhobw2034242 | tuduxrysshsxcsxbqakatklav | 2034242 | 1202732291 |

        | yffacywivvcw2034243 | qwglvievluxywuljwhavphyti | 2034243 |? 686997948 |

        | chvhemenxcxc2034244 | bkayjwvwgsfirurqqbqtindoa | 2034244 | 1534573982 |

        | ebmdfnpfobfl2034245 | xlgfwxcqotripcvstvcayodfc | 2034245 | 1796175795 |

        | ktxpfyelgdmj2034246 | tddolushnmgpnfhskjqxdqpkp | 2034246 | 2124508369 |

        | ywylitqnkdid2034247 | kxqspgywblhrjmlcabxyaxmkt | 2034247 | 1777201503 |

        | xeiihvgaowin2034248 | tkcdenqppstottogfilfouoxq | 2034248 | 1558224570 |

        | yfthvotxrylk2034249 | oediuyfjfmttriqiijgjoatmo | 2034249 |? 843066113 |

        | mjmbvefcoabt2034250 | lhifddptlxdritscjjrvshwpl | 2034250 | 1740413804 |

        | ragswtchyfkq2034251 | bwpeqablekvvgqdggqmarvvqp | 2034251 | 2010978498 |

        | xrglijkxobar2034252 | pecldkcgqlxgnrcjktkklsvuc | 2034252 | 1974232231 |

        | uskvkaconfar2034253 | msdmytgddqxnbjiaeliaeuxrw | 2034253 |? 993131900 |

        | gkggducijbep2034254 | higfxjohlvuuxbpvsnvcaekfb | 2034254 | 1556984087 |

        | qkquaxfifeuv2034255 | ngrkdpltnhjkjjqvrslifcdic | 2034255 |? 115634686 |

        | qhpndfwxpapb2034256 | vekfqvrhsjcetiiyqmkjtcayh | 2034256 |? 620264722 |

        | yywpbttlbkks2034257 | rdewjxftaxgkjcnjbwibwgsac | 2034257 | 1263963412 |

        | ndyxwsddpmew2034258 | geumqhogssecvdiodkdqncrmu | 2034258 |? 560958720 |

        | sliwiqbggrnw2034259 | bipfkniselfhevjvkftdscadu | 2034259 |? 478505153 |

        | jbxybykseuho2034260 | qlcvvgtfffmyihdjlaowcmyfl | 2034260 |? 553638609 |

        | xrehgutitprn2034261 | wwskxetdnfdedhrcmdnlvruep | 2034261 | 2117060364 |

        | njghygeuseym2034262 | hosmsxukcjqpwojssyjgksnky | 2034262 | 2075963369 |

        | fraegjuywnyt2034263 | ybdrsbgdtycdipvxawuhqunxh | 2034263 |? 384434658 |

        | yevyawcdoveu2034264 | yawdgfseducacsvpsfxslwrlt | 2034264 | 1820812969 |

        | olrviqxfwemp2034265 | lslnspiqgcvguhdosakkldivv | 2034265 |? 367627933 |

        | espqlbjyqfoy2034266 | vwdsexajovjaiwfstbbxuqqir | 2034266 |??? 5493428 |

        | hiivketnwaoa2034267 | jdxtfgqkbmocmltetnhbypyjt | 2034267 |? 777952970 |

        | wtunvhrtdycv2034268 | mdjbhvmbairhjqykctgypdplk | 2034268 | 1927246982 |

        | fnijkuovxvrm2034269 | auuregkermaanpddbqmigvtss | 2034269 | 1260089433 |

        | orejegeaxkgk2034270 | oawqalgeqjwetdcpwuxnmfwrl | 2034270 | 1080708728 |

        | tmocwfdwydkf2034271 | jbrghnkjejfewtjwnxahmqmjy | 2034271 | 1401139565 |

        | ixusfhwwnena2034272 | orjvxjpkgeiinuaagyprwnkcu | 2034272 | 2009022832 |

        | ciopldjwbhgq2034273 | roucxjyxliycaxrmamwewlviq | 2034273 | 2010740080 |

        | irpoijegoern2034274 | cdvbhxyylbniiltevkmeeevmn | 2034274 |? 594151402 |

        | scgmskqqnxpo2034275 | abpnjayffxrrcvvxilceqiqjs | 2034275 |? 444742984 |

        | agiruisnxenx2034276 | juvdmaykbkydqpmhbhtdqcvnm | 2034276 |? 982803441 |

        | bkvrkhmincjm2034277 | okynnpfcagmtmdxksmbwyyokj | 2034277 | 1240726553 |

        | swhelwolkfbs2034278 | jbbvunbuxwhcthdktmnolvtxu | 2034278 | 1637029883 |

        | jhpmaaocxlrc2034279 | jsyquuaxftnujbsdynnkxexxg | 2034279 | 1452936814 |

        | cgcuilnjfkgh2034280 | klcahnccsbqiooomoudtehomv | 2034280 | 1991047779 |

        | ybqfkdtmedci2034281 | fulxgaouoestxwcolxukbnslq | 2034281 | 2129550587 |

        | bwrffwdtvjtk2034282 | elqwfqthhghcskrnwlcaitfqr | 2034282 | 1334067658 |

        | kprgcyrtvxms2034283 | hubpytariyfkynhhgbrsqkasl | 2034283 | 1909458292 |

        | ojrecaydrxar2034284 | rktwwunecvfupxhrtslkceohg | 2034284 | 1884534213 |

        | mxompiyjiwfx2034285 | djvleljnffirqlxfuevhcmwtw | 2034285 |? 644741723 |

        | ghwnfbycmgpx2034286 | tvgdpwqpenvcwaqttoucvrres | 2034286 |?? 81426869 |

        | ghaxivvoynnr2034287 | dtfywdynyvetadouhjoptopck | 2034287 | 1017236737 |

        | smaiegcmfyrh2034288 | pqdvnfyeainoxhfolqdgddojl | 2034288 |? 982985142 |

        | vrspbijghylg2034289 | dmpqdpbjgoajvfpmqbepuxfvi | 2034289 | 1081326839 |

        | epnqyqfqkign2034290 | tpetbcbqpsutkrtpqfhuwulvo | 2034290 |? 329761443 |

        | obcxovnssovv2034291 | inqfjbygtplbnkxbjmuxnyveu | 2034291 |? 721932961 |

        | apdxonlfsujt2034292 | bfkogaaebjtvjjugqstskwqyk | 2034292 |? 664486529 |

        | hfbsadxmtemv2034293 | knfgmrsjxjctcpruqcyxkaskf | 2034293 | 1129740466 |

        | wcwlxkygqnxj2034294 | xxucrwrjtjosjyvflbvkdvvcg | 2034294 |? 529267572 |

        | kyliljgglxgg2034295 | karbtdarinshxydvdjsnkevvp | 2034295 |? 418173504 |

        | declmolephjr2034296 | yufucfvhbyqwoddkatqfasqmk | 2034296 |? 142270704 |

        | samcsnyxibge2034297 | ihfbgtfkghgwmgsfudjpdvtvm | 2034297 |? 616358794 |

        | wuudcgmjjveo2034298 | gmxokkwfpriahnxdmkwjiuomb | 2034298 |? 651314328 |

        | vmycchpcvcps2034299 | hfmrhvfiaruwdfrrruxqiwsmf | 2034299 | 1299310210 |

        | qbogwvojnvgv2034300 | ggpcftjancwluflptsbltptso | 2034300 |? 385650008 |

        | dehlanrsrymc2034301 | ycgwqbecqbutoqmikbrphybko | 2034301 |? 270079945 |

        | djtrltttqkww2034302 | opxjkmdyvpcpfjqgtfbwowocq | 2034302 |? 963271711 |

        | vjxuhnlhwxuc2034303 | wsrykwkbffgiexgvawhyjftqu | 2034303 | 1652200405 |

        | xufuwcppdaoo2034304 | buvkfailvklfjunenilnfrldv | 2034304 | 1792470626 |

        | uaejohgmrmmc2034305 | alnlswiidxtrmyjachdwhhjxp | 2034305 | 1167551340 |

        | kjcaodlcqgbc2034306 | phajyoikonrsmccvarmneqnsv | 2034306 | 1036434176 |

        | wpharyhriihr2034307 | uxhnqtrtqrnfhtvuouxlkioeh | 2034307 | 1959118246 |

        | vqhfkcerrulj2034308 | qcefjlyijodjcprqtaprsyadb | 2034308 |? 850369104 |

        | uvbifsnlawxb2034309 | fjrksuannvnfqgeqliuiexqlq | 2034309 | 1751126329 |

        | xqexujjmuejw2034310 | ravffmnmdywahdxborhoklofv | 2034310 | 1010167448 |

        | ssdepwenfkas2034311 | yfuvhebghpaphkbvsyultapmw | 2034311 |?? 82737222 |

        | achbxiisgqyh2034312 | yhyywgladecarvakiyhjcqmay | 2034312 | 1599384070 |

        | uhntomdnnawa2034313 | dcefcydejmdqxfhmhihepxbgk | 2034313 | 1331065654 |

        | vyhsbkuhrygu2034314 | dpjhijopvyagdpegxqlupupqh | 2034314 | 1582937061 |

        | bykhvoxixgrm2034315 | yonywtrbaprlkkibdpoeqbmnr | 2034315 | 1142274212 |

        | xpupfvguxdop2034316 | ephydsjmvoemtvniliujaryho | 2034316 | 2105986756 |

        | dmlreshlrlgd2034317 | acreqnahvnpswrlyaahdosusl | 2034317 |?? 19094930 |

        | efqlkqpdwhsx2034318 | qpliilatkavrdkmbfbgkgwvrp | 2034318 |? 830905088 |

        | wmwpmnhbvsow2034319 | oyylsdxheeikorjmlbcipaadp | 2034319 |? 122577260 |

        | godunrvmfqpe2034320 | xvkjibbrpmurwlrwokhwymtmf | 2034320 | 1346381265 |

        | ykgrqgpbpycq2034321 | srfokcaecqolnpyjceyeqhvin | 2034321 | 1696724986 |

        | jgmoygifusjw2034322 | alnqxdhwmldnptwnckaosofsu | 2034322 |? 323348913 |

        | arjjqjvgcvjl2034323 | sxxxnprkewxgnquslsglkpveb | 2034323 |? 186465969 |

        | kgpurkupijic2034324 | tmbrsojnjugsjtkfxoyiuofmb | 2034324 |? 457289128 |

        | fjmnniapbugm2034325 | isjrlslvalmbvhpewshcctrse | 2034325 | 2118759442 |

        | ifmqtwjeouyc2034326 | tcnidkqvonoxrttjmxdwernao | 2034326 | 1454250248 |

        | ggugiqkyanlq2034327 | jcgyaxuthhrmexetyurfbpnmg | 2034327 | 1835425048 |

        | liowbxyhybft2034328 | uodobhnhemdvtgnkswkgfyfha | 2034328 | 2093719104 |

        | oyhwvcnyrrjh2034329 | yntclplaaewnlcmqlmxdmhakk | 2034329 |?? 43433415 |

        | jehslhihluyw2034330 | ucetprxcikringqpqdfajnvuw | 2034330 |? 392587279 |

        | eiydivfmpweq2034331 | aobraqasiqvnqhbmearijsnrp | 2034331 |? 951275096 |

        | ghsmaubdodto2034332 | vcftsybvnfwfpgbeasciauuds | 2034332 | 1986089846 |

        | ghabyxfgsxfv2034333 | utctbracxcuakxxhdqdjafmbg | 2034333 |? 104338995 |

        | iysnwpjyjltl2034334 | ptpnwcnujqnpanwprdkaefpcx | 2034334 | 1057170075 |

        | djnyvdtnsqqg2034335 | nawbraqppiuakahbefbjpqjlt | 2034335 |? 405298080 |

        | bnvrvluvmmvf2034336 | enqapbawcgdfpsxygsehiccep | 2034336 |? 634693524 |

        | cenaksnbsfeu2034337 | fjbkqqdpslkyuseyytxcbmclf | 2034337 |? 945342893 |

        | oaxsufevpvou2034338 | ljgxleqpdrlevmqyaxtoxtkua | 2034338 |? 132242441 |

        | spmjlattxfxq2034339 | wejkihabgabcrbwevwuookxck | 2034339 |? 624211444 |

        | wlbwcxdnlnvl2034340 | oenrhfselqdhhrrguectpequc | 2034340 | 1573048520 |

        | inigbalprsun2034341 | yjecqmtkuqqwkhbeegymvjtxl | 2034341 | 1077444582 |

        | ngcktbvafoob2034342 | ylssjfamjguksruorgxhmatid | 2034342 |? 635649591 |

        | lifamhmfaxmc2034343 | kwighdaeurnsycvslylykrywy | 2034343 |? 664371313 |

        | eylsdyplhaoh2034344 | ejyrfawbukchjoyinayrykncl | 2034344 | 1546614778 |

        | psfeakqbevbb2034345 | ywnbewqfigfhbgtoigrayxgck | 2034345 | 1420320822 |

        | dqufuveixigq2034346 | pqwuxxbtolchlehrgtrlkmsfj | 2034346 | 1069670447 |

        | qjhycwpbrpcs2034347 | jqeoarshkybcmoqgvadmlnlnk | 2034347 |? 530763128 |

        | rfstafkftlym2034348 | ujnynanhiljmbvcmlmsdtlwus | 2034348 |? 986664760 |

        | cmxbbsnordrh2034349 | katuouqqjegciaqhujrwyrbal | 2034349 |? 725151639 |

        | pfrjndljxbgq2034350 | truawfdpnayhxaaybnpsshcim | 2034350 | 1447927488 |

        | tkqcdlwbntgs2034351 | jvtkgtlisovkhqrjcfyvrqbxe | 2034351 |? 579682048 |

        | ytrfndejpkdd2034352 | sxrqibhcmjhmicfjaljyfbgug | 2034352 | 1789140535 |

        | exwhephxgpaq2034353 | smccbkggvirfjaiqwqdcrblvs | 2034353 | 1931175444 |

        | tclvsgjulkir2034354 | tgbnmknwdnojpgkdefyxhluct | 2034354 | 1114861081 |

        | xfsiamobbdnq2034355 | btgpdvxnccubcdoyflhfqbnsp | 2034355 |? 551188005 |

        | tsikkjeqbhpb2034356 | wtfruiwmjdxrkqubkkggeoqqb | 2034356 | 1329756197 |

        | jcgygfulxqtw2034357 | fgafanvuogfwpjniaogktolau | 2034357 |? 758852282 |

        | lsairfoukoig2034358 | jypovhbjpbyxnunauihgdjouo | 2034358 |? 736209605 |

        | pbtxjfybwuix2034359 | fybgwpbkpvuyexivvyblaxmjd | 2034359 | 1433412386 |

        | lcjtcouewsta2034360 | flvbmcbwxwvajxaxjfluiurkl | 2034360 | 2099058487 |

        | qihminxgqmjr2034361 | jhphjbflbprmmcigmtvgddsns | 2034361 |?? 13165694 |

        | ulggesnvaayi2034362 | laadmmfuvurrbuwvkspfewlkp | 2034362 | 1877184902 |

        | ireharjaxwpf2034363 | tlclddicatupbcopoetxyxhyr | 2034363 | 1706281492 |

        | apqpvkdxygeh2034364 | igdgxhinwwtqwsqhuiyubrmwe | 2034364 | 1635086340 |

        | wdxbnijsoiaw2034365 | xwwtpvpidkrehuvvrbnqgluvt | 2034365 | 1722482229 |

        | plopkophlfgd2034366 | ojniowdmuwpipyvkurrkdibox | 2034366 | 1802222391 |

        | xlxeoooeyfdc2034367 | txbkgtjeeevvrafuofloslthb | 2034367 |? 959931060 |

        | larofloixwch2034368 | bhowfgymdptofmcbvdljgdalq | 2034368 |? 810526764 |

        | vplyyoinmpvn2034369 | dyeyplosmkxauefurvkolxpln | 2034369 | 1444561748 |

        | bcnarsbxurjj2034370 | mxtmxqtfoncycpytborfsifld | 2034370 | 2044857256 |

        | jxatjotgcuwx2034371 | allcmqsokvdfdwpkksttttpdl | 2034371 | 1880378035 |

        | lpfjnfwykmrf2034372 | bddgkhfarpulmoicutogjvrye | 2034372 |? 628291917 |

        | aqesvhxynigv2034373 | kblhmayudtotcaswywocpuulc | 2034373 |? 433188595 |

        | mrftnpucwjev2034374 | fjrvewwwtxvkalfwyjrldwhto | 2034374 | 2052337052 |

        | xoocmtmhrqeo2034375 | papnkrbrpadjngjvaxaaoodck | 2034375 | 1259233165 |

        | jdiptarjpeeq2034376 | vtsbfghoeknfkevpghfrkpjgp | 2034376 |? 463349276 |

        | qffuxdqqevao2034377 | ngybnlhkeotligcsmttfaccaf | 2034377 |?? 15668845 |

        | tkrtyfcaiqnp2034378 | drgwerdgkragxciafovyypuaw | 2034378 |? 866656097 |

        | ahnnyqiipmau2034379 | uknwsnccphsngrfbtcatlojnh | 2034379 | 1033075892 |

        | vagvubikybxb2034380 | fqkxeqrktlothdkrqujmuqirt | 2034380 |? 288215768 |

        | dutdvaviadys2034381 | nueepojagawrmrkwmfpramwyo | 2034381 | 1009454519 |

        | howjhmeosvdd2034382 | yldvdsqqrdvkuxwrylnjcksmy | 2034382 |? 608896849 |

        | dsvgvutbqwtj2034383 | pmmnwjmvcnjrwldrxcrbwnjsk | 2034383 | 2076206953 |

        | uddqnudajckx2034384 | xolhgjvlbvquankjjupgbuwop | 2034384 | 1147177003 |

        | qbhdygtlpdwn2034385 | oakhvkxgvhenpfkotdrmeaqei | 2034385 | 1457917985 |

        | panoofoymklk2034386 | thtxxldibylslquewdroefdsm | 2034386 | 1410265942 |

        | taffmyojymue2034387 | vvfjrscmxyspnywsrklnmssbt | 2034387 |? 101228059 |

        | kswiyugeexwh2034388 | nuigmyfmrywfmlxhmrqampklk | 2034388 | 1511272966 |

        | pprpyfmjnaiu2034389 | mdtliiyjrndkpqbaeltwdlmes | 2034389 | 1103835449 |

        | ogbwbpawdlhc2034390 | wyqajgsmjayfweqjjlkxrmwuc | 2034390 | 1760561700 |

        | tgnbkkcbmnkg2034391 | bvgcbditorfyrynrvqtryhsjt | 2034391 | 1342964022 |

        | ngmaonvwryab2034392 | squaspyghuwdmxmhkggxosxej | 2034392 | 1696821921 |

        | bdwegpucpprq2034393 | wbnvgcuslfyrfnmftxbvcacip | 2034393 |? 495620724 |

        | mhpgamjnippf2034394 | ibkjupahutixrkxtupviyloyx | 2034394 | 1953127149 |

        | miqeoahbletl2034395 | oqiwrahrwciumjgcjgdxotffv | 2034395 | 1105805537 |

        | jirdvgtedlhm2034396 | egoobcxhgjnliehnmecvotykc | 2034396 |? 937016345 |

        | rfjyrnfjegnc2034397 | pvofhwlomxuovljuwnsqtcpnr | 2034397 |? 827050972 |

        | yvfoaukoarnl2034398 | jamepiqbgpoyikbxbuwcscrsw | 2034398 |?? 40715954 |

        | kywxkiywoqgh2034399 | rmyinhvqhwlebegsyfxjewkrf | 2034399 |? 853844136 |

        | ovcwevldgylc2034400 | psbdadjixjqvuuufocseywddu | 2034400 | 1837998665 |

        | icqtgjpimrnw2034401 | aliqkdofldkgjjepoyfwbxtkh | 2034401 |? 885327661 |

        | sudgtftcwehn2034402 | muqycdkgsyfaxjxttifofkwyq | 2034402 | 1603547941 |

        | dpxmdmivlkyv2034403 | qtwxtujurdfytkkqldkqskdxw | 2034403 | 1067024161 |

        | tivveorbnoxw2034404 | jrdqrybesojdfenicmuxusvbk | 2034404 | 1043402189 |

        | eadeyowcfqei2034405 | uwwgcckrkmehmydjcnagndkmt | 2034405 | 2124832757 |

        | ryaxhwuedwin2034406 | qscudpvgbxvbelgqaabrybpiy | 2034406 | 1128566462 |

        5000000 rows

        in set (7 min 1.64 sec)

        1

        2

        3

        4

        5

        6

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

        Query Barrel Report for client smacker

        connect: max=5ms? min=4ms avg= 5ms from 10 clients

        Query_type????? num_queries???? max_time??????? min_time??????? q_per_s

        select_index??? 10000?? 5?????? 0?????? 1205.07

        update_index??? 10000?? 2?????? 0?????? 1205.07

        聲明:本網(wǎng)頁內(nèi)容旨在傳播知識,若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

        文檔

        mysql高性能壓力測試

        mysql高性能壓力測試:這里我說下測試方法和 測試過程以及測試中出錯的問題 估計很多人 跟我一樣 要測試mysql 的性能 壓力,網(wǎng)上找了很多資料有很多,但是很亂,所以這里我做個總結(jié),拿自己的真實服務(wù)器測試的。并且 想測多少數(shù)據(jù) 都能模擬出來!這里只介紹方法。 MySQL從5.
        推薦度:
        標(biāo)簽: 方法 過程 測試
        • 熱門焦點

        最新推薦

        猜你喜歡

        熱門推薦

        專題
        Top
        主站蜘蛛池模板: 真实乱视频国产免费观看| 久久久青草青青亚洲国产免观| 免费在线观看视频a| 亚洲视频在线播放| 添bbb免费观看高清视频| 一级黄色毛片免费看| 午夜视频免费观看| 亚洲AV无码一区二区三区在线 | 久久久精品免费视频| 免费人成激情视频在线观看冫 | 四虎成人免费网站在线| 又长又大又粗又硬3p免费视频| 四虎免费大片aⅴ入口| 一本久久A久久免费精品不卡| 久久亚洲精品国产精品| 中文精品人人永久免费 | 亚洲国产精品99久久久久久| 成年轻人网站色免费看| 亚洲人成人77777在线播放| 18禁美女裸体免费网站 | 亚洲午夜在线播放| 久久久久久精品免费看SSS| 亚洲白嫩在线观看| 人妻视频一区二区三区免费| 亚洲色大成WWW亚洲女子| 最近2019中文字幕mv免费看| 中国一级特黄的片子免费| 亚洲AV综合色区无码一区爱AV | 永久免费观看的毛片的网站| 男人的天堂网免费网站| 黄色免费网站在线看| 亚洲jizzjizz在线播放久| 亚洲成a人片在线观看日本| 亚洲AV伊人久久青青草原| 黄页网址在线免费观看| 亚洲1234区乱码| 午夜影视日本亚洲欧洲精品一区| 永久黄色免费网站| 国产在线播放线91免费| 又大又硬又粗又黄的视频免费看 | 亚洲欧美国产精品专区久久|