MySQL Forums
Forum List  »  Federated Storage Engine

Federate gives high network load
Posted by: Martijn Dijkstra
Date: May 31, 2007 03:50AM

We are using the Federated engine for over a year now, but i can still not figure out how to solve the problem with high network load.
Example
Server A (MySQL version 5.0.17-log) contains data with a DB with 260 tables(4=InnoDB ,256=ARCHIVE) totaal size is about 350MB.
Server B (MySQL version 5.0.26 ) having a FEDERATED database with the 260 tables.

Somehow the network status between the server gives a data transfer of +-30Mbit/s from A to B.
I would like to know howe to solve this. It looks like that a query on a table on server B transfers the data from the table on A to B and then does the select wich gives 1 row result.
How can I make it to work that the query gives 1 row result from A parsed to server B?

Options: ReplyQuote


Subject
Views
Written By
Posted
Federate gives high network load
5370
May 31, 2007 03:50AM


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.