List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:January 18 2011 6:09am
Subject:Re: Innodb table space questions
View as plain text  
reply inline

On Mon, Jan 17, 2011 at 9:30 PM, Angela liu <yyll2087@stripped> wrote:
> Folks :
>
> two questions:
>
> 1. can Innodb create per database table space , not per table table space?

No. The only available options are creating a global tablespace which
can be many files or a file per table.

> 2. can we store table on specific tablespace like Oracle or DB2 when creating table?

You can only choose to store a table in it's own tablespace or in the
global one.

> Many thanks.
>
>
>
>



-- 
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
Thread
Innodb table space questionsAngela liu18 Jan
  • Re: Innodb table space questionsEric Bergen18 Jan
    • Re: Innodb table space questionsAngela liu18 Jan