April 17th, 2013, 07:06 PM
MySql Table Locking Issues
I have innodb tables created in mySql DB.
The insert or delete requests fails some time because of inno db wait timeout. Which means my request fails to obtain a lock within wait period.
I have only one table. There are many thread which run select queries running on this table. Hence when a delete request comes up it fails to acquire lock.
I know increasing wait timeout is one way. But the best solution would be somehow stop Select queries to acquire lock, as the data being selected by these queries are never getting updated.
I tried READ-UNCOMMITTED
But it throws error :Error 'Binary logging not possible. Message: Transaction level 'READ-UNCOMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'' on query
Is there any solution to achieve this ?