ShuNing
ShuNing
looks good to me~
I think it's more user friendly.
Hi @monkey1993 , 怎么确认是失败的; 可以把步骤和 tidb 版本贴一下。建议去 tidb repo 提 issue
这个预期是在这个范围内尽可能新的数据(可能是最新也可能是旧的),不是读指定历史时间点的数据,SET @@tidb_read_staleness = "-60" 语义上等同于: `SELECT * FROM TABLE test AS OF TIMESTAMP TIDB_BOUNDED_STALENESS(NOW() - INTERVAL 60 SECOND, NOW())` 参考这里:https://docs.pingcap.com/zh/tidb/stable/as-of-timestamp#%E8%AF%AD%E6%B3%95%E6%96%B9%E5%BC%8F
> 那这个只能用于读取`5秒前`到`现在`的数据(有可能是最新的,也有可能是旧的),限定了结束时间是:现在,那...直接用SELECT就好了,没必要设置这个系统变量了。 > > 然后,下边的[示例](https://docs.pingcap.com/zh/tidb/stable/tidb-read-staleness#%E7%A4%BA%E4%BE%8B)在讲的是这样读到历史数据,我按照示例SQL操作,结果和示例不同,没能读到历史记录。 嗯,这个例子没有表达出这个语义,需要换一个更合适的,能不能读到新的版本取决于同步的速度。这个 session variable 是为了解决一些历史读,但是有尽可能读到新一些的版本的场景。如果想要指定特定时间可以 `AS OF` 或者 `tidb_snapshot` 都可以。
cc @qidi1 @IcePigZDB
Yes, TopSQL can tell me that this SQL is consuming a lot of CPU. It's useful to the user, but it's not enough for an advanced user or expert. TopSQL...
Does this reproduce in the master version?
> > The data needs some time to schedule before it can actually be transferred to another DC, and before the schedule is complete, the binding between the data and...
@gyuho after restarting all node, the service seems to go well, but I pointed out that the reading of the keys is inconsistent. and I still try to reproduce it.