mysql: open tables?

I checked mysql with status command and found that there are 145 open tables. I remember i was able to get a full list of open tables, but forgot how? Can anybody help me?

Is there any tools that can help me to determine what mysql queries exactly using, let's say, more than 20% of proc? I can see with 'top' command that there are few of such but after a week of mysql queries optimization I still can figure what queries are they... mysql: open tables? suggestions?

thanks,
:cheers:

 

 

 

 

Top