下载文档原格式
MyCAT高级功能测试案例部署方式：后端双主双从模式的数据库模式，四个实例分别命名为M1,M2,S1,S2,(M1->S1，M2->S2，并且M1与 M2互为主备)Schema.xml配置如下：<dataNode name="dn1"dataHost="localhost1"database="db1"/><dataNode name="dn2"dataHost="localhost1"database="db2"/><dataNode name="dn3"dataHost="localhost1"database="db3"/><dataHost name="localhost1"maxCon="500"minCon="10"balance="1"dbType="mysql"dbDriver="native"><heartbeat>select user()</heartbeat><!-- can have multi write hosts --><writeHost host="hostM1"url="localhost:3306"user="root"password="123456"><!-- can have multi read hosts --><readHost host="hostS1" url="localhost:3307" user="root" password="123456" /></writeHost><writeHost host="hostM2"url="localhost:3308"user="root"password="123456"><!-- can have multi read hosts --><readHost host="hostS2" url="localhost:3309" user="root" password="123456" /></writeHost></dataHost>心跳功能测试：案例一：所有节点正常，心跳正常。
1.MySQL主从配置我们的方案设计基于Mysql的主从数据复制功能，以下是基于mysql5.5以上版本最新的主从配置。
开启mysql主从数据复制，主要在mysql的my.ini文件中设置：windows系统一般在c:\ProgrameData\MySQL中：Linux系统一般在/etc/f中：1、主数据库服务器配置：server-id=1log-bin=mysql-binbinlog-do-db=Industry //只同步Industry数据库binlog-ignore-db=mysql //避免同步mysql用户配置，以免不必要的麻烦binlog-ignore-db=performance_schemabinlog-ignore-db=information_schema2、创建一个允许从服务器来访问的用户(主服务器)：grant replication slave on *.* to 'root'@'192.168.0.58' identified by 'root';说明：∙root：Slave使用的账号∙IDENTIFIED BY 'root' ：Slave使用的密码∙192.168.1.58：Slave数据库IPmaster端，通过show master status\G 显示信息。
如图：注意上图中的File,和Position。
Slave 中会用到这些信息。
3、从数据库服务器配置：server-id=11 //服务Id，注意要和master的server-id不一样log-bin=mysql-binrelay-log-index=slave-relay-bin.indexrelay-log=slave-relay-binsync_master_info=1sync_relay_log=1sync_relay_log_info=14、关联上Master信息：change master tomaster_host='192.168.0.68',master_user='root',master_port=3306,master_password='root',mast er_log_file='mysql-bin.000001',master_log_pos=120;命令说明：∙master_host：master 数据库服务器ip∙master_user: master 数据库通过GRANT授权的账号∙master_port：master 数据库使用的端口号∙master_password：master 数据库通过GRANT授权的密码∙master_log_file：master数据库中通过show master status显示的File名称∙master_log_pos：master数据库中通过show master status显示的Position数据重启Slave 的MySql服务在命令行中输入start slave.在命令行中输入show slave status,显示如下：注意：只有Slave_IO_Running与Slave_SQL_Running都为Yes才配置成功。
mycat性能测试记录前言本次测试以客观为原则。
网络情况不同，测试结果不一致。
测试过程中可能会存在网络状态相差较大的情况，所以我尽力重复多次测试，取相对稳定的结果。
Mycat mysql insert性能对比Mycat 1000条inseret性能截取日志片段：Mycat 测试结果：Tps(每秒钟插入数量)：4460.30Mysql 1000条insert性能Mysql 插入50万调数据，每次插入1000调条，20个线程调用截取日志片段：Mysql 测试结果：Tps(每秒钟插入数量)：3756.58Mycat 300万条insert性能1.test_stand_insert_perf.batjdbc:mysql://127.0.0.1:8066/mydb root 123 10 100M-400MMycat 测试neng结果：Tps(每秒钟插入数量)：5207.43Mysql 300万条insert性能Mysql 插入300万条数据，每次插入1000条，20个线程调用Mysql 测试结果：Tps(每秒钟插入数量)：3830.18Insert性能对比综上，插入数据效率对比：Mycat mysql select 性能对比Mycat select 效率Mysql select 效率Select 效率对比通过以上数据对比，Mycat mysql update 性能对比Mycat update 效率test_stand_update_perf.batjdbc:mysql://127.0.0.1:8066/mydb root 123 20 0-50MTp(每秒钟更新数量)：595.17Mysql update 效率Tps(每秒钟更新数量)：583.71主从备份延迟测试测试方案：测试主从备份延迟：mycat读写分离与mysql读效率对比数据量7500万mysql 边读边写命令Mycat 读写分离，一读一写Mycat 读写分离，两读一写测试只考虑了读写对数据库性能影响，并未涉及行锁对读的影响。
1前言使用tpc-c的标准对mycat进行测试，以发现mycat对事务支持的bug和mycat事务使用中的注意事项，同时，通过让mycat通过tpcc这种标准企业级测试，让使用mycat的人群更有信心来使用mycat 。
2测试方法概述2.1测试环境2.2硬件环境2.3软件环境2.4测试工具2.4.1TPCC介绍TPC(Tracsaction Processing Performance Council) 事务处理性能协会是一个评价大型数据库系统软硬件性能的非盈利的组织,TPC-C是TPC协会制定的，用来测试典型的复杂OLTP系统的性能。
Tpcc测试结果主要关注两个指标：流量指标和性价比。
流量指标：（Throughput，简称tpmC）系统每分钟能够执行多少个用户订单请求，即在执行支付（Payment）、订单状态查询（Order-status）、发货（Delivery）、库存状态查询（Stock-Level）这四种交易的同事，每分钟可以处理多少个新订单（New-Order）交易。
每分钟能处理的新订单事务数越大，说明数据库管理系统的性能越好，例如：每分钟能处理的新订单事务数:13.6 个。
性价比(Price/Performance，简称Price/tpmC)：系统价格（指在美国的报价）与流量指标的比值2.4.1.1T pcc商业模型测试用到的模型是一个大型的批发销售公司，每个仓库负责10个区域的供货，每个区域为3000个客户提供服务。
每个仓库维护公司销售的100,000种商品的库存记录，随着企业并发用户的增加，数据量也逐渐增加。
商业模型示意图如下：2.4.1.2T pcc表关系及数据量关系2.4.1.3模拟事务新订单从固定的仓库中随机选取5-15件商品，创建新订单。
支付操作采用随机的金额支付一笔订单，并作相应历史记录。
订单状态查询显示订单内每件商品的状态。
发货随机选取一个发货包，更新被处理订单的用户帐户余额 库存状态查询检查订单中所有货物的库存。
MyCAT 性能调优指南JVM调优：内存占用分两部分:java堆内存+直接内存映射（DirectBuffer占用），建议堆内存适度大小，直接映射内存尽可能大，两种一起占据操作系统的1/2-2/3的内存。
下面以服务器16G内存为例，Mycat堆内存4G，直接内存映射6G，JVM参数如下：-server -Xms4G –Xmx4G XX:MaxPermSize=64M -XX:MaxDirectMemorySize=6G用mycat console等命令启动MyCAT的，JVM参数都在conf\wrapper.con文件中，下面是一段实例：# Java Additional Parameterswrapper.java.additional.5=-XX:MaxDirectMemorySize=2Gwrapper.java.additional.6=-Dcom.sun.management.jmxremote# Initial Java Heap Size (in MB)wrapper.java.initmemory=2048# Maximum Java Heap Size (in MB)wrapper.java.maxmemory=2048操作系统调优：最大文件句柄数量的修改，设置为5000-1万，在Mycat Server和Mysql数据库的机器上都设置。
Linux操作系统对一个进程打开的文件句柄数量的限制(也包含打开的SOCKET 数量,可影响MySQL的并发连接数目).这个值可用ulimit命令来修改，但ulimit命令修改的数值只对当前登录用户的目前使用环境有效,系统重启或者用户退出后就会失效。
Mysql调优：最大连接数设置为2000[mysqld]中有参数max_connections = 2000mysql> show global status like 'Max_used_connections';MySQL服务器过去的最大连接数是245，没有达到服务器连接数上限256，应该没有出现1040错误，比较理想的设置是：Max_used_connections / max_connections * 100% ≈ 85%最大连接数占上限连接数的85%左右，如果发现比例在10%以下，MySQL服务器连接上线就设置得过高了。
mycat分库分表看这⼀篇就够了之前我们已经讲解过了数据的切分，主要有两种⽅式，分别是垂直切分和⽔平切分，所谓的垂直切分就是将不同的表分布在不同的数据库实例中，⽽⽔平切分指的是将⼀张表的数据按照不同的切分规则切分在不同实例的相同名称的表中。
下⾯先来描述mycat的分库操作,在进⾏分库操作的时候需要注意⼀点：有关联关系的表应该放在⼀个库⾥，相互没有关联关系的表可以分到不同的库中。
数据⽂件--客户表CREATE TABLE customer(id INT AUTO_INCREMENT,NAME VARCHAR(200),PRIMARY KEY(id));--订单表CREATE TABLE orders(id INT AUTO_INCREMENT,order_type INT,customer_id INT,amount DECIMAL(10,2),PRIMARY KEY(id));--订单详细表CREATE TABLE orders_detail(id INT AUTO_INCREMENT,detail VARCHAR(2000),order_id INT,PRIMARY KEY(id));--订单状态字典表CREATE TABLE dict_order_type(id INT AUTO_INCREMENT,order_type VARCHAR(200),PRIMARY KEY(id));1、分库实战在上述的数据⽂件中，我们包含四个不同的表，现在将不同的表分布在不同的库中，但是访问的时候使⽤的是同⼀个mycat的终端，这些操作其实很简单，都是由mycat来完成的，我们需要做的事情就是修改⼏个简单的配置即可。
1、修改schema.xml⽂件<?xml version="1.0"?><!DOCTYPE mycat:schema SYSTEM "schema.dtd"><mycat:schema xmlns:mycat="http://io.mycat/"><schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"><table name = "customer" dataNode="dn2"></table></schema><dataNode name="dn1" dataHost="host1" database="orders" /><dataNode name="dn2" dataHost="host2" database="orders"/><dataHost name="host1" maxCon="1000" minCon="10" balance="0"writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"><heartbeat>select user()</heartbeat><writeHost host="hostM1" url="192.168.85.111:3306" user="root"password="123456"></writeHost></dataHost><dataHost name="host2" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"> <heartbeat>select user()</heartbeat><writeHost host="hostM2" url="192.168.85.113:3306" user="root" password="123456"></writeHost></dataHost></mycat:schema>mysql -uroot -p123456 -h 192.168.85.111 -P80664、插⼊sql语句执⾏上述的建表语句，会发现，customer在node03上，⽽其他的表在node01上，此时完成了分库的功能。
Mycat（⽔平拆分——分表取模，mycat的分⽚join，全局表）相对于垂直拆分，⽔平拆分不是将表做分类，⽽是按照某个字段的某种规则来分散到多个库中。
每个表中包含⼀部分数据。
简单来说，我们可以将数据的⽔平切分理解为是按照数据⾏的切分，就是将表中的某些⾏切分到⼀个数据库，⽽别的某些⾏⼜切分到其他的数据库中。
配置分表取模1.选择要拆分的表Mysql单表存储数据条数是有瓶颈的，单表达到1000万条数据时就达到了瓶颈，会影响查询效率，需要进⾏⽔平拆分（分表）进⾏优化。
列如：当orders 和 orders_detail都达到600万⾏数据，需要进⾏分表优化。
2.分表字段以orders 表为列，可以根据不同字段进⾏分表编号分表字段效果1id（主键、或创建时间）查询订单注重时效，历史订单被查询的次数少，如此会形成⼀个节点访问多，⼀个节点访问少。
2customer_id(客户id)根据客户id去分，两个节点访问平均，⼀个客户的所有订单都在同⼀个节点。
3.修改配置⽂件schema.xml#为orders 表设置数据节点dn1,dn2，并指定分⽚规则mod_rule(⾃定义的名字)<table name="orders" dataNode="dn1,dn2" rule="mod_rule"></table>4.修改配置⽂件rule.xml#在rule 配置⽂件⾥⾯新增分⽚规则mod_rule，并指定规则适⽤字段为customer_id#还有选择分⽚算法mod-long（对字段取模运算），customer_id对两个节点取模，根据结果分⽚#配置算法mod-long参数count为2，两个节点<tableRule name="mod_rule"><rule><columns>customer_id</columns><algorithm>mod-long</algorithm></rule></tableRule>往下找到算法的具体实现5.在数据节点dn2上建orders表6.重启mycat。
目录第1章引言 (1)1.1 编写目的 (1)1.2 项目背景 (1)第2章测试概要 (1)2.1 cobar 1.2.7 (1)2.1.1 测试目的 (1)2.1.2 测试环境 (1)2.1.3 测试数据 (2)2.1.4 测试用例和运行方式 (2)2.2 mycat (3)2.2.1 测试目的 (3)2.2.2 测试环境 (3)2.2.3 测试数据 (4)2.2.4 测试用例 (5)2.3 大表 (7)2.3.1 概念描述 (7)2.3.2测试目的 (7)2.3.3 测试环境 (8)2.3.4 测试用例 (9)第3章测试结果 (15)3.1 cobar 1.2.7 (15)3.1.1 cobar 性能测试 (15)3.1.2 cobar稳定性测试 (16)3.1.3 cobar测试局限性 (16)3.2 mycat (17)3.2.1 mycat性能测试 (17)3.2.3 mycat测试局限性 (18)3.2.2 mycat之mysql函数关键字测试 (18)3.3 大表 (19)3.3.1 大表查询与原查询之间的执行时间比较 (19)3.3.2 不同数据量之间的执行时间比较 (20)3.3.3 优化前后大表查询性能的比较 (21)第4章测试结论与建议 (23)4.1 测试结论 (23)4.2建议 (23)第1章引言第1章引言1.1 编写目的本测试报告为MySQL代理项目的测试报告，目的在于总结测试阶段的测试以及分析测试结果。
预期参考人员包括测试人员，项目管理者和其他需要阅读本报告的相关人员。
1.2 项目背景随着传统的数据库技术日趋成熟，计算机网络技术的飞速发展和应用范围的扩充，数据库应用已经普遍建立于计算机网络之上，这时集中式数据库系统表现出它的不足：●集中式处理，势必造成性能瓶颈●应用程序集中在一台计算机上运行，一旦该计算机发生故障，则整个系统受到影响，可靠性不高。
●集中式处理引起系统的规模和配置都不够灵活，系统的可扩充性差。
mycat读写分离+垂直切分+⽔平切分+er分⽚+全局表测试读写分离：利⽤最基础的mysql主从复制，事务性的查询⽆法分离出去（因为会导致数据不⼀致），这样就⽆法做到真正的读写分离，因为有些场景可能⼤部分都是事物性的读。
解决⽅法： galera for mysql 强⼀致性。
好的实例连接：安装使⽤过程遇到的问题：1、mycat启动后报错，进程直接退出： Error: Exception thrown by the agent : .MalformedURLException: Local host name unknown: .UnknownHostException: ys-fs: ys-fs: Name or service not known原因：本机要配置/etc/hosts 127.0.0.1 主机名⼀、垂直切分测试：1、schema.xml⾥⾯加⼊：<schema name="weixin" checkSQLschema="false" sqlMaxLimit="100" dataNode="weixin" /><schema name="yixin" checkSQLschema="false" sqlMaxLimit="100" dataNode="yixin" /><schema name="sms" checkSQLschema="false" sqlMaxLimit="100" dataNode="sms" /><dataNode name="weixin" dataHost="host0" database="weixin" /><dataNode name="yixin" dataHost="host1" database="yixin" /><dataNode name="sms" dataHost="host2" database="sms" /><dataHost name="host0" maxCon="1000" minCon="10" balance="0"writeType="0" dbType="mysql" dbDriver="native"><heartbeat>select user()</heartbeat><!-- can have multi write hosts --><writeHost host="namenode" url="192.168.168.230:3306" user="root" password="youngsun" /></dataHost><dataHost name="host1" maxCon="1000" minCon="10" balance="0"writeType="0" dbType="mysql" dbDriver="native"><heartbeat>select user()</heartbeat><!-- can have multi write hosts --><writeHost host="hadoop1" url="192.168.168.231:3306" user="root" password="youngsun" /></dataHost><dataHost name="host2" maxCon="1000" minCon="10" balance="0"writeType="0" dbType="mysql" dbDriver="native"><heartbeat>select user()</heartbeat><!-- can have multi write hosts --><writeHost host="hadoop2" url="192.168.168.232:3306" user="root" password="youngsun" /></dataHost>2、server.xml加⼊：<user name="test_wyh"><property name="password">test</property><property name="schemas">weixin,yixin,sms</property></user>3、遇到问题：1)、Caused by: org.xml.sax.SAXParseException; lineNumber: 106; columnNumber: 16; The content of element type "mycat:schema" must match "(schema*,dataNode*,dataHost*)".原因：要按照schema、datanode 、datahost的顺序放，不能打乱。
MyCAT性能测试案例测试案例一：硬件；HP ZooK，8核心CPU，16G内存。
Mycat 版本 1.2 （SVN 445），默认参数，日志级别Info操作系统 windows 7 64Java环境：JDK 7Mysql 版本mysql-Mysql 参数[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 实例上）# range start-end ,data node index# K=1000,M=10000.0-500M=0500M-1000M=11000M-1500M=2测试标准插入1500万数据，100并发线程，最终TPS为17432。
jdbc: test test 100 "0-500M,500M1-1000M,1000M1-1400M"create jobs ...success ful created connections ,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.3038 11 14:26:40 finished records :11413 failed:0 speed:5038.0243 11 14:26:41 finished records :26159 failed:0 speed:8009.4911 14:26:42 finished records :53530 failed:0 speed:12548.0421 11 14:26:43 finished records :78974 failed:0 speed:14994.111 14:26:44 finished records :114310 failed:0 speed:18234.11 14:26:45 finished records :141269 failed:0 speed:19434.2893 11 14:26:46 finished records :171338 failed:0 speed:20715.511 14:26:48 finished records :219441 failed:0 speed:21365.1038 11 14:26:49 finished records :238269 failed:0 speed:21140.0026 11 14:26:50 finished records :273197 failed:0 speed:22263.1294 11 14:26:51 finished records :309299 failed:0 speed:23306.7473 11 14:26:52 finished records :324784 failed:0 speed:22758.2823 11 14:26:53 finished records :351056 failed:0 speed:22986.2311 14:26:54 finished records :362197 failed:0 speed:22258.911 14:26:55 finished records :391662 failed:0 speed:22673.1622 11 14:26:56 finished records :413784 failed:0 speed:22639.809 11 14:26:57 finished records :435309 failed:0 speed:22581.036 11 14:26:58 finished records :464288 failed:0 speed:22897.6327 11 14:26:59 finished records :494561 failed:0 speed:23240.0603 11 14:27:00 finished records :502410 failed:0 speed:22549.6354 11 14:27:01 finished records :514067 failed:0 speed:22080.067 11 14:27:02 finished records :548450 failed:0 speed:22587.611 14:27:03 finished records :582390 failed:0 speed:23036.8585 11 14:27:04 finished records :607036 failed:0 speed:23097.0155 11 14:27:05 finished records :627743 failed:0 speed:23007.5665 11 14:27:06 finished records :661228 failed:0 speed:23372.11 14:27:07 finished records :691299 failed:0 speed:23604.663 11 14:27:08 finished records :702107 failed:0 speed:23181.5463 11 14:27:09 finished records :725410 failed:0 speed:23181.5114 11 14:27:10 finished records :735844 failed:0 speed:22787.8397 11 14:27:11 finished records :749733 failed:0 speed:22519.911 14:27:12 finished records :766561 failed:0 speed:22353.3234 11 14:27:13 finished records :783349 failed:0 speed:22196.9724 11 14:27:14 finished records :794470 failed:0 speed:21891.0378 11 14:27:15 finished records :814713 failed:0 speed:21846.5665 11 14:27:16 finished records :848622 failed:0 speed:22161.0935 11 14:27:17 finished records :870834 failed:0 speed:22162.0013 11 14:27:18 finished records :888461 failed:0 speed:22048.203 11 14:27:19 finished records :917319 failed:0 speed:22213.411 14:27:20 finished records :947460 failed:0 speed:22400.1136 11 14:27:21 finished records :973319 failed:0 speed:22480.1183 11 14:27:22 finished records :983834 failed:0 speed:22204.6887 11 14:27:23 finished records :1008703 failed:0 speed:22262.7884 11 14:27:24 finished records :1024218 failed:0 speed:22117.076 11 14:27:25 finished records :1041733 failed:0 speed:22015.9386 11 14:27:26 finished records :1072460 failed:0 speed:22195.3435 11 14:27:27 finished records :1102339 failed:0 speed:22351.417 11 14:27:28 finished records :1132632 failed:0 speed:22508.3878 11 14:27:29 finished records :1132632 failed:0 speed:22069.7732 11 14:27:30 finished records :1152117 failed:0 speed:22020.532 11 14:27:31 finished records :1177561 failed:0 speed:22084.6872 11 14:27:32 finished records :1202844 failed:0 speed:22143.4685 11 14:27:33 finished records :1220723 failed:0 speed:22066.1795 11 14:27:34 finished records :1245612 failed:0 speed:22116.9092 11 14:27:35 finished records :1267511 failed:0 speed:22112.7242 11 14:27:36 finished records :1278763 failed:0 speed:21926.6115 11 14:27:37 finished records :1307319 failed:0 speed:22038.0516 11 14:27:38 finished records :1337147 failed:0 speed:22167.3513 11 14:27:39 finished records :1355188 failed:0 speed:22099.483 11 14:27:40 finished records :1368471 failed:0 speed:21958.6646 11 14:27:41 finished records :1375259 failed:0 speed:21718.16111 14:27:43 finished records :1419501 failed:0 speed:21730.8197 11 14:27:44 finished records :1437420 failed:0 speed:21673.758 11 14:27:45 finished records :1440410 failed:0 speed:21395.095 11 14:27:46 finished records :1471056 failed:0 speed:21530.9636 11 14:27:47 finished records :1492582 failed:0 speed:21530.343 11 14:27:48 finished records :1503925 failed:0 speed:21385.5715 11 14:27:49 finished records :1530864 failed:0 speed:21463.511 14:27:50 finished records :1544026 failed:0 speed:21348.4467 11 14:27:51 finished records :1581157 failed:0 speed:21563.9453 11 14:27:52 finished records :1585036 failed:0 speed:21326.0498 11 14:27:53 finished records :1613734 failed:0 speed:21423.3443 11 14:27:54 finished records :1637824 failed:0 speed:21458.618 11 14:27:55 finished records :1668520 failed:0 speed:21578.6278 11 14:27:56 finished records :1689672 failed:0 speed:21570.3575 11 14:27:57 finished records :1707774 failed:0 speed:21526.11 14:27:58 finished records :1723926 failed:0 speed:21458.2505 11 14:27:59 finished records :1738865 failed:0 speed:21378.98 11 14:28:00 finished records :1744016 failed:0 speed:21181.7517 11 14:28:01 finished records :1774348 failed:0 speed:21290.2524 11 14:28:02 finished records :1797359 failed:0 speed:21311.2368 11 14:28:03 finished records :1827815 failed:0 speed:21418.0096 11 14:28:04 finished records :1838683 failed:0 speed:21295.124 11 14:28:05 finished records :1838885 failed:0 speed:21053.1886 11 14:28:06 finished records :1862744 failed:0 speed:21084.6563 11 14:28:07 finished records :1878794 failed:0 speed:21028.66 11 14:28:08 finished records :1896975 failed:0 speed:20996.218 11 14:28:09 finished records :1917652 failed:0 speed:20993.8724 11 14:28:10 finished records :1939703 failed:0 speed:21001.471 11 14:28:11 finished records :1961188 failed:0 speed:21005.2047 11 14:28:12 finished records :1982855 failed:0 speed:21011.1393 11 14:28:13 finished records :2000723 failed:0 speed:20978.311 14:28:14 finished records :2016087 failed:0 speed:20920.0405 11 14:28:15 finished records :2033197 failed:0 speed:20880.9846 11 14:28:16 finished records :2059501 failed:0 speed:20934.4687 11 14:28:17 finished records :2085440 failed:0 speed:20985.8677 11 14:28:18 finished records :2097046 failed:0 speed:20891.637 11 14:28:19 finished records :2120359 failed:0 speed:20914.9637 11 14:28:20 finished records :2154339 failed:0 speed:21042.1862 11 14:28:21 finished records :2168268 failed:0 speed:20973.277 11 14:28:22 finished records :2171167 failed:0 speed:20800.113 11 14:28:23 finished records :2188915 failed:0 speed:20771.7695 11 14:28:24 finished records :2215390 failed:0 speed:20825.4996 11 14:28:25 finished records :2244632 failed:0 speed:20903.5922 11 14:28:26 finished records :2265258 failed:0 speed:20900.029 11 14:28:27 finished records :2295885 failed:0 speed:20988.4632 11 14:28:28 finished records :2304754 failed:0 speed:20878.7378 11 14:28:29 finished records :2335127 failed:0 speed:20962.4704 11 14:28:30 finished records :2355359 failed:0 speed:20956.0737 11 14:28:31 finished records :2377976 failed:0 speed:20970.096 11 14:28:32 finished records :2398551 failed:0 speed:20966.255 11 14:28:33 finished records :2420723 failed:0 speed:20977.9412 11 14:28:34 finished records :2447662 failed:0 speed:21028.6175 11 14:28:35 finished records :2470895 failed:0 speed:21047.2436 11 14:28:36 finished records :2483521 failed:0 speed:20975.218311 14:28:38 finished records :2514309 failed:0 speed:20883.11 14:28:39 finished records :2536117 failed:0 speed:20890.0093 11 14:28:40 finished records :2566460 failed:0 speed:20967.634 11 14:28:41 finished records :2584440 failed:0 speed:20943.5347 11 14:28:42 finished records :2600955 failed:0 speed:20907.296 11 14:28:43 finished records :2619541 failed:0 speed:20889.2184 11 14:28:44 finished records :2635754 failed:0 speed:20851.651 11 14:28:45 finished records :2653633 failed:0 speed:20828.2945 11 14:28:46 finished records :2675521 failed:0 speed:20836.5313 11 14:28:47 finished records :2692076 failed:0 speed:20803.11 14:28:48 finished records :2708813 failed:0 speed:20771.6784 11 14:28:49 finished records :2728299 failed:0 speed:20761.2114 11 14:28:50 finished records :2755218 failed:0 speed:20808.0033 11 14:28:51 finished records :2766178 failed:0 speed:20734.559 11 14:28:52 finished records :2790056 failed:0 speed:20757.9586 11 14:28:53 finished records :2804096 failed:0 speed:20708.017 11 14:28:54 finished records :2816743 failed:0 speed:20648.8583 11 14:28:55 finished records :2833107 failed:0 speed:20617.8806 11 14:28:56 finished records :2854420 failed:0 speed:20622.552 11 14:28:57 finished records :2878733 failed:0 speed:20648.402 11 14:28:58 finished records :2898278 failed:0 speed:20640.2132 11 14:28:59 finished records :2924733 failed:0 speed:20681.8744 11 14:29:00 finished records :2940117 failed:0 speed:20644.108 11 14:29:01 finished records :2950875 failed:0 speed:20575.003 11 14:29:02 finished records :2972198 failed:0 speed:20580.5932 11 14:29:03 finished records :2979491 failed:0 speed:20488.858 11 14:29:04 finished records :3010076 failed:0 speed:20557.1423 11 14:29:05 finished records :3031551 failed:0 speed:20563.085 11 14:29:06 finished records :3042804 failed:0 speed:20500.3478 11 14:29:07 finished records :3061056 failed:0 speed:20485.3234 11 14:29:08 finished records :3077733 failed:0 speed:20460.794 11 14:29:09 finished records :3097218 failed:0 speed:20452.4087 11 14:29:10 finished records :3107743 failed:0 speed:20384.5927 11 14:29:11 finished records :3111339 failed:0 speed:20275.558 11 14:29:12 finished records :3131319 failed:0 speed:20273.428 11 14:29:13 finished records :3157026 failed:0 speed:20308.5364 11 14:29:14 finished records :3169783 failed:0 speed:20260.075 11 14:29:15 finished records :3202319 failed:0 speed:20337.3468 11 14:29:16 finished records :3216309 failed:0 speed:20297.503 11 14:29:17 finished records :3230936 failed:0 speed:20262.3145 11 14:29:18 finished records :3260915 failed:0 speed:20322.364 11 14:29:19 finished records :3281844 failed:0 speed:20326.2653 11 14:29:20 finished records :3295531 failed:0 speed:20285.2465 11 14:29:21 finished records :3314117 failed:0 speed:20275.0373 11 14:29:22 finished records :3324289 failed:0 speed:20213.3174 11 14:29:23 finished records :3344884 failed:0 speed:20210.4572 11 14:29:24 finished records :3361621 failed:0 speed:20189.911 14:29:25 finished records :3381885 failed:0 speed:20189.119 11 14:29:26 finished records :3396380 failed:0 speed:20155.364 11 14:29:27 finished records :3414703 failed:0 speed:20144.8962 11 14:29:28 finished records :3421218 failed:0 speed:20064.876 11 14:29:29 finished records :3445349 failed:0 speed:20087.6173 11 14:29:30 finished records :3471349 failed:0 speed:20122.231 11 14:29:31 finished records :3493005 failed:0 speed:20131.08211 14:29:33 finished records :3520764 failed:0 speed:20059.611 14:29:34 finished records :3549329 failed:0 speed:20107.111 14:29:35 finished records :3574662 failed:0 speed:20136.022 11 14:29:36 finished records :3597844 failed:0 speed:20153.424 11 14:29:37 finished records :3597844 failed:0 speed:20041.618 11 14:29:38 finished records :3622279 failed:0 speed:20064.0313 11 14:29:39 finished records :3652147 failed:0 speed:20118.0332 11 14:29:40 finished records :3664975 failed:0 speed:20078.6387 11 14:29:41 finished records :3683470 failed:0 speed:20070.555 11 14:29:42 finished records :3703390 failed:0 speed:20069.0475 11 14:29:43 finished records :3717976 failed:0 speed:20039.2425 11 14:29:44 finished records :3737885 failed:0 speed:20037.7724 11 14:29:45 finished records :3762814 failed:0 speed:20063.8774 11 14:29:46 finished records :3774157 failed:0 speed:20017.5688 11 14:29:47 finished records :3789086 failed:0 speed:19990.5824 11 14:29:48 finished records :3823279 failed:0 speed:20065.0914 11 14:29:49 finished records :3836087 failed:0 speed:20027.0776 11 14:29:50 finished records :3852238 failed:0 speed:20005.2086 11 14:29:51 finished records :3874995 failed:0 speed:20019.19 11 14:29:52 finished records :3891571 failed:0 speed:20002.007 11 14:29:53 finished records :3906258 failed:0 speed:19974.359 11 14:29:54 finished records :3928168 failed:0 speed:19984.7322 11 14:29:55 finished records :3953561 failed:0 speed:20011.994 11 14:29:56 finished records :3985925 failed:0 speed:20073.584 11 14:29:57 finished records :4006511 failed:0 speed:20076.0737 11 14:29:58 finished records :4021077 failed:0 speed:20048.3732 11 14:29:59 finished records :4037935 failed:0 speed:20033.111 14:30:00 finished records :4058966 failed:0 speed:20038.0707 11 14:30:01 finished records :4067491 failed:0 speed:19981.8484 11 14:30:02 finished records :4088875 failed:0 speed:19988.4096 11 14:30:03 finished records :4113723 failed:0 speed:20011.834 11 14:30:04 finished records :4125258 failed:0 speed:19970.434 11 14:30:05 finished records :4140631 failed:0 speed:19948.378 11 14:30:06 finished records :4140631 failed:0 speed:19852.5623 11 14:30:07 finished records :4155197 failed:0 speed:19827.9385 11 14:30:08 finished records :4172663 failed:0 speed:19815.117 11 14:30:09 finished records :4194067 failed:0 speed:19823.993 11 14:30:10 finished records :4213723 failed:0 speed:19822.061 11 14:30:11 finished records :4230894 failed:0 speed:19810.0177 11 14:30:12 finished records :4248783 failed:0 speed:19801.9074 11 14:30:13 finished records :4270117 failed:0 speed:19808.211 14:30:14 finished records :4284622 failed:0 speed:19783.448 11 14:30:15 finished records :4302885 failed:0 speed:19776.9408 11 14:30:16 finished records :4313027 failed:0 speed:19732.11 14:30:17 finished records :4331309 failed:0 speed:19725.956 11 14:30:18 finished records :4351894 failed:0 speed:19729.411 14:30:19 finished records :4361672 failed:0 speed:19684.9505 11 14:30:20 finished records :4381753 failed:0 speed:19686.11 14:30:21 finished records :4400319 failed:0 speed:19681.4383 11 14:30:22 finished records :4424531 failed:0 speed:19701.812 11 14:30:23 finished records :4448642 failed:0 speed:19720.7578 11 14:30:24 finished records :4469511 failed:0 speed:19725.061 11 14:30:25 finished records :4470006 failed:0 speed:19641.2525 11 14:30:26 finished records :4491632 failed:0 speed:19650.09511 14:30:27 finished records :4499359 failed:0 speed:19598.11 14:30:28 finished records :4527198 failed:0 speed:19633.3767 11 14:30:29 finished records :4548652 failed:0 speed:19641.11 14:30:30 finished records :4585642 failed:0 speed:19715.3513 11 14:30:31 finished records :4601046 failed:0 speed:19697.6424 11 14:30:32 finished records :4617440 failed:0 speed:19683.2076 11 14:30:33 finished records :4640087 failed:0 speed:19695.273 11 14:30:34 finished records :4664723 failed:0 speed:19716.363 11 14:30:35 finished records :4689066 failed:0 speed:19736.0346 11 14:30:36 finished records :4703056 failed:0 speed:19711.0137 11 14:30:37 finished records :4725652 failed:0 speed:19723.0336 11 14:30:38 finished records :4741551 failed:0 speed:19707.11 14:30:39 finished records :4751238 failed:0 speed:19665.215 11 14:30:40 finished records :4780673 failed:0 speed:19705.6035 11 14:30:41 finished records :4803117 failed:0 speed:19716.1602 11 14:30:42 finished records :4813581 failed:0 speed:19679.0204 11 14:30:43 finished records :4833076 failed:0 speed:19678.2337 11 14:30:44 finished records :4857218 failed:0 speed:19696.9696 11 14:30:45 finished records :4883289 failed:0 speed:19722.0324 11 14:30:46 finished records :4903248 failed:0 speed:19723.0156 11 14:30:47 finished records :4934733 failed:0 speed:19770.11 14:30:48 finished records :4939349 failed:0 speed:19709.8467 11 14:30:49 finished records :4958996 failed:0 speed:19709.1557 11 14:30:50 finished records :4980966 failed:0 speed:19718.328 11 14:30:51 finished records :5001662 failed:0 speed:19722.011 14:30:52 finished records :5015783 failed:0 speed:19700.034 11 14:30:53 finished records :5028662 failed:0 speed:19673.091 11 14:30:54 finished records :5041430 failed:0 speed:19646.0683 11 14:30:55 finished records :5060794 failed:0 speed:19645.11 14:30:56 finished records :5080693 failed:0 speed:19644.353 11 14:30:57 finished records :5114460 failed:0 speed:19699.918 11 14:30:58 finished records :5114662 failed:0 speed:19624.794 11 14:30:59 finished records :5132218 failed:0 speed:19616.396 11 14:31:00 finished records :5135299 failed:0 speed:19553.3738 11 14:31:01 finished records :5157885 failed:0 speed:19564.404 11 14:31:02 finished records :5177390 failed:0 speed:19564.213 11 14:31:03 finished records :5192228 failed:0 speed:19546.6875 11 14:31:04 finished records :5214662 failed:0 speed:19557.6472 11 14:31:05 finished records :5229834 failed:0 speed:19541.6385 11 14:31:06 finished records :5242723 failed:0 speed:19516.7645 11 14:31:07 finished records :5255814 failed:0 speed:19492.687 11 14:31:08 finished records :5270370 failed:0 speed:19474.4173 11 14:31:09 finished records :5279845 failed:0 speed:19437.2988 11 14:31:10 finished records :5297178 failed:0 speed:19429.9354 11 14:31:11 finished records :5303016 failed:0 speed:19379.8542 11 14:31:12 finished records :5308157 failed:0 speed:19328.11 14:31:13 finished records :5332581 failed:0 speed:19346.666 11 14:31:14 finished records :5358420 failed:0 speed:19370.0883 11 14:31:15 finished records :5370147 failed:0 speed:19342.233 11 14:31:16 finished records :5380238 failed:0 speed:19309.4623 11 14:31:17 finished records :5389319 failed:0 speed:19272.555 11 14:31:18 finished records :5410521 failed:0 speed:19279.3122 11 14:31:19 finished records :5423117 failed:0 speed:19255.4452 11 14:31:20 finished records :5449642 failed:0 speed:19281.5125 11 14:31:21 finished records :5466026 failed:0 speed:19271.720411 14:31:23 finished records :5482652 failed:0 speed:19194.282 11 14:31:24 finished records :5516703 failed:0 speed:19246.0436 11 14:31:25 finished records :5529410 failed:0 speed:19223.1154 11 14:31:26 finished records :5551016 failed:0 speed:19231.6277 11 14:31:27 finished records :5563743 failed:0 speed:19208.6293 11 14:31:28 finished records :5586359 failed:0 speed:19220.5852 11 14:31:29 finished records :5599521 failed:0 speed:19199.9775 11 14:31:30 finished records :5625764 failed:0 speed:19223.3057 11 14:31:31 finished records :5625865 failed:0 speed:19158.544 11 14:31:32 finished records :5654491 failed:0 speed:19190.9456 11 14:31:33 finished records :5670147 failed:0 speed:19174.063 11 14:31:34 finished records :5685551 failed:0 speed:19161.1807 11 14:31:35 finished records :5705743 failed:0 speed:19164.6095 11 14:31:36 finished records :5733814 failed:0 speed:19194.9068 11 14:31:37 finished records :5742622 failed:0 speed:19159.4967 11 14:31:38 finished records :5748511 failed:0 speed:19115.136 11 14:31:39 finished records :5777904 failed:0 speed:19149.11 14:31:40 finished records :5804915 failed:0 speed:19175.0736 11 14:31:41 finished records :5833097 failed:0 speed:19204.8226 11 14:31:42 finished records :5845713 failed:0 speed:19183.07 11 14:31:43 finished records :5870976 failed:0 speed:19202.6438 11 14:31:44 finished records :5894279 failed:0 speed:19216.252 11 14:31:45 finished records :5902380 failed:0 speed:19180.014 11 14:31:46 finished records :5928612 failed:0 speed:19202.911 14:31:47 finished records :5959056 failed:0 speed:19238.6384 11 14:31:48 finished records :5970510 failed:0 speed:19213.11 14:31:49 finished records :5991056 failed:0 speed:19217.5335 11 14:31:50 finished records :6015360 failed:0 speed:19233.838 11 14:31:51 finished records :6023269 failed:0 speed:19197.557 11 14:31:52 finished records :6039349 failed:0 speed:19187.313 11 14:31:53 finished records :6058622 failed:0 speed:19187.482 11 14:31:54 finished records :6079339 failed:0 speed:19192.43 11 14:31:55 finished records :6097016 failed:0 speed:19187.752 11 14:31:56 finished records :6111642 failed:0 speed:19173.3025 11 14:31:57 finished records :6140329 failed:0 speed:19203.031 11 14:31:58 finished records :6171764 failed:0 speed:19241.682 11 14:31:59 finished records :6190006 failed:0 speed:19238.311 14:32:00 finished records :6203066 failed:0 speed:19219.11 14:32:01 finished records :6233279 failed:0 speed:19253.0932 11 14:32:02 finished records :6248137 failed:0 speed:19239.2467 11 14:32:03 finished records :6252036 failed:0 speed:19192.2006 11 14:32:04 finished records :6257915 failed:0 speed:19151.964 11 14:32:05 finished records :6280693 failed:0 speed:19162.651 11 14:32:06 finished records :6290188 failed:0 speed:19133.0523 11 14:32:07 finished records :6308198 failed:0 speed:19129.9194 11 14:32:08 finished records :6328066 failed:0 speed:19131.4808 11 14:32:09 finished records :6350410 failed:0 speed:19141.687 11 14:32:10 finished records :6380309 failed:0 speed:19173.386 11 14:32:11 finished records :6398269 failed:0 speed:19170.2304 11 14:32:12 finished records :6406845 failed:0 speed:19138.0307 11 14:32:13 finished records :6429925 failed:0 speed:19150.7005 11 14:32:14 finished records :6448955 failed:0 speed:19149.6485 11 14:32:15 finished records :6452329 failed:0 speed:19103.011 14:32:16 finished records :6468996 failed:0 speed:19095.55711 14:32:18 finished records :6499500 failed:0 speed:19073.0287 11 14:32:19 finished records :6520450 failed:0 speed:19078.584 11 14:32:20 finished records :6543855 failed:0 speed:19091.282 11 14:32:21 finished records :6565400 failed:0 speed:19098.7474 11 14:32:22 finished records :6583015 failed:0 speed:19094.0123 11 14:32:23 finished records :6598349 failed:0 speed:19082.3946 11 14:32:24 finished records :6617319 failed:0 speed:19082.511 14:32:25 finished records :6626895 failed:0 speed:19055.1135 11 14:32:26 finished records :6644774 failed:0 speed:19051.234 11 14:32:27 finished records :6656672 failed:0 speed:19031.591 11 14:32:28 finished records :6656672 failed:0 speed:18977.0262 11 14:32:29 finished records :6673884 failed:0 speed:18972.0716 11 14:32:30 finished records :6688561 failed:0 speed:18959.728 11 14:32:31 finished records :6706834 failed:0 speed:18957.5142 11 14:32:32 finished records :6734036 failed:0 speed:18980.1747 11 14:32:33 finished records :6742188 failed:0 speed:18950.951 11 14:32:35 finished records :6753865 failed:0 speed:18929.8525 11 14:32:36 finished records :6775612 failed:0 speed:18937.039 11 14:32:37 finished records :6803096 failed:0 speed:18960.4706 11 14:32:38 finished records :6829490 failed:0 speed:18981.4096 11 14:32:39 finished records :6846097 failed:0 speed:18974.9593 11 14:32:40 finished records :6865612 failed:0 speed:18976.618 11 14:32:41 finished records :6878551 failed:0 speed:18959.2575 11 14:32:42 finished records :6894965 failed:0 speed:18952.2767 11 14:32:43 finished records :6912996 failed:0 speed:18950.8693 11 14:32:44 finished records :6924491 failed:0 speed:18929.284 11 14:32:45 finished records :6940824 failed:0 speed:18922.995 11 14:32:46 finished records :6962036 failed:0 speed:18928.694 11 14:32:47 finished records :6972137 failed:0 speed:18905.0782 11 14:32:48 finished records :6984571 failed:0 speed:18887.8657 11 14:32:49 finished records :7005289 failed:0 speed:18892.411 14:32:50 finished records :7024985 failed:0 speed:18894.5298 11 14:32:51 finished records :7035531 failed:0 speed:18872.036 11 14:32:52 finished records :7056632 failed:0 speed:18878.081 11 14:32:53 finished records :7062753 failed:0 speed:18844.0056 11 14:32:54 finished records :7089319 failed:0 speed:18864.8668 11 14:32:55 finished records :7096592 failed:0 speed:18833.8017 11 14:32:56 finished records :7123319 failed:0 speed:18854.117 11 14:32:57 finished records :7138905 failed:0 speed:18845.3623 11 14:32:58 finished records :7141723 failed:0 speed:18803.438 11 14:32:59 finished records :7166965 failed:0 speed:18820.511 14:33:00 finished records :7192410 failed:0 speed:18837.158 11 14:33:01 finished records :7211370 failed:0 speed:18837.8252 11 14:33:02 finished records :7241834 failed:0 speed:18868.853 11 14:33:03 finished records :7260157 failed:0 speed:18866.811 14:33:04 finished records :7276582 failed:0 speed:18860.8827 11 14:33:05 finished records :7301663 failed:0 speed:18876.511 14:33:06 finished records :7304461 failed:0 speed:18834.911 14:33:07 finished records :7322733 failed:0 speed:18833.3737 11 14:33:08 finished records :7348370 failed:0 speed:18850.278 11 14:33:09 finished records :7369864 failed:0 speed:18857.1118 11 14:33:10 finished records :7388601 failed:0 speed:18857.0877 11 14:33:11 finished records :7405016 failed:0 speed:18850.811 14:33:12 finished records :7431986 failed:0 speed:18871.68511 14:33:14 finished records :7460855 failed:0 speed:18849.011 14:33:15 finished records :7483016 failed:0 speed:18857.6487 11 14:33:16 finished records :7504379 failed:0 speed:18863.611 14:33:17 finished records :7524884 failed:0 speed:18867.4782 11 14:33:18 finished records :7548380 failed:0 speed:18879.0673 11 14:33:19 finished records :7571188 failed:0 speed:18888.9678 11 14:33:20 finished records :7590016 failed:0 speed:18888.064 11 14:33:21 finished records :7611612 failed:0 speed:18895.1675 11 14:33:22 finished records :7616622 failed:0 speed:18861.0075 11 14:33:23 finished records :7646016 failed:0 speed:18886.242 11 14:33:24 finished records :7658632 failed:0 speed:18871.57 11 14:33:25 finished records :7682743 failed:0 speed:18884.311 14:33:26 finished records :7703885 failed:0 speed:18889.408 11 14:33:27 finished records :7716723 failed:0 speed:18875.000 11 14:33:28 finished records :7734753 failed:0 speed:18872.99 11 14:33:29 finished records :7762380 failed:0 speed:18894.0015 11 14:33:30 finished records :7782623 failed:0 speed:18897.8474 11 14:33:31 finished records :7803450 failed:0 speed:18902.8187 11 14:33:32 finished records :7824834 failed:0 speed:18908.2716 11 14:33:33 finished records :7832369 failed:0 speed:18880.6903 11 14:33:34 finished records :7854764 failed:0 speed:18889.0795 11 14:33:35 finished records :7875874 failed:0 speed:18894.0464 11 14:33:36 finished records :7897602 failed:0 speed:18901.11 14:33:37 finished records :7920935 failed:0 speed:18911.8585 11 14:33:38 finished records :7932743 failed:0 speed:18894.5434 11 14:33:39 finished records :7943753 failed:0 speed:18876.0513 11 14:33:40 finished records :7960814 failed:0 speed:18871.488 11 14:33:41 finished records :7977642 failed:0 speed:18866.166 11 14:33:42 finished records :7988571 failed:0 speed:18847.0577 11 14:33:43 finished records :8015602 failed:0 speed:18866.7873 11 14:33:44 finished records :8028683 failed:0 speed:18853.741 11 14:33:45 finished records :8044026 failed:0 speed:18845.11 14:33:46 finished records :8073511 failed:0 speed:18870.0004 11 14:33:47 finished records :8082198 failed:0 speed:18846.7303 11 14:33:48 finished records :8109915 failed:0 speed:18866.2115 11 14:33:49 finished records :8125238 failed:0 speed:18858.536 11 14:33:50 finished records :8150126 failed:0 speed:18872.9905 11 14:33:51 finished records :8165875 failed:0 speed:18864.413 11 14:33:52 finished records :8186067 failed:0 speed:18867.9393 11 14:33:53 finished records :8211986 failed:0 speed:18883.987 11 14:33:54 finished records :8223845 failed:0 speed:18868.006 11 14:33:55 finished records :8244613 failed:0 speed:18872.545 11 14:33:56 finished records :8259037 failed:0 speed:18862.11 14:33:57 finished records :8281319 failed:0 speed:18869.5954 11 14:33:58 finished records :8297944 failed:0 speed:18864.4825 11 14:33:59 finished records :8317014 failed:0 speed:18865.166 11 14:34:00 finished records :8332309 failed:0 speed:18857.759 11 14:34:01 finished records :8350553 failed:0 speed:18855.371 11 14:34:02 finished records :8380188 failed:0 speed:18880.0085 11 14:34:03 finished records :8397298 failed:0 speed:18875.019 11 14:34:04 finished records :8423894 failed:0 speed:18893.933 11 14:34:05 finished records :8442652 failed:0 speed:18892.085 11 14:34:06 finished records :8447218 failed:0 speed:18860.911 14:34:07 finished records :8470784 failed:0 speed:18871.749。
