So what I am reading, I guess it would be safer to just do it how I am currently doing it, as it really isn't that slow... it's just duplicating the data elsewhere (I suppose maybe making this a slave table to the other server... nah... lots of work there :P)
Thanks, and I did search it before, but I guess my searching keywords were insufficient ;) Steven Staples -----Original Message----- From: harrison.f...@sun.com [mailto:harrison.f...@sun.com] Sent: December 9, 2009 2:07 PM To: Johan De Meersman Cc: Neil Aggarwal; Steven Staples; mysql@lists.mysql.com Subject: Re: Select from remote server from stored procedure Hello Johan, On Dec 9, 2009, at 11:22 AM, Johan De Meersman wrote: > Posted this before, but beware: federated tables do NOT use indices. > Every > select is a full table scan, and if you're talking about a logging > table > that could become very expensive very fast. This is not entirely true. If you define an index on the local federated table, and it makes sense to use it, then a remote WHERE clause will be passed through and hence use the remote index. Not all types of index accesses can be passed through such as this, however for a single row lookup on a primary key, it should be fine. It is still not as fast as local access, but it's not as bad as always doing a full table scan remotely. > On Wed, Dec 9, 2009 at 4:13 PM, Neil Aggarwal > <n...@jammconsulting.com>wrote: > >>> Is this possible to do? To make a connection, inside the >>> stored procedure >>> to a completely different machine and access the mysql there? >> >> The only way I know to access tables from different servers >> from a single connection is federated tables: >> http://dev.mysql.com/doc/refman/5.0/en/federated-use.html >> >> Once you do that, you are accessing it like a local table. >> >> I hope this helps. >> >> Neil Regards, Harrison -- Harrison C. Fisk, MySQL Staff Support Engineer MySQL @ Sun Microsystems, Inc., http://www.sun.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sstap...@mnsi.net No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.97/2550 - Release Date: 12/09/09 02:32:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
