mycat性能检测测验案例

《mycat性能检测测验案例》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、MyCAT性能测试案例测试案例一：硬件；HPZooK，8核心CPU，16G内存。Mycat版本1.2（SVN445），默认参数，日志级别Info操作系统windows764Java环境：JDK7Mysql版本mysql-5.6.13-winx64Mysql参数[mysqld]max_connections=1000innodb_buffer_pool_size=4G#innodb_flush_method=O_DIRECTinnodb_flush_log_at_trx_commit=0innodb_autoextend_in

2、crement=1Ginnodb_log_file_size=256M分片表配置（3个分片，在一个mysql实例上）#rangestart-end,datanodeindex#K=1000,M=10000.0-500M=0500M-1000M=11000M-1500M=2测试标准插入1500万数据，100并发线程，最终TPS为17432。jdbc:mysql://localhost:8066/TESTDBtesttest100"0-500M,500M1-1000M,1000M1-1400M"矚慫润厲钐瘗睞枥庑赖。create

3、jobs...successfulcreatedconnections,total:100createjobsfinished,beginruntest...successcreatejobcount:14000tesetthreads:1001114:26:38finishedrecords:0failed:0speed:0.01114:26:39finishedrecords:10908failed:0speed:8629.746835443038聞創沟燴鐺險爱氇谴净。1114:26:40finishedrecords:

4、11413failed:0speed:5038.852097130243残骛楼諍锩瀨濟溆塹籟。1114:26:41finishedrecords:26159failed:0speed:8009.4917330067365酽锕极額閉镇桧猪訣锥。1114:26:42finishedrecords:53530failed:0speed:12548.054383497421彈贸摄尔霁毙攬砖卤庑。1114:26:43finishedrecords:78974failed:0speed:14994.114296563508謀荞抟箧飆鐸怼

5、类蒋薔。1114:26:44finishedrecords:114310failed:0speed:18234.16812888818厦礴恳蹒骈時盡继價骚。1114:26:45finishedrecords:141269failed:0speed:19434.447654422893茕桢广鳓鯡选块网羈泪。1114:26:46finishedrecords:171338failed:0speed:20715.512029984282鹅娅尽損鹌惨歷茏鴛賴。1114:26:47finishedrecords:196379faile

6、d:0speed:21182.07313126955籟丛妈羥为贍偾蛏练淨。1114:26:48finishedrecords:219441failed:0speed:21365.105637231038預頌圣鉉儐歲龈讶骅籴。1114:26:49finishedrecords:238269failed:0speed:21140.005323396326渗釤呛俨匀谔鱉调硯錦。1114:26:50finishedrecords:273197failed:0speed:22263.629696031294铙誅卧泻噦圣骋贶頂廡。111

7、4:26:51finishedrecords:309299failed:0speed:23306.382337427473擁締凤袜备訊顎轮烂蔷。1114:26:52finishedrecords:324784failed:0speed:22758.321070702823贓熱俣阃歲匱阊邺镓騷。1114:26:53finishedrecords:351056failed:0speed:22986.9041382923坛摶乡囂忏蒌鍥铃氈淚。1114:26:54finishedrecords:362197failed:0speed

8、:22258.911012782693蜡變黲癟報伥铉锚鈰赘。1114:26:55finishedrecords:391662failed:0speed:22673.497742271622買鲷鴯譖昙膚遙闫撷凄。1114:26:56finishedrecords:413784failed:0