List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:September 2 2010 9:34am
Subject:Re: Does innodb have a temp table space?
View as plain text  
I suspect he is talking about the Temp Tablespace concept from Oracle, which
is different from a temporary table or a memory table.

MySQL will allocate a memory table for sort operation and the like, up until
that table exceeds a preset limit, at which point it will automatically (and
costly !) be converted to a disk table.



On Thu, Sep 2, 2010 at 3:58 AM, Daevid Vincent <daevid@stripped> wrote:

> InnoDB is one of MANY engines in the RDBMS mySQL.
>
> There IS in fact a few ways to store in temporary tables (both RAM and DISK
> based)
>
> http://dev.mysql.com/doc/refman/5.1/en/create-table.html
>
> Look at:
>
> TABLESPACE
> PARTITIONS
> ENGINE
>
> > -----Original Message-----
> > From: neutron [mailto:neutronsharc@stripped]
> > Sent: Wednesday, September 01, 2010 6:05 PM
> > To: mysql@stripped
> > Subject: Does innodb have a temp table space?
> >
> > Hi all,
> >
> > As far as I know, some DB has a separate table space to store temp
> > data (such as for external sort).
> >
> > My questions are:
> >
> > 1. Does innodb also has a separate temp-tablespace?
> > 2.  If I don't use "innodb_file_per_table",   where is innodb's
> > temporary tablespace? Is it in the shared tablespace?
> >
> >
> > Thanks all!
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
Does innodb have a temp table space?neutron2 Sep
  • RE: Does innodb have a temp table space?Daevid Vincent2 Sep
    • Re: Does innodb have a temp table space?Johan De Meersman2 Sep
      • Re: Does innodb have a temp table space?neutron2 Sep
        • Re: Does innodb have a temp table space?MySQL)2 Sep