对于 hot inventory中的 hint 请问哪里有解释

[shenlan219]

在 “ AliSQL秒杀场景测试报告样例 ”中的hint，COMMIT_ON_SUCCESS ROLLBACK_ON_FAIL QUEUE_ON_PK 1 TARGET_AFFECT_ROW 1 能否解释下，特别是 QUEUE_ON_PK 1 TARGET_AFFECT_ROW 1 两个值，似乎影响着队列的性能

[zhaiwx1987]

TARGET_AFFECT_ROW 1 means if the number of affected rows doesn't match the hint, it will report an error and consider the statement as failed. If the statement is succeed, COMMIT_ON_SUCCESS means the transaction will be committed automatically, otherwise the transaction will be automatically rollback if specifying ROLLBACK_ON_FAIL.

QUEUE_ON_PK specifies the value of PK. The statements with same primary key will be queued and executed one by one.