Update a field with the index, find updated slowly, after going to stop, then close the query session in visual operation, found that cannot close behind, with the kill command to kill, a killed status has been a hard, just so I just turned off to restart, restart, found themselves unable to delete index, an error: 1205 - Lock wait timeout exceeded; Try restarting transaction
Use the SELECT * FROM information_schema. INNODB_TRX; Query, found a thread trx_mysql_thread_id=0, plans to use the kill 0; Kill, but an error: 1094 - Unknown thread id: 0
CodePudding user response:
Use show the processlist check each thread state in current mysql, see if there is a process there have been problems,