This is a follow up to my previous question about a long-running INSERT SELECT query that may have exceeded the max_statement_time and was Killed. It has been in the Reset for next command state for 3.5 days. I think it is rolling back changes on the table I was inserting into.
However, that table was empty to begin with, and I would rather terminate this cleanup process, drop the table, and start fresh than continue waiting for it to finish. But I do not know if that would be safe for the general health of the database.
The table that I was copying into had no keys, and thus no foreign_key constraints. It was a bare table that I was planning to index once populated.
What is the quickest way for me to get back to work without doing more harm?
Id User Host db Command Time State
10237 root localhost singlecell Killed 300819 Reset for next command
