Information schema locks server
Posted by: Andrea Ponzo
Date: November 22, 2013 02:58AM

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

Options: ReplyQuote

Written By
Information schema locks server
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.