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
