Re: Federated
Posted by:
ray pitt
Date: May 17, 2005 01:01PM
The derog Table lives on 192.168.3.208 and is MyISAM compressed. On host 192.168.3.50 a Federated table is created that points to 192.168.3.208. The max_allowed_packet is 4193280. The other Federated table (MyISAM) is abctrans1 which works fine from the Host 192.168.3.50 but is smaller. What is looks like is when a select is done ( in this case count(*)) the entire table is sent (looked in a sniffer) and runs until it is out of memory, which takes 2 minutes and 44 seconds. Then it crashes and returns 0 every other time until it is flushed. Almost like a select, in this case, requires the entire table to be in memory before it can work. This also seems to be the case on the other table abctrans1, but it totally fits in memory.
Subject
Views
Written By
Posted
6781
March 28, 2005 07:20PM
3344
April 18, 2005 06:58PM
Re: Federated
3080
May 17, 2005 01:01PM
3473
May 22, 2005 05:59PM
2996
May 24, 2005 05:51AM
3026
May 25, 2005 12:32PM
3150
August 19, 2005 09:27AM
3207
September 27, 2005 11:29AM
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.