mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 13 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 31 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 31 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 20 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 31 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 26 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 31 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 31 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 13 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 31 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 31 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 26 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 31 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 31 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 31 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 16 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 34 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 34 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 23 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 34 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 29 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 34 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 34 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 16 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 34 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 34 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 29 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 34 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 34 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 34 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 17 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 35 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 35 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 24 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 35 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 30 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 35 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 35 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 17 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 35 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 35 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 30 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 35 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 35 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 35 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 18 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 36 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 36 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 25 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 36 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 31 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 36 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 36 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 18 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 36 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 36 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 36 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 36 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 36 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 19 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 37 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 37 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 26 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 37 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 32 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 37 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 37 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 19 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 37 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 37 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 32 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 37 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 37 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 37 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 20 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 38 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 38 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 27 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 38 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 33 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 38 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 38 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 20 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 38 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 38 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 33 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 38 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 38 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 38 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 21 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 39 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 39 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 28 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 39 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 34 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 39 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 39 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 21 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 39 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 39 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 39 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 39 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 39 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 22 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 40 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 40 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 29 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 40 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 35 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 40 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 40 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 22 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 40 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 40 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 40 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 40 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 40 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 22 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 40 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 40 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 29 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 40 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 35 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 40 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 40 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 22 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 40 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 40 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 40 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 40 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 40 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 24 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 42 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 42 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 31 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 42 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 37 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 42 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 42 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 24 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 42 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 42 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 42 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 42 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 42 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 25 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 43 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 43 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 32 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 43 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 38 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 43 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 43 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 25 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 43 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 43 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 43 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 43 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 43 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 26 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 44 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 44 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 33 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 44 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 39 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 44 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 44 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 26 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 44 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 44 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 44 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 44 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 44 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 27 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 45 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 45 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 45 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 40 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 45 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 45 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 27 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 45 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 45 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 45 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 45 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 45 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 28 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 46 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 46 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 46 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 41 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 46 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 46 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 28 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 46 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 46 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 41 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 46 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 46 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 46 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 28 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 46 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 46 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 46 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 41 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 46 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 46 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 28 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 46 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 46 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 41 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 46 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 46 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 46 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 29 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 47 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 47 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 47 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 42 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 47 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 47 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 29 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 47 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 47 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 47 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 47 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 47 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 30 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 48 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 48 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 48 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 43 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 48 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 48 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 30 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 48 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 48 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 48 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 48 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 48 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 32 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 50 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 50 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 50 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 45 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 50 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 50 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 32 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 50 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 50 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 50 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 50 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 50 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 33 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 51 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 51 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 51 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 46 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 51 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 51 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 33 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 51 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 51 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 51 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 51 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 51 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 52 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 52 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 41 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 52 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 47 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 52 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 52 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 34 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 52 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 52 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 52 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 52 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 52 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 53 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 53 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 53 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 48 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 53 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 53 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 53 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 53 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 53 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 53 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 53 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 53 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 53 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 53 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 48 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 53 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 53 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 35 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 53 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 53 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 53 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 53 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 53 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 54 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 54 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 54 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 49 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 54 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 54 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 36 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 54 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 54 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 49 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 54 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 54 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 54 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_ex amined | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ | 75 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 78 | root | localhost | test | Query | 55 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 79 | root | localhost | test | Query | 55 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 80 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 82 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 84 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 85 | root | localhost | test | Query | 55 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 87 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 88 | root | localhost | test | Query | 50 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 91 | root | localhost | test | Query | 55 | Sending data | INSERT t1 SELECT 0 FROM t1 AS a1,t1 AS a2 | 0 | 0 | | 93 | root | localhost | test | Query | 55 | updating | DELETE FROM test.t1 | 0 | 0 | | 94 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 100 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 37 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 104 | root | localhost | test | Query | 55 | Sending data | insert into t1 select a+16 from t1 | 0 | 0 | | 109 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 112 | root | localhost | test | Query | 55 | updating | DELETE FROM test.t1 | 0 | 0 | | 113 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 114 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 115 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 116 | root | localhost | test | Query | 55 | updating | DELETE FROM test.t1 | 0 | 0 | | 118 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 121 | root | localhost | test | Query | 55 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 122 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 123 | root | localhost | test | Query | 55 | update | INSERT INTO test.t1 VALUES(1),(1),(1),(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------------+--------------------------------------------------------------------------+-----------+-------- -------+ 26 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+--------------------------------------------------------------------------+-----------+-------------- -+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+--------------------------------------------------------------------------+-----------+-------------- -+ | 75 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 88 | root | localhost | test | Query | 51 | update | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 103 | root | localhost | test | Query | 38 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 115 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+--------------------------------------------------------------------------+-----------+-------------- -+ 6 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_exami ned | +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ | 75 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 88 | root | localhost | test | Query | 52 | query end | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 103 | root | localhost | test | Query | 39 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 115 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ 6 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_exami ned | +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ | 75 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 88 | root | localhost | test | Query | 53 | query end | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 103 | root | localhost | test | Query | 40 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 115 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ 6 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_exami ned | +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ | 75 | root | localhost | test | Query | 41 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 88 | root | localhost | test | Query | 54 | query end | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 103 | root | localhost | test | Query | 41 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 115 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ 6 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_exami ned | +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ | 75 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 49 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 88 | root | localhost | test | Query | 55 | query end | insert INTO t1 values("+111111111.11"),("111111111.11"),("-11111111.11") | 0 | 0 | | 103 | root | localhost | test | Query | 42 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 115 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+-----------+--------------------------------------------------------------------------+-----------+----------- ----+ 6 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 103 | root | localhost | test | Query | 43 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ 4 rows in set (0.01 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 51 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 103 | root | localhost | test | Query | 44 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ 4 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 103 | root | localhost | test | Query | 45 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ 4 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 103 | root | localhost | test | Query | 46 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ 4 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 103 | root | localhost | test | Query | 47 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ 4 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 80 | root | localhost | test | Query | 55 | update | INSERT INTO t1 VALUES(0xA3DD) | 0 | 0 | | 103 | root | localhost | test | Query | 48 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+-------------------------------+-----------+---------------+ 4 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 49 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 49 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ 3 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ 3 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 50 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ 3 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ 3 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 52 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ 3 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 53 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ 3 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ | 75 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(1) | 0 | 0 | | 103 | root | localhost | test | Query | 54 | update | INSERT INTO t1 VALUES(0) | 0 | 0 | | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+--------+--------------------------+-----------+---------------+ 3 rows in set (0.00 sec) mysql> show processlist; +-----+------+-----------+------+---------+------+-------+------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+------+-----------+------+---------+------+-------+------------------+-----------+---------------+ | 125 | root | localhost | test | Query | 0 | init | show processlist | 0 | 0 | +-----+------+-----------+------+---------+------+-------+------------------+-----------+---------------+ 1 row in set (0.00 sec) mysql>