Information schema locks server
In a slave mysql server with 5.1.37 version every time I do a query on information_schema the query never finish and showing the processlist, the state of it remaining on 'Opening Tables'.
But the worse thing is that all the others client that want to use the server are unable to do because all query remaing in 'Opening Tables' state.
Also if I try to stop the mysql server it fails every time.
Do you have any suggestion to understand the reason on this problem?
Thank you very much
Subject
Views
Written By
Posted
Information schema locks server
4666
November 22, 2013 02:58AM
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.