CGI: Ver bloqueo INNOBD AGD

• Version mysql

SELECT VERSION();

• Obtener log de los bloqueos

SHOW ENGINE INNODB STATUS;

• Consultar tiempo de innobd

SHOW VARIABLES LIKE 'innodb_lock_wait_timeout';

• Ver los bloqueos

-- Ver bloqueos de forma más clara con sys schema
SELECT 
    r.trx_id AS waiting_trx_id,
    r.trx_mysql_thread_id AS waiting_thread,
    r.trx_query AS waiting_query,
    r.trx_state,
    TIMESTAMPDIFF(SECOND, r.trx_wait_started, NOW()) AS wait_seconds
FROM performance_schema.data_lock_waits w
JOIN information_schema.innodb_trx r ON r.trx_id = w.REQUESTING_ENGINE_TRANSACTION_ID
ORDER BY wait_seconds DESC;