产品概述
应用场景
产品架构
实例类型
兼容性说明
测试项 | 测试值 |
数据量 | 1000万 × 10张表 |
测试模型 | sysbench update non index |
Binlog 订阅节点吞吐量 | 10.5w QPS |
资源规格 | 32C 64G |
CPU 占用 | 4C |
内存占用 | 8.4GB |
测试项 | 测试配置 |
实例规格 | 3MC (4C8G) + 15HyperNode (16C32G) + 1Binlog 订阅节点 (48C96G) |
客户端压力 | 15张表，15并发，共 5w QPS insert |
持续时长 | 72小时 |
同步延迟 | 稳定保持在10s内 |
CREATE TABLE `sbtest1` (`id` bigint NOT NULL,`uid` bigint NOT NULL,`phase` int NOT NULL,`status` int NOT NULL,`detail` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,`createdTime` datetime NOT NULL,`lastModTime` datetime NOT NULL,`business` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,`materialId` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,`materialType` int NOT NULL,`reviewDataId` bigint NOT NULL,`deleteStatus` int NOT NULL,`traceId` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,`reviewDataLogDetail` mediumblob,`physicalFinger` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,`originalFinger` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,`originalResourceId` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,`parentTraceId` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,`grandParentId` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,`parentId` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,PRIMARY KEY (`id`),KEY `idx_materialId` (`materialId`),KEY `idx_uid` (`uid`),KEY `idx_reviewDataId` (`reviewDataId`),KEY `idx_createdTime` (`createdTime`),KEY `idx_phase` (`phase`),KEY `idx_status` (`status`),KEY `idx_parentId` (`parentId`)) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
-- 提升大事务处理能力wait_flush_binlog_cache_max_size = 100MB-- 优化内存使用tdstore_block_cache_size = 300MB
CREATE TABLE ... AS SELECT ...语法，如需恢复，需联系技术支持关闭同步功能并重启实例。文档反馈