如何跟踪MySQL上表中已删除的行？

I have foreign key constraints set on my MySQL tables that cascade on delete. I need to keep track of all the other tables and rows affected when I delete a user because there are physical files involved that must also be deleted. Is there a way to log this?I have foreign key constraints set on my MySQL