From: Daevid Vincent
Date: September 2 2010 1:58am
Subject: RE: Does innodb have a temp table space?
List-Archive: http://lists.mysql.com/mysql/222778
Message-Id: <3EA630D29D724F3BBFD1DBAE56300EE9@mascorp.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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=daevid@stripped
>