MyCat性能测试案例VIP免费

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_increment=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"createjobs...successfulcreatedconnections,total:100createjobsfinished,beginruntest...successcreatejobcount:14000tesetthreads:1001114:26:38finishedrecords:0failed:0speed:0.01114:26:39finishedrecords:10908failed:0speed:8629.7468354430381114:26:40finishedrecords:11413failed:0speed:5038.8520971302431114:26:41finishedrecords:26159failed:0speed:8009.49173300673651114:26:42finishedrecords:53530failed:0speed:12548.0543834974211114:26:43finishedrecords:78974failed:0speed:14994.1142965635081114:26:44finishedrecords:114310failed:0speed:18234.168128888181114:26:45finishedrecords:141269failed:0speed:19434.4476544228931114:26:46finishedrecords:171338failed:0speed:20715.5120299842821114:26:47finishedrecords:196379failed:0speed:21182.073131269551114:26:48finishedrecords:219441failed:0speed:21365.1056372310381114:26:49finishedrecords:238269failed:0speed:21140.0053233963261114:26:50finishedrecords:273197failed:0speed:22263.6296960312941114:26:51finishedrecords:309299failed:0speed:23306.3823374274731114:26:52finishedrecords:324784failed:0speed:22758.3210707028231114:26:53finishedrecords:351056failed:0speed:22986.90413829231114:26:54finishedrecords:362197failed:0speed:22258.9110127826931114:26:55finishedrecords:391662failed:0speed:22673.4977422716221114:26:56finishedrecords:413784failed:0speed:22639.601685178091114:26:57finishedrecords:435309failed:0speed:22581.781397520361114:26:58finishedrecords:464288failed:0speed:22897.2727721063271114:26:59finishedrecords:494561failed:0speed:23240.6484962406031114:27:00finishedrecords:502410failed:0speed:22549.8204667863541114:27:01finishedrecords:514067failed:0speed:22080.967312400671114:27:02finishedrecords:548450failed:0speed:22587.6199497549531114:27:03finishedrecords:582390failed:0speed:23036.6678533285851114:27:04finishedrecords:607036failed:0speed:23097.0245795601551114:27:05finishedrecords:627743failed:0speed:23007.7334701656651114:27:06finishedrecords:661228failed:0speed:23372.114398840461114:27:07finishedrecords:691299failed:0speed:23604.295421176631114:27:08finishedrecords:702107failed:0speed:23181.7941691154631114:27:09finishedrecords:725410failed:0speed:23181.9634411351141114:27:10finishedrecords:735844failed:0speed:22787.1918741483971114:27:11finishedrecords:749733failed:0speed:22519.9146942208351114:27:12finishedrecords:766561failed:0speed:22353.9309459932341114:27:13finishedrecords:783349failed:0speed:22196.2201065397241114:27:14finishedrecords:794470failed:0speed:21891.0503692273781114:27:15finishedrecords:814713failed:0speed:21846.8572347956651114:27:16finishedrecords:848622failed:0speed:22161.2827409709351114:27:17finishedrecords:870834failed:0speed:22162.0094670942131114:27:18finishedrecords:888461failed:0speed:22048.914257352031114:27:19finishedr...