Tcp port: 0 Unix socket: (null) Time Id Command Argument 051122 15:46:48 1 Connect root@localhost on 1 Query SET SQL_SELECT_LIMIT=1000 1 Query SHOW DATABASES 051122 15:46:50 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 051122 15:46:53 2 Connect root@localhost on 2 Query SET SQL_SELECT_LIMIT=1000 051122 15:47:04 2 Query CREATE DATABASE IF NOT EXISTS deadlock 2 Query USE deadlock 2 Query SELECT database() 2 Init DB deadlock 2 Query SHOW TABLES 2 Query CREATE TABLE test ( id bigint(20) NOT NULL auto_increment, value bigint(20) NOT NULL, PRIMARY KEY (id), INDEX (value) ) ENGINE=InnoDB 2 Query CREATE TABLE test1 ( id bigint(20) NOT NULL auto_increment, value bigint(20) NOT NULL, test_id_ref bigint(20) NOT NULL, FOREIGN KEY (test_id_ref) REFERENCES test (id) on delete cascade, PRIMARY KEY (id), INDEX (test_id_ref) ) ENGINE=InnoDB 2 Query INSERT INTO test VALUES (1, 1) 2 Query INSERT INTO test VALUES (2, 2) 2 Query INSERT INTO test VALUES (3, 3) 2 Query INSERT INTO test VALUES (4, 4) 2 Query INSERT INTO test VALUES (5, 5) 2 Query INSERT INTO test1 VALUES (1, 1, 1) 2 Query INSERT INTO test1 VALUES (2, 2, 2) 2 Query INSERT INTO test1 VALUES (3, 3, 3) 2 Query INSERT INTO test1 VALUES (4, 4, 4) 2 Query INSERT INTO test1 VALUES (5, 5, 5) 051122 15:47:10 3 Connect root@localhost on deadlock 051122 15:47:11 3 Query SET NAMES latin1 3 Query SET character_set_results = NULL 3 Query SHOW VARIABLES 3 Query SHOW COLLATION 3 Query SET autocommit=1 4 Connect root@localhost on deadlock 4 Query SET NAMES latin1 4 Query SET character_set_results = NULL 4 Query SHOW VARIABLES 4 Query SHOW COLLATION 4 Query SET autocommit=1 5 Connect root@localhost on deadlock 5 Query SET NAMES latin1 5 Query SET character_set_results = NULL 5 Query SHOW VARIABLES 5 Query SHOW COLLATION 5 Query SET autocommit=1 6 Connect root@localhost on deadlock 6 Query SET NAMES latin1 6 Query SET character_set_results = NULL 6 Query SHOW VARIABLES 6 Query SHOW COLLATION 6 Query SET autocommit=1 7 Connect root@localhost on deadlock 7 Query SET NAMES latin1 7 Query SET character_set_results = NULL 7 Query SHOW VARIABLES 7 Query SHOW COLLATION 7 Query SET autocommit=1 3 Query SET autocommit=0 3 Query SELECT * FROM test WHERE id IN (1) 3 Query DELETE FROM test1 WHERE test_id_ref = 1 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query commit 3 Query SET autocommit=0 3 Query SELECT * FROM test WHERE id IN (1) 3 Query DELETE FROM test1 WHERE test_id_ref = 1 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 4 Query SET autocommit=0 4 Query SELECT * FROM test WHERE id IN (2) 4 Query DELETE FROM test1 WHERE test_id_ref = 2 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query commit 3 Query SET autocommit=0 3 Query SELECT * FROM test WHERE id IN (1) 3 Query DELETE FROM test1 WHERE test_id_ref = 1 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 5 Query SET autocommit=0 5 Query SELECT * FROM test WHERE id IN (3) 5 Query DELETE FROM test1 WHERE test_id_ref = 3 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 6 Query SET autocommit=0 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 6 Query SELECT * FROM test WHERE id IN (4) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 6 Query DELETE FROM test1 WHERE test_id_ref = 4 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query commit 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 3) 6 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 4) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 3 Query SET autocommit=0 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 3) 5 Query commit 5 Query SET autocommit=0 3 Query SELECT * FROM test WHERE id IN (1) 5 Query SELECT * FROM test WHERE id IN (3) 5 Query DELETE FROM test1 WHERE test_id_ref = 3 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 3) 3 Query DELETE FROM test1 WHERE test_id_ref = 1 7 Query SET autocommit=0 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 7 Query SELECT * FROM test WHERE id IN (5) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 3) 7 Query DELETE FROM test1 WHERE test_id_ref = 5 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 3) 5 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 3) 5 Query commit 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 5) 5 Query SET autocommit=0 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 5) 5 Query SELECT * FROM test WHERE id IN (3) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 5) 5 Query DELETE FROM test1 WHERE test_id_ref = 3 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 5) 051122 15:47:12 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 5) 7 Query commit 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 7 Query SET autocommit=0 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 7 Query SELECT * FROM test WHERE id IN (5) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 7 Query DELETE FROM test1 WHERE test_id_ref = 5 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 1) 3 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 1) 3 Query commit 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 5) 3 Query SET autocommit=0 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 5) 3 Query SELECT * FROM test WHERE id IN (1) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 5) 3 Query DELETE FROM test1 WHERE test_id_ref = 1 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (1, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (8, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (0, 5) 6 Query SHOW ENGINE INNODB STATUS 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (7, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (9, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (6, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (2, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (4, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (3, 5) 7 Query INSERT INTO test1 (value, test_id_ref) VALUES (5, 5) 051122 15:47:27 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 1 Statistics 8 Connect root@localhost on 8 Query SET SQL_SELECT_LIMIT=1000 8 Query SHOW FULL PROCESSLIST 8 Query SHOW GLOBAL VARIABLES 8 Query SHOW GLOBAL VARIABLES LIKE 'have_innodb' 8 Query SHOW INNODB STATUS 8 Query SHOW STATUS