My MariaDB server crashed earlier today and is still recovering. The error log shows
InnoDB: To roll back: 1 transactions, 519345 rows
From the log entries it appears that the rollback is going to take approximately 4 hours to finish. And my website is barely responding since the server is busy with the rollback.
Based on the number of rows that were affected by the transaction that is being rolled back, I suspect that the server is trying to rollback a transaction involving a log table. If that is the case, I don't mind losing the data.
How can I find the tables that are affected by the transaction that is being rolled back? If it is indeed a non critical table, how can I skip the rollback?