MySQL Forums
Forum List  »  MyISAM

Change MyISAM Locking Behaviour
Posted by: Irfan Ali
Date: December 08, 2010 05:15AM

We have overall read/write 80%/20% using MyISAM tables. Write queries are coming to slaves from Master Slaves are in use for SELECT queries from site.
I noticed locking issues on slaves. SELECT queries are in queue until INSERT/UPDATE/DELETE executes from replication thread. As per my knowledge FIFO (first in first out) algorithm works in MySQL. I want to change behavior of MyISAM.
I require SELECT's queries have to be exeuctes on top of UPDATE queries. Please let me know is it possible ?

To explain, let's take the test scenario.
1 I have 3 SELECT's queries first on table A.
2 After that 1 INSERT query on table A.
3 Then 1 UPDATE query on table A.
4 Then couple of SELECT's queries on table A.

I believe all sections executes in order from top to bottom i.e. from 1..4.
Is that possible to change it. I want it to be executes as 1,2,4,3.
SELECT queries should have higher priority from UPDATE queries. UPDATE shall be execute in last till no other select query on table A.
I believe it is possible from max_write_lock_count variable.

Options: ReplyQuote


Subject
Views
Written By
Posted
Change MyISAM Locking Behaviour
3947
December 08, 2010 05:15AM
1669
December 09, 2010 10:53PM
1800
December 13, 2010 01:32PM
1607
December 14, 2010 10:19AM


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.