List:General Discussion« Previous MessageNext Message »
From:Angela liu Date:January 18 2011 7:02am
Subject:Re: Innodb table space questions
View as plain text  
Thanks first,

I checked MySQL 5.1 manual, looks like , 'create tablespace' is ok only with NDB and
NDBCLUSTER, NOT INNODB

And I did not find 'create tablespace' in MySQL 5.5 manual:(

looks like MySQL5.5 does not offer 'create tablespace' anymore.



--- On Mon, 1/17/11, Eric Bergen <eric.bergen@stripped> wrote:

From: Eric Bergen <eric.bergen@stripped>
Subject: Re: Innodb table space questions
To: "Angela liu" <yyll2087@stripped>
Cc: mysql@stripped
Date: Monday, January 17, 2011, 10:09 PM

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