single_table_threads测试（分区表导出）

20220317后支持。

mysql测试

测试表sql

CREATE TABLE table_partition (
`id` int(11) NOT NULL,
  `customerid` int(11) NOT NULL,
  `bus_client_product_object_id` int(11) NOT NULL,
  `fullSyncCnt` bigint(20) DEFAULT '0' COMMENT '全量装载数量',
  `fullSyncSeconds` int(11) DEFAULT '0' COMMENT '全同步时间',
  `fullPercent` int(11) DEFAULT '0',
  `realOffset` bigint(20) DEFAULT '0',
  `fullOffset` bigint(20) DEFAULT '0',
  `fullTopic` varchar(128) DEFAULT NULL COMMENT '全量topic名字',
  `full_sync_time` datetime DEFAULT NULL,
  `StartRealOffset` bigint(20) DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
     )
  PARTITION BY HASH( id )
  PARTITIONS 100;
insert into table_partition select * from databus_v4.bus_client_op_status_info;
insert into table_partition select * from table_partition;

single_table_threads=0时

single_table_threads=6时

tableexp测试

../bin/tableexp mysql:zbomc/'1qaz!QAZ'@172.17.58.146:3306 -table zcbus.table_partition -edir ./tmp

../bin/tableexp mysql:zbomc/'1qaz!QAZ'@172.17.58.146:3306 -table zcbus.table_partition -edir ./tmp -thread 6

oracle

测试表sql

CREATE TABLE table_partition (
ID                       NUMBER(38),
CUSTOMERID                 NUMBER(38),
BUS_CLIENT_PRODUCT_OBJECT_ID         NUMBER(38),
FULLSYNCCNT                        NUMBER,
FULLSYNCSECONDS                    NUMBER(38),
FULLPERCENT                        NUMBER(38),
REALOFFSET                        NUMBER,
FULLOFFSET                        NUMBER,
FULLTOPIC                        VARCHAR2(384),
FULL_SYNC_TIME                     DATE,
STARTREALOFFSET                    NUMBER,
UPDATE_TIME                        TIMESTAMP(6)
     )
  PARTITION BY HASH( id )
  PARTITIONS 100;
insert into table_partition select * from bus_client_op_status_info;
insert into table_partition select * from table_partition;

single_table_threads=0时

single_table_threads=6时

tableexp测试

../bin/tableexp oracle:zcbus/zcbus@172.17.46.244:1521/orcl -table ZFL.TABLE_PARTITION -edir ./tmp

../bin/tableexp oracle:zcbus/zcbus@172.17.46.244:1521/orcl -thread 6 -table ZFL.TABLE_PARTITION -edir ./tmp

oracle-lob字段测试

alter table ZFL.TABLE_PARTITION add lob_col blob;
update TABLE_PARTITION set lob_col = rawtohex('BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试BLOB测试');
../bin/tableexp oracle:zcbus/zcbus@172.17.46.244:1521/orcl -thread 6 -table ZFL.TABLE_PARTITION -edir ./tmp