Re: How does the federated engine table work

2006-08-30 Thread Colin Charles
wangxu wrote: > How does the federated engine table work when the query statement include > a join substatement, it joins a local table with innodb engine and a > federated table. How does the server deal with the query substatement like > this? Have you taken a g

Re: question about the query against to the federated engine tables

2006-08-09 Thread Paul McCullagh
ednesday, August 02, 2006 5:29 PM Subject: question about the query against to the federated engine tables I have a question about the query against to the federated engine tables. As the following example: "select Id,name from e01_system.category" Note: the "e01_sys

How does the federated engine table work

2006-08-08 Thread wangxu
please help me thanks. - Original Message - From: "wangxu" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 02, 2006 5:27 PM Subject: How does the federated engine table work > How does the federated engine table work when the query statement include > a

question about the query against to the federated engine tables

2006-08-08 Thread wangxu
who can help me? - Original Message - From: "wangxu" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 02, 2006 5:29 PM Subject: question about the query against to the federated engine tables > I have a question about the query against to the federated engin

query cache about the federated engine

2006-08-08 Thread wangxu
It bring great effect in performance if federated engine can't use the cache. If mysql intend to support it in the future? - Original Message - From: "Michael Loftis" <[EMAIL PROTECTED]> To: "wangxu" <[EMAIL PROTECTED]>; Sent: Thursday, August 03,

Re: query cache about the federated engine

2006-08-02 Thread Michael Loftis
--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 th

question about the query against to the federated engine tables

2006-08-02 Thread wangxu
I have a question about the query against to the federated engine tables. As the following example: "select Id,name from e01_system.category" Note: the "e01_system.category" is a federated table. I select only tow fields from the federated table "

How does the federated engine table work

2006-08-02 Thread wangxu
How does the federated engine table work when the query statement include a join substatement, it joins a local table with innodb engine and a federated table. How does the server deal with the query substatement like this?

query cache about the federated engine

2006-08-02 Thread wangxu
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 use

Re: Federated engine and "comment"???

2005-09-21 Thread Martijn Tonies
Hello Jim, > On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote: > > Did I just see in the documentation that the "comment" clause > > is being misused to supply a connection string for the federated > > engine? > > > > If so, I sure h

Re: Federated engine and "comment"???

2005-09-21 Thread Jim Winstead
On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote: > Did I just see in the documentation that the "comment" clause > is being misused to supply a connection string for the federated > engine? > > If so, I sure hope it will be changed before the final 5.0 r

Re: Federated engine and "comment"???

2005-09-21 Thread Martijn Tonies
> > On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > > > Hi there, > > > > > > Did I just see in the documentation that the "comment" clause > > > is being misused to supply a connection string for the federated > > > eng

Re: Federated engine and "comment"???

2005-09-21 Thread Duncan Hill
> On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > > Hi there, > > > > Did I just see in the documentation that the "comment" clause > > is being misused to supply a connection string for the federated > > engine? > > > > If

Re: Federated engine and "comment"???

2005-09-21 Thread Duncan Hill
On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > Hi there, > > Did I just see in the documentation that the "comment" clause > is being misused to supply a connection string for the federated > engine? > > If so, I sure hope it will be chang

Federated engine and "comment"???

2005-09-21 Thread Martijn Tonies
Hi there, Did I just see in the documentation that the "comment" clause is being misused to supply a connection string for the federated engine? If so, I sure hope it will be changed before the final 5.0 release. "comment" is next to useless like this. It's already b

Re: Federated Engine

2004-12-21 Thread Harrison Fisk
Hi, On Tuesday, December 21, 2004, at 07:59 AM, Luciano Barcaro wrote: Sergei, thanks for the reply, but I coudn´t see any 'useful' info about it . I would like to know the differences (characteristics) between federated and other engines The federated engine allows you to have rem

Re: Federated Engine

2004-12-21 Thread Luciano Barcaro
Sergei, thanks for the reply, but I coudn´t see any 'useful' info about it . I would like to know the differences (characteristics) between federated and other engines Thanks Sergei Golubchik wrote: Hi! It was added ony a few days ago - documentation is catching up still. For now - take a look at

Re: Federated Engine

2004-12-21 Thread Sergei Golubchik
Hi! On Dec 20, Luciano Barcaro wrote: > Hi all, > I downloaded the source from bk tree and I saw the federated engine. > Taking a look into documentation > (http://dev.mysql.com/doc/mysql/en/index.html) I didn?t find anything. > So, where I can find some info about it ? It was

Federated Engine

2004-12-20 Thread Luciano Barcaro
Hi all, I downloaded the source from bk tree and I saw the federated engine. Taking a look into documentation (http://dev.mysql.com/doc/mysql/en/index.html) I didn´t find anything. So, where I can find some info about it ? Thanks in advance. (sorry my poor english ;) ) -- Luciano Barcaro Depto