Draft: table level RAW - Githubissues

wesql / wescale

WeScale is a Modern MySQL proxy that supports read-write-split, read-after-write-consistency, load balancing and OnlineDDL.

https://wesql.io

Apache License 2.0

199 stars 8 forks source link

Draft: table level RAW #524

Open terry-xuan-gao opened 2 months ago

terry-xuan-gao commented 2 months ago

Related Issue(s) & Descriptions

Checklist

[ ] Tests were added or are not required
[ ] Documentation was added or is not required

terry-xuan-gao commented 1 month ago

when session1 has a long transaction on t1, other sessions can achieve blocking when querying t1 and non-blocking when querying t2. However, set @@table_level ="off"; has not taken effect. After closing the table-level RAW, querying t2 is still not blocked.

d124d30df42308c01bae15f64122285