1、MyCAT 性 能 测 试 案 例测试案例一：硬件；HP ZooK，8 核心 CPU，16G 内存。Mycat 版本 1.2 （SVN 445），默认参数，日志级别 Info操作系统 windows 7 64 Java 环境：JDK 7Mysql 版本 mysql-5.6.13-winx64Mysql 参数mysqldmax_connections =1000innodb_buffer_pool_size=4G#innodb_flush_method=O_DIRECT innodb_flush_log_at_trx_commit=0innodb_autoextend_increment=1Gi
2、nnodb_log_file_size=256M分片表配置（3 个分片，在一个 mysql 实例上）# range start-end ,data node index# K=1000,M=10000.0-500M=0500M-1000M=11000M-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
3、,total :100create jobs finished ,begin run test.success create job count: 14000 teset threads: 10011 14:26:38 finished records :0 failed:0 speed:0.011 14:26:39 finished records :10908 failed:0 speed:8629.74683544303811 14:26:40 finished records :11413 failed:0 speed:5038.85209713024311 14:26:41 fini
4、shed records :26159 failed:0 speed:8009.491733006736511 14:26:42 finished records :53530 failed:0 speed:12548.05438349742111 14:26:43 finished records :78974 failed:0 speed:14994.11429656350811 14:26:44 finished records :114310 failed:0 speed:18234.1681288881811 14:26:45 finished records :141269 fai
5、led:0 speed:19434.44765442289311 14:26:46 finished records :171338 failed:0 speed:20715.51202998428211 14:26:47 finished records :196379 failed:0 speed:21182.0731312695511 14:26:48 finished records :219441 failed:0 speed:21365.10563723103811 14:26:49 finished records :238269 failed:0 speed:21140.005
6、32339632611 14:26:50 finished records :273197 failed:0 speed:22263.62969603129411 14:26:51 finished records :309299 failed:0 speed:23306.38233742747311 14:26:52 finished records :324784 failed:0 speed:22758.32107070282311 14:26:53 finished records :351056 failed:0 speed:22986.904138292311 14:26:54 f
7、inished records :362197 failed:0 speed:22258.91101278269311 14:26:55 finished records :391662 failed:0 speed:22673.49774227162211 14:26:56 finished records :413784 failed:0 speed:22639.6016851780911 14:26:57 finished records :435309 failed:0 speed:22581.7813975203611 14:26:58 finished records :46428
8、8 failed:0 speed:22897.27277210632711 14:26:59 finished records :494561 failed:0 speed:23240.64849624060311 14:27:00 finished records :502410 failed:0 speed:22549.82046678635411 14:27:01 finished records :514067 failed:0 speed:22080.9673124006711 14:27:02 finished records :548450 failed:0 speed:2258
9、7.61994975495311 14:27:03 finished records :582390 failed:0 speed:23036.66785332858511 14:27:04 finished records :607036 failed:0 speed:23097.02457956015511 14:27:05 finished records :627743 failed:0 speed:23007.73347016566511 14:27:06 finished records :661228 failed:0 speed:23372.1143988404611 14:2
10、7:07 finished records :691299 failed:0 speed:23604.2954211766311 14:27:08 finished records :702107 failed:0 speed:23181.79416911546311 14:27:09 finished records :725410 failed:0 speed:23181.96344113511411 14:27:10 finished records :735844 failed:0 speed:22787.19187414839711 14:27:11 finished records
11、 :749733 failed:0 speed:22519.91469422083511 14:27:12 finished records :766561 failed:0 speed:22353.93094599323411 14:27:13 finished records :783349 failed:0 speed:22196.22010653972411 14:27:14 finished records :794470 failed:0 speed:21891.05036922737811 14:27:15 finished records :814713 failed:0 sp
12、eed:21846.85723479566511 14:27:16 finished records :848622 failed:0 speed:22161.28274097093511 14:27:17 finished records :870834 failed:0 speed:22162.00946709421311 14:27:18 finished records :888461 failed:0 speed:22048.9142573520311 14:27:19 finished records :917319 failed:0 speed:22213.26520728411
13、 14:27:20 finished records :947460 failed:0 speed:22400.69982977113611 14:27:21 finished records :973319 failed:0 speed:22480.57557280118311 14:27:22 finished records :983834 failed:0 speed:22204.43260810688711 14:27:23 finished records :1008703 failed:0 speed:22262.75132975788411 14:27:24 finished
14、records :1024218 failed:0 speed:22117.0398842557611 14:27:25 finished records :1041733 failed:0 speed:22015.57546810938611 14:27:26 finished records :1072460 failed:0 speed:22195.40967321343511 14:27:27 finished records :1102339 failed:0 speed:22351.2033901741711 14:27:28 finished records :1132632 f
15、ailed:0 speed:22508.58505564387811 14:27:29 finished records :1132632 failed:0 speed:22069.99220576773211 14:27:30 finished records :1152117 failed:0 speed:22020.5848623853211 14:27:31 finished records :1177561 failed:0 speed:22084.78994748687211 14:27:32 finished records :1202844 failed:0 speed:221
16、43.66715758468511 14:27:33 finished records :1220723 failed:0 speed:22066.57628344179511 14:27:34 finished records :1245612 failed:0 speed:22116.69034090909211 14:27:35 finished records :1267511 failed:0 speed:22112.89253314724211 14:27:36 finished records :1278763 failed:0 speed:21926.2872721661151
17、1 14:27:37 finished records :1307319 failed:0 speed:22038.04723453751611 14:27:38 finished records :1337147 failed:0 speed:22167.18887286351311 14:27:39 finished records :1355188 failed:0 speed:22099.9005234748311 14:27:40 finished records :1368471 failed:0 speed:21958.42492899664611 14:27:41 finish
18、ed records :1375259 failed:0 speed:21718.8452488116111 14:27:42 finished records :1396753 failed:0 speed:21715.01197102080211 14:27:43 finished records :1419501 failed:0 speed:21730.82575548819711 14:27:44 finished records :1437420 failed:0 speed:21673.3512258375811 14:27:45 finished records :144041
19、0 failed:0 speed:21395.8290009209511 14:27:46 finished records :1471056 failed:0 speed:21530.90467338963611 14:27:47 finished records :1492582 failed:0 speed:21530.8339223634311 14:27:48 finished records :1503925 failed:0 speed:21385.96191857571511 14:27:49 finished records :1530864 failed:0 speed:2
20、1463.51859121754411 14:27:50 finished records :1544026 failed:0 speed:21348.73624246446711 14:27:51 finished records :1581157 failed:0 speed:21563.97632425945311 14:27:52 finished records :1585036 failed:0 speed:21326.03196813949811 14:27:53 finished records :1613734 failed:0 speed:21423.90207636344
21、311 14:27:54 finished records :1637824 failed:0 speed:21458.8333944761811 14:27:55 finished records :1668520 failed:0 speed:21578.29393202627811 14:27:56 finished records :1689672 failed:0 speed:21570.37263988357511 14:27:57 finished records :1707774 failed:0 speed:21526.1107959916811 14:27:58 finis
22、hed records :1723926 failed:0 speed:21458.94742083250511 14:27:59 finished records :1738865 failed:0 speed:21378.786761089811 14:28:00 finished records :1744016 failed:0 speed:21181.43726392751711 14:28:01 finished records :1774348 failed:0 speed:21290.98370491252411 14:28:02 finished records :17973
23、59 failed:0 speed:21311.37802651236811 14:28:03 finished records :1827815 failed:0 speed:21418.28472328009611 14:28:04 finished records :1838683 failed:0 speed:21295.8420199212411 14:28:05 finished records :1838885 failed:0 speed:21053.12267445188611 14:28:06 finished records :1862744 failed:0 speed
24、:21084.64446607656311 14:28:07 finished records :1878794 failed:0 speed:21028.294495556611 14:28:08 finished records :1896975 failed:0 speed:20996.7790494321811 14:28:09 finished records :1917652 failed:0 speed:20993.27830446872411 14:28:10 finished records :1939703 failed:0 speed:21001.775679684711
25、1 14:28:11 finished records :1961188 failed:0 speed:21005.15171313204711 14:28:12 finished records :1982855 failed:0 speed:21011.27465005139311 14:28:13 finished records :2000723 failed:0 speed:20978.31625965964511 14:28:14 finished records :2016087 failed:0 speed:20920.05893889240511 14:28:15 finis
26、hed records :2033197 failed:0 speed:20880.28631872984611 14:28:16 finished records :2059501 failed:0 speed:20934.99430755468711 14:28:17 finished records :2085440 failed:0 speed:20985.34857510867711 14:28:18 finished records :2097046 failed:0 speed:20891.9064318163711 14:28:19 finished records :2120
27、359 failed:0 speed:20914.96350364963711 14:28:20 finished records :2154339 failed:0 speed:21042.57667513186211 14:28:21 finished records :2168268 failed:0 speed:20973.7666860127711 14:28:22 finished records :2171167 failed:0 speed:20800.6035639011311 14:28:23 finished records :2188915 failed:0 speed
28、:20771.63598405769511 14:28:24 finished records :2215390 failed:0 speed:20825.24910697499611 14:28:25 finished records :2244632 failed:0 speed:20903.43729337592211 14:28:26 finished records :2265258 failed:0 speed:20900.4917745402911 14:28:27 finished records :2295885 failed:0 speed:20988.6458171446
29、3211 14:28:28 finished records :2304754 failed:0 speed:20878.28607663737811 14:28:29 finished records :2335127 failed:0 speed:20962.95997055470411 14:28:30 finished records :2355359 failed:0 speed:20956.08345566973711 14:28:31 finished records :2377976 failed:0 speed:20970.5456982609611 14:28:32 fin
30、ished records :2398551 failed:0 speed:20966.9047265225511 14:28:33 finished records :2420723 failed:0 speed:20977.16598207941211 14:28:34 finished records :2447662 failed:0 speed:21028.38536744617511 14:28:35 finished records :2470895 failed:0 speed:21047.16434692243611 14:28:36 finished records :24
31、83521 failed:0 speed:20975.86128261218311 14:28:37 finished records :2504632 failed:0 speed:20976.9931071449511 14:28:38 finished records :2514309 failed:0 speed:20883.1385642737911 14:28:39 finished records :2536117 failed:0 speed:20890.75692551009311 14:28:40 finished records :2566460 failed:0 spe
32、ed:20967.8104575163411 14:28:41 finished records :2584440 failed:0 speed:20943.59805510534711 14:28:42 finished records :2600955 failed:0 speed:20907.9983922829611 14:28:43 finished records :2619541 failed:0 speed:20889.48165869218411 14:28:44 finished records :2635754 failed:0 speed:20851.989272406
33、5111 14:28:45 finished records :2653633 failed:0 speed:20828.16350878294511 14:28:46 finished records :2675521 failed:0 speed:20836.25503282531311 14:28:47 finished records :2692076 failed:0 speed:20803.1713894920711 14:28:48 finished records :2708813 failed:0 speed:20771.99076736678411 14:28:49 fin
34、ished records :2728299 failed:0 speed:20761.57247110211411 14:28:50 finished records :2755218 failed:0 speed:20808.07485782903311 14:28:51 finished records :2766178 failed:0 speed:20734.2572951255911 14:28:52 finished records :2790056 failed:0 speed:20757.64632358958611 14:28:53 finished records :28
35、04096 failed:0 speed:20708.0370132411711 14:28:54 finished records :2816743 failed:0 speed:20648.94326703858311 14:28:55 finished records :2833107 failed:0 speed:20617.75985910880611 14:28:56 finished records :2854420 failed:0 speed:20622.6338756755211 14:28:57 finished records :2878733 failed:0 spe
36、ed:20648.6604741240211 14:28:58 finished records :2898278 failed:0 speed:20640.65348678213211 14:28:59 finished records :2924733 failed:0 speed:20681.76868246874411 14:29:00 finished records :2940117 failed:0 speed:20644.5694304010811 14:29:01 finished records :2950875 failed:0 speed:20575.059266490
37、0311 14:29:02 finished records :2972198 failed:0 speed:20580.23819415593211 14:29:03 finished records :2979491 failed:0 speed:20488.8667308485811 14:29:04 finished records :3010076 failed:0 speed:20557.53916761142311 14:29:05 finished records :3031551 failed:0 speed:20563.7625320508511 14:29:06 fini
38、shed records :3042804 failed:0 speed:20500.89271878347811 14:29:07 finished records :3061056 failed:0 speed:20485.70510761323411 14:29:08 finished records :3077733 failed:0 speed:20460.2492936679411 14:29:09 finished records :3097218 failed:0 speed:20452.32309358408711 14:29:10 finished records :310
39、7743 failed:0 speed:20384.65776786592711 14:29:11 finished records :3111339 failed:0 speed:20275.2533315955811 14:29:12 finished records :3131319 failed:0 speed:20273.3417500242811 14:29:13 finished records :3157026 failed:0 speed:20308.29500498536411 14:29:14 finished records :3169783 failed:0 spee
40、d:20260.0300405867511 14:29:15 finished records :3202319 failed:0 speed:20337.99498269346811 14:29:16 finished records :3216309 failed:0 speed:20297.8050689150311 14:29:17 finished records :3230936 failed:0 speed:20262.24162151314511 14:29:18 finished records :3260915 failed:0 speed:20322.6721177636
41、411 14:29:19 finished records :3281844 failed:0 speed:20326.42746985265311 14:29:20 finished records :3295531 failed:0 speed:20285.55864013246511 14:29:21 finished records :3314117 failed:0 speed:20275.16105153037311 14:29:22 finished records :3324289 failed:0 speed:20213.60468934317411 14:29:23 fin
42、ished records :3344884 failed:0 speed:20210.90157644457211 14:29:24 finished records :3361621 failed:0 speed:20189.91591591591711 14:29:25 finished records :3381885 failed:0 speed:20189.8760626611911 14:29:26 finished records :3396380 failed:0 speed:20155.4813096036411 14:29:27 finished records :341
43、4703 failed:0 speed:20144.19543043896211 14:29:28 finished records :3421218 failed:0 speed:20064.2648947587611 14:29:29 finished records :3445349 failed:0 speed:20087.97583856617311 14:29:30 finished records :3471349 failed:0 speed:20122.2458597323111 14:29:31 finished records :3493005 failed:0 spee
44、d:20131.0852789128211 14:29:32 finished records :3493500 failed:0 speed:20018.33653267627611 14:29:33 finished records :3520764 failed:0 speed:20059.61883599692411 14:29:34 finished records :3549329 failed:0 speed:20107.11776836094211 14:29:35 finished records :3574662 failed:0 speed:20136.671924290
45、2211 14:29:36 finished records :3597844 failed:0 speed:20153.7306744342411 14:29:37 finished records :3597844 failed:0 speed:20041.3544933461811 14:29:38 finished records :3622279 failed:0 speed:20064.80399271031311 14:29:39 finished records :3652147 failed:0 speed:20118.80746327033211 14:29:40 fini
46、shed records :3664975 failed:0 speed:20078.86418048638711 14:29:41 finished records :3683470 failed:0 speed:20070.2341319355511 14:29:42 finished records :3703390 failed:0 speed:20069.09370732447511 14:29:43 finished records :3717976 failed:0 speed:20039.43233818242511 14:29:44 finished records :373
47、7885 failed:0 speed:20037.76629391772411 14:29:45 finished records :3762814 failed:0 speed:20063.74004894877411 14:29:46 finished records :3774157 failed:0 speed:20017.48672716568811 14:29:47 finished records :3789086 failed:0 speed:19990.64064618582411 14:29:48 finished records :3823279 failed:0 sp
48、eed:20065.07158451591411 14:29:49 finished records :3836087 failed:0 speed:20027.07979848077611 14:29:50 finished records :3852238 failed:0 speed:20005.49441989208611 14:29:51 finished records :3874995 failed:0 speed:20019.709752581911 14:29:52 finished records :3891571 failed:0 speed:20002.00967315
49、82711 14:29:53 finished records :3906258 failed:0 speed:19974.8311251335911 14:29:54 finished records :3928168 failed:0 speed:19984.67635671732211 14:29:55 finished records :3953561 failed:0 speed:20011.8495047099411 14:29:56 finished records :3985925 failed:0 speed:20073.8556528658411 14:29:57 finished records :4006511 failed:0 speed:20076.42198203073711 14:29:58 finished records :4021077 failed:0 speed:20048.94721359373211 14:29:59 finished records :4037935 failed:0 speed:20033.11619692106311 14:30:00 finished records :4058966 failed:0 speed:20038.04248554770711 14:30:01 finished
