Hello Johan, Thanks for the reply.
On Thu, Sep 2, 2010 at 3:34 AM, Johan De Meersman <vegiv...@tuxera.be> wrote: > 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. > ==> How to define the memory table limit? When the temp table is converted to a disk table, where is this disk table stored? In the same shared tablespace file if I don't use "innodb_file_per_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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
