InnoDB INFORMATION_SCHEMA Transaction and Locking Information The following table shows the contents of the  INNODB_TRX  table for a system running a heavy workload. ID USER HOST DB COMMAND TIME STATE INFO 4 root localhost test Query 0 preparing SELECT * FROM PROCESSLIST 2 root localhost test Sleep 566 NULL trx id trx state trx started trx requested lock id trx wait started trx weight trx mysql thread id trx query 77F LOCK WAIT 2008-01-15 13:10:16 77F 2008-01-15 13:10:16 1 876 INSERT INTO t09 (D, B, C) VALUES … 77E LOCK WAIT 2008-01-15 13:10:16 77E 2008-01-15 13:10:16 1 875 INSERT INTO t09 (D, B, C) VALUES … 77D LOCK WAIT 2008-01-15 13:10:16 77D 2008-01-15 13:10:16 1 874 INSERT INTO t09 (D, B, C) VALUES … 77B LOCK WAIT 2008-01-15 13:10:16 77B:733:12:1 2008-01-15 13:10:16 4 873 INSERT INTO t09 (D, B, C) VALUES … 77A RUNNING 2008-01-15 13:10:16 NULL NULL 4 872 SELECT b, c FROM t09 WHERE … E56 LOCK WAIT 2008-01-15 13:10:06 E56:743:6:2 2008-01-15 13:10:06 5 384 INSERT INTO t2 VALUES … E55 LOCK WAIT 2008-01-15 13:10:06 E55:743:38:2 2008-01-15 13:10:13 965 257 INSERT INTO t2 VALUES … 19C RUNNING 2008-01-15 13:09:10 NULL NULL 2900 130 INSERT INTO t2 VALUES … E15 RUNNING 2008-01-15 13:08:59 NULL NULL 5395 61 INSERT INTO t2 VALUES … 51D RUNNING 2008-01-15 13:08:47 NULL NULL 9807 8 INSERT INTO t2 VALUES … The following table shows the contents of the  data_lock_waits  table for a system running a heavy workload. 3305