… ALTER is a multi-step process, the old table is locked in shared mode and then something similar to the following steps are taken… I have reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that are serviced from… interesting case this time with how Active MQ uses MySQL when in HA mode. In HA mode there are two Active MQ servers, both try…
Comment: Are PHP persistent connections evil ?
November 14, 2008 By 32 Comments
…! in PHP mySQL, the use of SELECT FOR UPDATE and SELECT LOCK IN SHARE MODE, How to use it? They don’t make any sense to me in… the client, so there is an auto mysql_close.(Which would rollback your transaction in the SELECT) With a persistent connection, may… is no way to store the connection persistent link resource in a session or anywhere else, so there is no way…
Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE
January 31, 2010 By 51 Comments
… MySQL server version for the right syntax to use near ‘IN SHARE MODE‘ at line 1] my syntax is correct i use this one…LOCK TABLE hotels IN SHARE MODE and LOCK TABLE hotels IN EXCLUSIVE MODE… ..i… a transactional lock returns an error). heres the link if you want to see it.. http://bugs.mysql.com/bug.php?id=46663
