List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:September 2 2010 1:58am
Subject:RE: Does innodb have a temp table space?
View as plain text  
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
> 

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