Re: Change MyISAM Locking Behaviour
Posted by:
Irfan Ali
Date: December 13, 2010 01:32PM
DELAY KEY WRITES can cause slave synchronization issue on slave databases results an old info during select queries.
Overall MyISAM indexes size is around 10GB and i configured key_buffer_size is 10GB.
I want DML queries should executes after specific no. of selects on same table. so select will get priorities and executes in parallel and ultimately sorts out locking issue.
Subject
Views
Written By
Posted
3948
December 08, 2010 05:15AM
1669
December 09, 2010 10:53PM
Re: Change MyISAM Locking Behaviour
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.