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=arch...@jab.org