List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:December 9 2009 4:22pm
Subject:Re: Select from remote server from stored procedure
View as plain text  
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.

On Wed, Dec 9, 2009 at 4:13 PM, Neil Aggarwal <neil@stripped>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
>
> --
> Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
> Host your MySQL database on a CentOS VPS for $25/mo
> Unmetered bandwidth = no overage charges, 7 day free trial
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Select from remote server from stored procedureSteven Staples9 Dec
  • RE: Select from remote server from stored procedureNeil Aggarwal9 Dec
    • Re: Select from remote server from stored procedureJohan De Meersman9 Dec
      • Re: Select from remote server from stored procedureHarrison Fisk9 Dec
        • RE: Select from remote server from stored procedureSteven Staples9 Dec
          • RE: Select from remote server from stored procedureNeil Aggarwal9 Dec
            • Use stored proc result set from another stored proc without temptable?Bryan Cantwell9 Dec