Re: Merge over Federated
All queries on the Federated is performed on the Merge table, the Merge table performs operation on the underlying MyISAM. So, the locking is propagate from federated to Merge, and Merge can only be locked after the underlying MyISAM tables are locked.
Parallel queries on multiple Federated is possible, but still perform according to locking on the Merge table, the queries will have to wait for the lock on the Merge table. So, effectively Write is still one after another, concurrent reads of course is possible with Merge and MyISAM.
Subject
Views
Written By
Posted
9044
June 18, 2007 02:56AM
Re: Merge over Federated
5209
June 18, 2007 05:13AM
4622
June 18, 2007 06:43PM
5965
June 19, 2007 12:00AM
4506
June 19, 2007 10:03AM
5502
June 27, 2007 05:59PM
4793
June 27, 2007 06:51PM
4432
June 28, 2007 02:47AM
4516
June 28, 2007 03:24AM
4347
June 28, 2007 06:15AM
4864
July 06, 2007 08:31AM
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.