Operating System - HP-UX
1827863 Members
2528 Online
109969 Solutions
New Discussion

most queried tables in MySql!

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