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
8730
June 18, 2007 02:56AM
Re: Merge over Federated
4997
June 18, 2007 05:13AM
4469
June 18, 2007 06:43PM
5812
June 19, 2007 12:00AM
4349
June 19, 2007 10:03AM
5325
June 27, 2007 05:59PM
4647
June 27, 2007 06:51PM
4285
June 28, 2007 02:47AM
4374
June 28, 2007 03:24AM
4195
June 28, 2007 06:15AM
4703
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.