Id User Host db Command Time State Info 1 root localhost:40925 test Sleep 60 NULL 6 root localhost:40930 test Query 53 closing tables TRUNCATE TABLE t1 7 root localhost:40931 test Query 52 Locked TRUNCATE TABLE t1 8 root localhost:40932 test Query 52 Opening tables ALTER TABLE t1 ENGINE = InnoDB 9 root localhost:40933 test Query 53 Locked TRUNCATE TABLE t1 10 root localhost:40934 test Query 52 NULL SELECT * FROM information_schema . tables WHERE table_schema = TRIM(' test ') AND table_name = TRIM( 11 root localhost:40935 test Query 53 Locked ALTER TABLE t1 ENGINE = InnoDB 12 root localhost:40936 test Query 53 Locked ALTER TABLE t1 ENGINE = InnoDB 13 root localhost:40937 test Query 52 closing tables TRUNCATE TABLE t1 14 root localhost:40938 test Query 53 Locked ALTER TABLE t1 ENGINE = InnoDB 15 root localhost:40939 test Query 53 closing tables TRUNCATE TABLE t1 16 root localhost:40940 test Query 55 closing tables TRUNCATE TABLE t1 17 root localhost:40941 test Query 53 Locked TRUNCATE TABLE t1 18 root localhost:40942 test Query 52 Locked ALTER TABLE t1 ENGINE = InnoDB 19 root localhost:40943 test Query 53 Locked ALTER TABLE t1 ENGINE = InnoDB 20 root localhost:40944 test Query 53 Locked TRUNCATE TABLE t1 21 root localhost:40945 test Query 52 Locked ALTER TABLE t1 ENGINE = InnoDB 22 root localhost:40946 test Query 54 Locked ALTER TABLE t1 ENGINE = InnoDB 23 root localhost:40947 test Query 52 Opening tables ALTER TABLE t1 ENGINE = InnoDB 24 root localhost:40948 test Query 53 Locked ALTER TABLE t1 ENGINE = InnoDB 25 root localhost:40949 test Query 52 Locked ALTER TABLE t1 ENGINE = InnoDB 26 root localhost:40950 test Query 53 Waiting for table ALTER TABLE t1 ENGINE = InnoDB 27 root localhost:40951 test Query 53 Opening tables ALTER TABLE t1 ENGINE = InnoDB 28 root localhost:40952 test Query 53 Locked ALTER TABLE t1 ENGINE = InnoDB 29 root localhost:40953 test Query 53 Locked ALTER TABLE t1 ENGINE = InnoDB 30 root localhost:40954 test Query 53 Opening tables ALTER TABLE t1 ENGINE = InnoDB 31 root localhost:40955 test Query 52 NULL SELECT * FROM information_schema . tables WHERE table_schema = TRIM(' test ') AND table_name = TRIM( 32 root localhost:40956 test Query 53 Opening tables TRUNCATE TABLE t1 33 root localhost:40957 test Query 52 Locked ALTER TABLE t1 ENGINE = InnoDB 34 root localhost:40958 test Query 53 closing tables TRUNCATE TABLE t1 35 root localhost:40959 test Query 53 Opening tables TRUNCATE TABLE t1 36 root localhost:40960 test Query 53 init TRUNCATE TABLE t1 37 root localhost:40961 test Query 52 Locked TRUNCATE TABLE t1 51 root localhost NULL Query 0 NULL SHOW PROCESSLIST