I ran "kill process ID" in MySQL, but the process did not finish successfully.
mysql>SHOW FULL PROCESSLIST;
+-----+-----------------+-----------------+------+---------+---------+------------------------+------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+-----------------+-----------------+------+---------+---------+------------------------+------------------------------------------------+
| 4 | event_scheduler | localhost | NULL | Daemon | 1230134 | Waiting on empty queue | NULL |
| 29 | root | localhost:56181 | umls | Killed | 951492 | executing | SELECT COUNT(*) as count FROM `UMLS`.`MRCONSO` |
| 152 | root | localhost | NULL | Query | 0 | starting | SHOW FULL PROCESSLIST |
+-----+-----------------+-----------------+------+---------+---------+------------------------+------------------------------------------------+
3 rows in set (0.00 sec)
Do I have to wait for a while?
I would appreciate it if you could tell me how to deal with it.
Rather than shutting down the process, the Kill command in MySQL determines that the process should not be terminated without or without a forced termination flag during execution.
The timing of checking the forced termination flag depends on what query you are running.
Check the references as well.
https://dev.mysql.com/doc/refman/5.6/ja/kill.html
KILL sets the thread-specific forced termination flag for that thread.In most cases, it may take some time for the thread to end because the forced-stop flag is checked only at the following regular intervals:
© 2024 OneMinuteCode. All rights reserved.