Ulf Wendel

2011/11/29
by admin
Comments Off on Waiting for table metadata lock and PECL/mysqlnd_ms

Waiting for table metadata lock and PECL/mysqlnd_ms

The MySQL administration SQL command SHOW PROCESSLIST may read "Waiting for table metadata lock" in its "State" column for a statement. The statement in question is waiting for another transaction to release a metadata lock. Its a state that may … Continue reading

2011/11/29
by admin
Comments Off on PECL/mysqlnd_ms global transaction ID injection status

PECL/mysqlnd_ms global transaction ID injection status

Baby PECL/mysqlnd_ms 1.2.0-alpha, the PHP MySQL replication and load balancing plugin for mysqlnd, has done its first steps into the direction of global transaction id injection: injection happens, IDs can be queried. A simulated global transaction ids can be described … Continue reading