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_increment=1Ginnodb_log_fil

2、e_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:100createjobsfini

3、shed,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.49173300

4、673651114: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:17133

5、8failed: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.6296960312941

6、114: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:391662fail

7、ed: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:23