I started working on a project whose former developer ragequited, and it left a complete mess both in the code and database. The server is using MySQL 5.5
There are a lot of tables created for backup or test purposes. For example, from all this tables, only two are really being used.
Is there any way to check which tables weren't used in the last XX hours, to be able to safely delete them? Can I set a log for that, besides from the general log, which is really big and fills the available space too quickly?
I cant trust names as in some cases, the table being used is the one that ends with _test or _bk.