mysql_distribute_lock
2016-12-06 11:14:26 0 举报
mysql分布式事务所
作者其他创作
大纲/内容
failed
LockID
ownerid != null
更新失败
更新成功
expire current
update xx set ownerid=yourid and expretime=newexpiretime where lockid=lockid and expiretime=oldexpiretime
ownerid == nullupdate xx set ownerid = yourid and expretime=newexpiretimewhere lockid = lockid and expretime=oldexpretime
OWNERID
acquire lock success
acquire lock failed
EXPIRETIME
acquire failed
select * from xx where lockID = xxx
0 条评论
下一页