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
> -----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: