I’ve got a problem concerning the federated table engine:
I created a federated table pointing to a reasonable large remote table (about 800.000 rows, row size 211 Bytes, MyISAM).
When sending the following query:
SELECT * FROM TABLE LIMIT 0,30
the query takes always 9 seconds to complete.
SELECT * FROM TABLE WHERE primaryKey = 1234
is fast as usual (< 0.001s).
I tried tried the federated table on several db servers, always the same result. Now my question is: Does something happen behind the curtain I don’t know off? Does Mysql fetch the whole index without a WHERE clause? Is some internal sorting required?
Anyway, in my opinion the remote db server serving the data should handle this without any delay, shouldn’t it?
Server running the federated engine:
Debian Linux 2.6.18-5-amd64
Server serving the data:
Debian Linux 2.6.8-12-amd64-k8-smp
Thanks for any help!