mysql开启事务并锁表_MySQL：如何锁定表并启动事务？

如果是我,我会在MySQL中使用

advisory locking function来实现用于更新缓存的互斥锁,以及用于读取隔离的事务.例如

begin_transaction(); // although reading a single row doesnt really require this

$cached=runquery("SELECT * FROM cache WHERE key=$id");

end_transaction();

if (is_expired($cached)) {

$cached=refresh_data($cached, $id);

}

...

function refresh_data($cached, $id)

{

$lockname=some_deterministic_transform($id);

if (1==runquery("SELECT GET_LOCK('$lockname',0)") {

$cached=fetch_source_data($id);

begin_transaction();

write_data($cached, $id);

end_transaction();

runquery("SELECT RELEASE_LOCK('$lockname')");

}

return $cached;

}

(顺便说一句：如果你用持久连接尝试这个可能会发生坏事)