1. 查看进程

      1. SHOWP ROCESSLIST;

    2. 查看是否锁表

      SHOW OPEN TABLES WHERE In_use > 0;

    3. 查看正在锁的事务

      SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;

    4. 查看等待锁的事务

      SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;

    5. 1231