Re: Does innodb have a temp table space?

2010-09-02 Thread Johan De Meersman
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 !)

Re: Does innodb have a temp table space?

2010-09-02 Thread neutron
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

Re: Does innodb have a temp table space?

2010-09-02 Thread Shawn Green (MySQL)
On 9/2/2010 1:39 PM, neutron wrote: 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

RE: Does innodb have a temp table space?

2010-09-01 Thread Daevid Vincent
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