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 <dae...@daevid.com> 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:neutronsh...@gmail.com] > > Sent: Wednesday, September 01, 2010 6:05 PM > > To: mysql@lists.mysql.com > > 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=dae...@daevid.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
