MySQL删除了记录不生效的原因排查

mysql ::>>select min(id) from XXXX_user_login;
+---------+
| min(id) |
+---------+
|   |
+---------+
 row in set (0.00 sec)

mysql ::>>delete from XXXX_user_login where id < ;
Query OK, row affected (0.00 sec)

mysql ::>>select min(id) from XXXX_user_login;         
+---------+
| min(id) |
+---------+
|   |
+---------+
 row in set (0.00 sec)

[dba_mysql ~]$ /usr/local/mysql/bin/mysql -udba_admin -p -h127.0.0.1 -P4306
Enter password: 
XXXXXXXXXXXXXXXXXXXXXX
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql ::>>select min(id) from XXXXX_user_login;                  
+---------+
| min(id) |
+---------+
|   |
+---------+
 row in set (0.00 sec)

mysql ::>>show variables like '%mit%';   
+--------------------------------+-------+
| Variable_name         | Value |
+--------------------------------+-------+
| automit           | OFF  |
| innodb_mit_concurrency   |   |
| innodb_flush_log_at_trx_mit |   |
+--------------------------------+-------+
 rows in set (0.00 sec)

mysql--dba_admin@127.0.0.1:(none) ::>>
mysql ::>>show global variables like '%mit%';
+--------------------------------+-------+
| Variable_name         | Value |
+--------------------------------+-------+
| automit           | ON  |
| innodb_mit_concurrency   |   |
| innodb_flush_log_at_trx_mit |   |
+--------------------------------+-------+
 rows in set (0.00 sec)

[mysqldump]
quick
max_allowed_packet = M

[mysql]
no-auto-rehash
max_allowed_packet = M
prompt=mysql--\\u@\\h:\\d \\R:\\m:\\s>>
init-mand="set interactive_timeout=28800;set wait_timeout=28800;set automit=0;"