Q:

How to see mysql activity logs, audit table did not record anything

something happened and our staging db has removed many tables, need to know what happened and when.  we are using MySQL
audit table doesn't seem to record anything

A:

The MySQL binary log will record all queries that affect any rows - but will only do you any good if it's enabled. 
Look for a log-bin setting in your my.cnf.