Most used tables in MySQL database server Can somebody please help me with a query that lists the most used tables in a MySQL database? Or how can i find out the most used tables in the database?

Thanks
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.