Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Description
|
-----------
|
Usually Inventory Center has some hot commodity, corresponding to
|
MySQL table records. So update the record will cause serious contention simultaneously.
|
|
This patch supply a queue for every hot commondity to serialize update
|
according to statement hint.
|
|
Hints:
|
QUEUE_ON_PK
|
COMMIT_ON_SUCCESS
|
ROLLBACK_ON_FAIL
|
TARGET_AFFECT_ROW
|
|
Usage
|
-----
|
update COMMIT_ON_SUCCESS ROLLBACK_ON_FAIL QUEUE_ON_PK 1 TARGET_AFFECT_ROW 1 t1 set c=c-1 where id=1;
|
https://github.com/alibaba/AliSQL/commit/acffb01d72b9bdebb7715b24badf08149a115c06