ImageVerifierCode 换一换
格式:DOCX , 页数:16 ,大小:62.13KB ,
资源ID:2124836      下载积分:15 文钱
快捷下载
登录下载
邮箱/手机:
温馨提示:
快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。 如填写123,账号就是123,密码也是123。
特别说明:
请自助下载,系统不会自动发送文件的哦; 如果您已付费,想二次下载,请登录后访问:我的下载记录
支付方式: 支付宝    微信支付   
验证码:   换一换

加入VIP,省得不是一点点
 

温馨提示:由于个人手机设置不同,如果发现不能下载,请复制以下地址【https://www.wenke99.com/d-2124836.html】到电脑端继续下载(重复下载不扣费)。

已注册用户请登录:
账号:
密码:
验证码:   换一换
  忘记密码?
三方登录: QQ登录   微博登录 

下载须知

1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。
2: 试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。
3: 文件的所有权益归上传用户所有。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 本站仅提供交流平台,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

版权提示 | 免责声明

本文(MyCat性能测试案例.docx)为本站会员(11****ws)主动上传,文客久久仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知文客久久(发送邮件至hr@wenke99.com或直接QQ联系客服),我们立即给予删除!

MyCat性能测试案例.docx

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

Copyright © 2018-2021 Wenke99.com All rights reserved

工信部备案号浙ICP备20026746号-2  

公安局备案号:浙公网安备33038302330469号

本站为C2C交文档易平台,即用户上传的文档直接卖给下载用户,本站只是网络服务中间平台,所有原创文档下载所得归上传人所有,若您发现上传作品侵犯了您的权利,请立刻联系网站客服并提供证据,平台将在3个工作日内予以改正。