MyCat性能测试案例.docx

MyCAT性能测试案例
测试案例一：
硬件；HP ZooK，8核心CPU，16G内存。

Mycat 版本 1.2 （SVN 445），默认参数，日志级别Info
操作系统 windows 7 64
Java环境：JDK 7
Mysql 版本mysql-5.6.13-winx64
Mysql 参数
[mysqld]
max_connections =1000
innodb_buffer_pool_size=4G
#innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=0
innodb_autoextend_increment=1G
innodb_log_file_size=256M
分片表配置（3个分片，在一个mysql 实例上）
# range start-end ,data node index
# K=1000,M=10000.
0-500M=0
500M-1000M=1
1000M-1500M=2
测试标准插入1500万数据，100并发线程，最终TPS为17432。
jdbc:mysql://localhost:8066/TESTDB test test 100 "0-500M,500M1-1000M,1000M1-1400M"
create jobs ...
success ful created connections ,total :100
create jobs finished ,begin run test...
success create job count: 14000 teset threads: 100
11 14:26:38 finished records :0 failed:0 speed:0.0
11 14:26:39 finished records :10908 failed:0 speed:8629.746835443038
11 14:26:40 finished records :11413 failed:0 speed:5038.852097130243
11 14:26:41 finished records :26159 failed:0 speed:8009.4917330067365
11 14:26:42 finished records :53530 failed:0 speed:12548.054383497421
11 14:26:43 finished records :78974 failed:0 speed:14994.114296563508
11 14:26:44 finished records :114310 failed:0 speed:18234.16812888818
11 14:26:45 finished records :141269 failed:0 speed:19434.447654422893
11 14:26:46 finished records :171338 failed:0 speed:20715.512029984282
11 14:26:47 finished records :196379 failed:0 speed:21182.07313126955
11 14:26:48 finished records :219441 failed:0 speed:21365.105637231038
11 14:26:49 finished records :238269 failed:0 speed:21140.005323396326
11 14:26:50 finished records :273197 failed:0 speed:22263.629696031294
11 14:26:51 finished records :309299 failed:0 speed:23306.382337427473
11 14:26:52 finished records :324784 failed:0 speed:22758.321070702823
11 14:26:53 finished records :351056 failed:0 speed:22986.9041382923
11 14:26:54 finished records :362197 failed:0 speed:22258.911012782693
11 14:26:55 finished records :391662 failed:0 speed:22673.497742271622
11 14:26:56 finished records :413784 failed:0 speed:22639.60168517809
11 14:26:57 finished records :435309 failed:0 speed:22581.78139752036
11 14:26:58 finished records :464288 failed:0 speed:22897.272772106327
11 14:26:59 finished records :494561 failed:0 speed:23240.648496240603
11 14:27:00 finished records :502410 failed:0 speed:22549.820466786354
11 14:27:01 finished records :514067 failed:0 speed:22080.96731240067
11 14:27:02 finished records :548450 failed:0 speed:22587.619949754953
11 14:27:03 finished records :582390 failed:0 speed:23036.667853328585
11 14:27:04 finished records :607036 failed:0 speed:23097.024579560155
11 14:27:05 finished records :627743 failed:0 speed:23007.733470165665
11 14:27:06 finished records :661228 failed:0 speed:23372.11439884046
11 14:27:07 finished records :691299 failed:0 speed:23604.29542117663
11 14:27:08 finished records :702107 failed:0 speed:23181.794169115463
11 14:27:09 finished records :725410 failed:0 speed:23181.963441135114
11 14:27:10 finished records :735844 failed:0 speed:22787.191874148397
11 14:27:11 finished records :749733 failed:0 speed:22519.914694220835
11 14:27:12 finished records :766561 failed:0 speed:22353.930945993234
11 14:27:13 finished records :783349 failed:0 speed:22196.220106539724
11 14:27:14 finished records :794470 failed:0 speed:21891.050369227378
11 14:27:15 finished records :814713 failed:0 speed:21846.857234795665
11 14:27:16 finished records :848622 failed:0 speed:22161.282740970935
11 14:27:17 finished records :870834 failed:0 speed:22162.009467094213
11 14:27:18 finished records :888461 failed:0 speed:22048.91425735203
11 14:27:19 finished records :917319 failed:0 speed:22213.265207284
11 14:27:20 finished records :947460 failed:0 speed:22400.699829771136
11 14:27:21 finished records :973319 failed:0 speed:22480.575572801183
11 14:27:22 finished records :983834 failed:0 speed:22204.432608106887
11 14:27:23 finished records :1008703 failed:0 speed:22262.751329757884
11 14:27:24 finished records :1024218 failed:0 speed:22117.03988425576
11 14:27:25 finished records :1041733 failed:0 speed:22015.575468109386
11 14:27:26 finished records :1072460 failed:0 speed:22195.409673213435
11 14:27:27 finished records :1102339 failed:0 speed:22351.20339017417
11 14:27:28 finished records :1132632 failed:0 speed:22508.585055643878
11 14:27:29 finished records :1132632 failed:0 speed:22069.992205767732
11 14:27:30 finished records :1152117 failed:0 speed:22020.58486238532
11 14:27:31 finished records :1177561 failed:0 speed:22084.789947486872
11 14:27:32 finished records :1202844 failed:0 speed:22143.667157584685
11 14:27:33 finished records :1220723 failed:0 speed:22066.576283441795
11 14:27:34 finished records :1245612 failed:0 speed:22116.690340909092
11 14:27:35 finished records :1267511 failed:0 speed:22112.892533147242
11 14:27:36 finished records :1278763 failed:0 speed:21926.287272166115
11 14:27:37 finished records :1307319 failed:0 speed:22038.047234537516
11 14:27:38 finished records :1337147 failed:0 speed:22167.188872863513
11 14:27:39 finished records :1355188 failed:0 speed:22099.90052347483
11 14:27:40 finished records :1368471 failed:0 speed:21958.424928996646
11 14:27:41 finished records :1375259 failed:0 speed:21718.84524881161
11 14:27:42 finished records :1396753 failed:0 speed:21715.011971020802
11 14:27:43 finished records :1419501 failed:0 speed:21730.825755488197
11 14:27:44 finished records :1437420 failed:0 speed:21673.35122583758
11 14:27:45 finished records :1440410 failed:0 speed:21395.82900092095
11 14:27:46 finished records :1471056 failed:0 speed:21530.904673389636
11 14:27:47 finished records :1492582 failed:0 speed:21530.83392236343
11 14:27:48 finished records :1503925 failed:0 speed:21385.961918575715
11 14:27:49 finished records :1530864 failed:0 speed:21463.518591217544
11 14:27:50 finished records :1544026 failed:0 speed:21348.736242464467
11 14:27:51 finished records :1581157 failed:0 speed:21563.976324259453
11 14:27:52 finished records :1585036 failed:0 speed:21326.031968139498
11 14:27:53 finished records :1613734 failed:0 speed:21423.902076363443
11 14:27:54 finished records :1637824 failed:0 speed:21458.83339447618
11 14:27:55 finished records :1668520 failed:0 speed:21578.293932026278
11 14:27:56 finished records :1689672 failed:0 speed:21570.372639883575
11 14:27:57 finished records :1707774 failed:0 speed:21526.11079599168
11 14:27:58 finished records :1723926 failed:0 speed:21458.947420832505
11 14:27:59 finished records :1738865 failed:0 speed:21378.7867610898
11 14:28:00 finished records :1744016 failed:0 speed:21181.437263927517
11 14:28:01 finished records :1774348 failed:0 speed:21290.983704912524
11 14:28:02 finished records :1797359 failed:0 speed:21311.378026512368
11 14:28:03 finished records :1827815 failed:0 speed:21418.284723280096
11 14:28:04 finished records :1838683 failed:0 speed:21295.84201992124
11 14:28:05 finished records :1838885 failed:0 speed:21053.122674451886
11 14:28:06 finished records :1862744 failed:0 speed:21084.644466076563
11 14:28:07 finished records :1878794 failed:0 speed:21028.2944955566
11 14:28:08 finished records :1896975 failed:0 speed:20996.77904943218
11 14:28:09 finished records :1917652 failed:0 speed:20993.278304468724
11 14:28:10 finished records :1939703 failed:0 speed:21001.77567968471
11 14:28:11 finished records :1961188 failed:0 speed:21005.151713132047
11 14:28:12 finished records :1982855 failed:0 speed:21011.274650051393
11 14:28:13 finished records :2000723 failed:0 speed:20978.316259659645
11 14:28:14 finished records :2016087 failed:0 speed:20920.058938892405
11 14:28:15 finished records :2033197 failed:0 speed:20880.286318729846
11 14:28:16 finished records :2059501 failed:0 speed:20934.994307554687
11 14:28:17 finished records :2085440 failed:0 speed:20985.348575108677
11 14:28:18 finished records :2097046 failed:0 speed:20891.90643181637
11 14:28:19 finished records :2120359 failed:0 speed:20914.963503649637
11 14:28:20 finished records :2154339 failed:0 speed:21042.576675131862
11 14:28:21 finished records :2168268 failed:0 speed:20973.76668601277
11 14:28:22 finished records :2171167 failed:0 speed:20800.60356390113
11 14:28:23 finished records :2188915 failed:0 speed:20771.635984057695
11 14:28:24 finished records :2215390 failed:0 speed:20825.249106974996
11 14:28:25 finished records :2244632 failed:0 speed:20903.437293375922
11 14:28:26 finished records :2265258 failed:0 speed:20900.49177454029
11 14:28:27 finished records :2295885 failed:0 speed:20988.645817144632
11 14:28:28 finished records :2304754 failed:0 speed:20878.286076637378
11 14:28:29 finished records :2335127 failed:0 speed:20962.959970554704
11 14:28:30 finished records :2355359 failed:0 speed:20956.083455669737
11 14:28:31 finished records :2377976 failed:0 speed:20970.54569826096
11 14:28:32 finished records :2398551 failed:0 speed:20966.90472652255
11 14:28:33 finished records :2420723 failed:0 speed:20977.165982079412
11 14:28:34 finished records :2447662 failed:0 speed:21028.385367446175
11 14:28:35 finished records :2470895 failed:0 speed:21047.164346922436
11 14:28:36 finished records :2483521 failed:0 speed:20975.861282612183
11 14:28:37 finished records :2504632 failed:0 speed:20976.99310714495
11 14:28:38 finished records :2514309 failed:0 speed:20883.13856427379
11 14:28:39 finished records :2536117 failed:0 speed:20890.756925510093
11 14:28:40 finished records :2566460 failed:0 speed:20967.81045751634
11 14:28:41 finished records :2584440 failed:0 speed:20943.598055105347
11 14:28:42 finished records :2600955 failed:0 speed:20907.99839228296
11 14:28:43 finished records :2619541 failed:0 speed:20889.481658692184
11 14:28:44 finished records :2635754 failed:0 speed:20851.98927240651
11 14:28:45 finished records :2653633 failed:0 speed:20828.163508782945
11 14:28:46 finished records :2675521 failed:0 speed:20836.255032825313
11 14:28:47 finished records :2692076 failed:0 speed:20803.17138949207
11 14:28:48 finished records :2708813 failed:0 speed:20771.990767366784
11 14:28:49 finished records :2728299 failed:0 speed:20761.572471102114
11 14:28:50 finished records :2755218 failed:0 speed:20808.074857829033
11 14:28:51 finished records :2766178 failed:0 speed:20734.25729512559
11 14:28:52 finished records :2790056 failed:0 speed:20757.646323589586
11 14:28:53 finished records :2804096 failed:0 speed:20708.03701324117
11 14:28:54 finished records :2816743 failed:0 speed:20648.943267038583
11 14:28:55 finished records :2833107 failed:0 speed:20617.759859108806
11 14:28:56 finished records :2854420 failed:0 speed:20622.63387567552
11 14:28:57 finished records :2878733 failed:0 speed:20648.66047412402
11 14:28:58 finished records :2898278 failed:0 speed:20640.653486782132
11 14:28:59 finished records :2924733 failed:0 speed:20681.768682468744
11 14:29:00 finished records :2940117 failed:0 speed:20644.56943040108
11 14:29:01 finished records :2950875 failed:0 speed:20575.05926649003
11 14:29:02 finished records :2972198 failed:0 speed:20580.238194155932
11 14:29:03 finished records :2979491 failed:0 speed:20488.86673084858
11 14:29:04 finished records :3010076 failed:0 speed:20557.539167611423
11 14:29:05 finished records :3031551 failed:0 speed:20563.76253205085
11 14:29:06 finished records :3042804 failed:0 speed:20500.892718783478
11 14:29:07 finished records :3061056 failed:0 speed:20485.705107613234
11 14:29:08 finished records :3077733 failed:0 speed:20460.24929366794
11 14:29:09 finished records :3097218 failed:0 speed:20452.323093584087
11 14:29:10 finished records :3107743 failed:0 speed:20384.657767865927
11 14:29:11 finished records :3111339 failed:0 speed:20275.25333159558
11 14:29:12 finished records :3131319 failed:0 speed:20273.34175002428
11 14:29:13 finished records :3157026 failed:0 speed:20308.295004985364
11 14:29:14 finished records :3169783 failed:0 speed:20260.03004058675
11 14:29:15 finished records :3202319 failed:0 speed:20337.994982693468
11 14:29:16 finished records :3216309 failed:0 speed:20297.80506891503
11 14:29:17 finished records :3230936 failed:0 speed:20262.241621513145
11 14:29:18 finished records :3260915 failed:0 speed:20322.67211776364
11 14:29:19 finished records :3281844 failed:0 speed:20326.427469852653
11 14:29:20 finished records :3295531 failed:0 speed:20285.558640132465
11 14:29:21 finished records :3314117 failed:0 speed:20275.161051530373
11 14:29:22 finished records :3324289 failed:0 speed:20213.604689343174
11 14:29:23 finished records :3344884 failed:0 speed:20210.901576444572
11 14:29:24 finished records :3361621 failed:0 speed:20189.915915915917
11 14:29:25 finished records :3381885 failed:0 speed:20189.87606266119
11 14:29:26 finished records :3396380 failed:0 speed:20155.48130960364
11 14:29:27 finished records :3414703 failed:0 speed:20144.195430438962
11 14:29:28 finished records :3421218 failed:0 speed:20064.26489475876
11 14:29:29 finished records :3445349 failed:0 speed:20087.975838566173
11 14:29:30 finished records :3471349 failed:0 speed:20122.24585973231
11 14:29:31 finished records :3493005 failed:0 speed:20131.08527891282
11 14:29:32 finished records :3493500 failed:0 speed:20018.336532676276
11 14:29:33 finished records :3520764 failed:0 speed:20059.618835996924
11 14:29:34 finished records :3549329 failed:0 speed:20107.117768360942
11 14:29:35 finished records :3574662 failed:0 speed:20136.67192429022
11 14:29:36 finished records :3597844 failed:0 speed:20153.73067443424
11 14:29:37 finished records :3597844 failed:0 speed:20041.35449334618
11 14:29:38 finished records :3622279 failed:0 speed:20064.803992710313
11 14:29:39 finished records :3652147 failed:0 speed:20118.807463270332
11 14:29:40 finished records :3664975 failed:0 speed:20078.864180486387
11 14:29:41 finished records :3683470 failed:0 speed:20070.23413193555
11 14:29:42 finished records :3703390 failed:0 speed:20069.093707324475
11 14:29:43 finished records :3717976 failed:0 speed:20039.432338182425
11 14:29:44 finished records :3737885 failed:0 speed:20037.766293917724
11 14:29:45 finished records :3762814 failed:0 speed:20063.740048948774
11 14:29:46 finished records :3774157 failed:0 speed:20017.486727165688
11 14:29:47 finished records :3789086 failed:0 speed:19990.640646185824
11 14:29:48 finished records :3823279 failed:0 speed:20065.071584515914
11 14:29:49 finished records :3836087 failed:0 speed:20027.079798480776
11 14:29:50 finished records :3852238 failed:0 speed:20005.494419892086
11 14:29:51 finished records :3874995 failed:0 speed:20019.7097525819
11 14:29:52 finished records :3891571 failed:0 speed:20002.00967315827
11 14:29:53 finished records :3906258 failed:0 speed:19974.83112513359
11 14:29:54 finished records :3928168 failed:0 speed:19984.676356717322
11 14:29:55 finis