--On August 2, 2006 5:25:51 PM +0800 wangxu <[EMAIL PROTECTED]> wrote:
I have a problem about the performance of federated engine. The
mysql5.0 reference manual says that the FEDERATED tables do not work with
the query cache, aren't they? How about the query cache used by the
federated engine in the mysql5.1? If the query cache cann't be used
with the federated engine tables still, how to enhance the query
performance against to the federated tables effectively?
Well for one if the machine isn't on the same LAN you'll never have good DB
performance -- not sure if this is the case or not, just a helpful hint.
For two, the reason why federated doesn't use the query cache is then you
have to somehow invalidate the remote cache(s) which would require some
form of protocol extension, either in the SQL or the over the wire protocol
so that the server with the federated table could ask if it could cache a
result, and the server that's serving to the federated client could inform
that server when it's cache isn't valid.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
