Most used tables in MySQL database server
show open tables might help you or you can view queries from general log if enabled. You can also check binary logs from mysqlbinlog utility for further analysis.

Hope it help.