Comments (6)
replace 产生的 delete 肯定会阻塞 insert
from gravity.
replace 产生的 delete 肯定会阻塞 insert
大佬 我之前过滤掉delete 操作数据恢复正常了, 但是今天突发这种更新很慢的问题 是为啥,还是类似同样的日志,数据是同步给kafka的
from gravity.
updatePrimaryKey 是有主键更新,会拆成先 delete 再 update
为什么慢要贴监控
from gravity.
updatePrimaryKey 是有主键更新,会拆成先 delete 再 update 为什么慢要贴监控
from gravity.
冲突队列很长。
给个最小复现的例子吧。表结构,执行什么样的 sql。
from gravity.
冲突队列很长。 给个最小复现的例子吧。表结构,执行什么样的 sql。
CREATE TABLE bigdatamk_api_label_user_detail_duplicate_4
(
id
BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
label_id
VARCHAR ( 32 ) COLLATE utf8mb4_bin NOT NULL COMMENT '标签ID',
customer_id
VARCHAR ( 64 ) COLLATE utf8mb4_bin NOT NULL COMMENT '会员ID',
statistics_date
date NOT NULL COMMENT '',
label_status
INT ( 11 ) NOT NULL COMMENT '',
group_id
BIGINT ( 20 ) NOT NULL COMMENT '',
seller_id
BIGINT ( 20 ) DEFAULT NULL COMMENT '',
created_at
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
updated_at
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY ( id
),
UNIQUE KEY uniq_user_label
( customer_id
, label_id
),
KEY idx_label_id
( label_id
)) ENGINE = INNODB AUTO_INCREMENT = 917784618319240790 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '标签用户明细数据'
数据是执行replace into 操作
from gravity.
Related Issues (20)
- mysql同步到tidb 延迟大的问题 HOT 5
- job从全量切换到增量的时候,程序出现panic HOT 1
- 启用delete-dml-column filter的时候,在initTableDDL的时候会报错
- 全量任务过程中,在源端对同步的表新增字段,同步报错 HOT 1
- 源端存在没有主键的表,过滤条件失败 HOT 3
- route中增加match-dml-op的问题 HOT 3
- mysql同步到kafka报错 HOT 1
- myesui/uuid not found HOT 1
- 请问GRAVITY 双向同步mysql 是否支持在源目同时更新一条数据,如果做了会有什么结果 HOT 1
- 请问一下,双向同步防止循环原理是什么呢? HOT 3
- 带有唯一索引的表,在进行大批量数据事务的操作下,同步速率低 HOT 39
- CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP 问题 HOT 2
- 两个实例的场景下,相同表,相同主键的数据 可能会下发到不同的分区 HOT 1
- invalid memory address or nil pointer dereference HOT 3
- Unknown character set HOT 5
- mysql 8.0.29 报Unknown character set: 'utf8mb3'
- 采用K8s部署,突然不可以新增任务了 HOT 3
- mariadb做为源库同步报gtid格式非法
- 编译失败 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gravity.