All of the sudden queries on slave server stopped with status
"Waiting for table level lock"
I restart mysql service and stop replications and locking does not show up anymore. Once I turn replications back on I see huge increase in "waiting for table level lock" status for queries (
show full processlist)
Replication is crucial for our situation and we can't keep it turned off.
What might cause this problem? Replication was running fine for last 5 months or so.