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
9039
June 18, 2007 02:56AM
Re: Merge over Federated
5203
June 18, 2007 05:13AM
4621
June 18, 2007 06:43PM
5959
June 19, 2007 12:00AM
4491
June 19, 2007 10:03AM
5495
June 27, 2007 05:59PM
4790
June 27, 2007 06:51PM
4429
June 28, 2007 02:47AM
4512
June 28, 2007 03:24AM
4343
June 28, 2007 06:15AM
4863
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.