MySQL Forums
Forum List  »  Performance

show open tables in_use is high
Posted by: elison chen
Date: December 15, 2015 07:23PM

I check my database which version is mysql5.5,the value of in_use is high on a inondb table,eq: >=16
what is meaning the in_use of show open tables?have 15 query is waiting lock? and i view information_schema.innodb_trx ,but not find any transaction on the table,why ?

Options: ReplyQuote


Subject
Views
Written By
Posted
show open tables in_use is high
2056
December 15, 2015 07:23PM
806
December 16, 2015 08:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.