Showing results for 
Search instead for 
Did you mean: 

most queried tables in MySql!

Occasional Advisor

most queried tables in MySql!

i like to find out the table name which has been queried maximum number of times i MySql.dont ask me why.

i have chosen to monitor the .mysql_history to retrieve this information but this file gets updated only when the connection to the server is closed. The file contains what ever we type in the client console. but i have no idea whether if we connect it form an application program the informations gets stored in this file.

is there any good option , plz suggest me.