[MDEV-11407] AliSQL: [Feature] issue #33 HINT SOLUTION FOR INVENTORY Created: 2016-11-29  Updated: 2018-02-14

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Sergey Vojtovich Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Epic Link: AliSQL patches

 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


Generated at Thu Feb 08 07:49:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.