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>
Date: Monday, January 17, 2011, 10:09 PM
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
> Many thanks.