How to recover from two queries stuck in kill state causing all the database to not respond?
Please seem my answer to your other similar question involving innodb_force_recovery = 4 https://dba.stackexchange.com/a/53355/30545