Blog Mauricio Alpizar MySQL Script MySQL – Bloqueo de Tablas

Script MySQL – Bloqueo de Tablas

Muestra las tablas bloqueadas en el MySQL.

SELECT * FROM information_schema.`PROCESSLIST`
WHERE 1 AND COMMAND = 'Query' 
AND `TIME_MS` > 0 ORDER BY COMMAND, `TIME_MS` DESC;

SHOW OPEN TABLES WHERE `Database`=DATABASE() AND ( In_use<>0 OR Name_Locked <> 0 );

Related Post