+------+-------------+------+------+---------+-------+-----------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-------------+------+------+---------+-------+-----------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | system user | | | Daemon | 0 | Waiting for event from ndbcluster | NULL | | 216 | root | | test | Killed | 22205 | updating | delete ignore from `a` where ( ( `a` ) ) like ( ( `a` . `d` is null ) ) | | 753 | root | | test | Killed | 20396 | updating | delete from `a` where ( ( `a` .`a` ) like ( `a` . `d` is null ) ) limit 3 | | 786 | root | | test | Killed | 20278 | updating | delete from `a` where ( `a` .`a` ) like ( ( `a` . `c` is null ) ) | | 836 | root | | test | Killed | 20135 | updating | delete from `a` where ( `a` .`a` like ( `a` . `d` is null ) ) | | 869 | root | | test | Killed | 20016 | updating | delete from `a` where ( ( `a` ) ) like ( ( `a` . `d` is null ) ) | | 946 | root | | test | Killed | 19715 | updating | delete from `a` where ( ( `a` ) ) like ( ( `a` . `c` is null ) ) limit 3 | | 960 | root | | test | Killed | 19690 | updating | delete from `a` where ( `a` .`a` ) like ( ( `a` . `d` is null ) ) limit 4 | | 1023 | root | | test | Killed | 19425 | Sending data | select ( ( `c` .`a` not like `c` . `c` ) ) between( `c` . `d` ) and ( ( +33 ) ) from `a` left join `c` on ( +1 ) where ( `a` .`a` ) like ( ( `a` . `d` is null ) ) into @`b` | | 1027 | root | | test | Killed | 19396 | updating | delete from `a` where ( ( `a` .`a` ) like ( `a` . `d` is null ) ) | | 1110 | root | | test | Killed | 19116 | updating | delete from `a` where ( `a` .`a` like ( `a` . `c` is null ) ) | | 1135 | root | | test | Killed | 19034 | updating | delete from `a` where ( `a` .`a` like ( `a` . `d` is null ) ) limit 3 | | 1487 | root | | test | Killed | 17391 | updating | delete from `a` where ( ( `a` .`a` ) like ( `a` . `c` is null ) ) limit 2 | | 1654 | root | | test | Killed | 16919 | updating | delete from `a` where ( ( `a` .`a` ) ) like ( ( `a` . `d` is null ) ) limit 1 | | 1824 | root | | test | Killed | 16235 | updating | delete from `d` where ( ( `a` ) ) like ( ( ( +2 ) >= FOUND_ROWS() ) ) limit 2 | | 1856 | root | | test | Killed | 16030 | updating | delete ignore from `a` where ( ( `a` ) ) like ( ( `a` . `c` is null ) ) | | 1901 | root | | test | Killed | 15592 | updating | delete ignore from `a` where ( `a` .`a` ) like ( ( `a` . `c` is null ) ) limit 3 | | 1915 | root | | test | Killed | 15900 | updating | delete from `a` where ( ( `a` .`a` ) ) like ( ( `a` . `c` is null ) ) limit 3 | | 2392 | root | | test | Killed | 13783 | updating | delete from `a` where ( `a` .`a` ) like ( ( `a` . `c` is null ) ) limit 2 | | 2483 | root | | test | Killed | 13420 | Sending data | select ST_POLYFROMWKB( ( +1 ) , `a` . `d` ) from `a` where ( ( `a` .`a` ) like ( `a` . `c` is null ) ) limit 1 | | 3123 | root | | test | Killed | 10672 | updating | delete from `a` where ( ( `a` ) ) like ( ( `a` . `c` is null ) ) | | 3257 | root | | test | Killed | 9926 | updating | delete ignore from `d` where ( ( ( -3 ) not like ( `d`. `b` is null ) ) ) and ( ( `d`. `d` is null ) ) | | 3291 | root | | test | Killed | 9623 | updating | delete ignore from `a` where ( `a` .`a` ) like ( ( `a` . `d` is null ) ) limit 2 | | 3304 | root | | test | Killed | 9828 | Sending data | select ( `a` .`a` ) from `a` where ( ( `a` .`a` ) ) like ( ( `a` . `c` is null ) ) limit 1 | | 3417 | root | | test | Killed | 9256 | updating | delete ignore from `a` where ( ( `a` ) like ( `a` . `c` is null ) ) limit 4 | | 3778 | root | | test | Killed | 7410 | updating | delete ignore from `d` where ( ( DIMENSION( ( 1.2 ) ) like ( `d`.`a` is null ) ) ) and ( ( `d`.`a` is null ) ) | | 4165 | root | | test | Killed | 5977 | updating | delete from `a` where ( ( `a` .`a` ) ) like ( ( `a` . `d` is null ) ) limit 4 | | 4913 | root | | test | Killed | 2771 | updating | delete from `a` where ( `a` .`a` like ISNULL( ( `d` ) ) ) | | 5320 | root | | test | Sleep | 0 | | NULL | | 5731 | root | | test | Sleep | 0 | | NULL | | 5857 | root | | test | Sleep | 0 | | NULL | | 5869 | root | | test | Sleep | 0 | | NULL | | 5883 | root | | test | Sleep | 0 | | NULL | | 5884 | root | | test | Query | 0 | init | show full processlist | +------+-------------+------+------+---------+-------+-----------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 34 rows in set (0.01 sec) mysql> show create table test.a\G ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 5894 Current database: test *************************** 1. row *************************** Table: a Create Table: CREATE TABLE `a` ( `a` varchar(255) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) NOT NULL, `d` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY `d` (`d`), KEY `a` (`a`), KEY `b` (`b`), KEY `c` (`c`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8 1 row in set (0.02 sec) mysql>