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.ber...@gmail.com wrote:
From: Eric Bergen eric.ber...@gmail.com
Subject: Re: Innodb table space questions
To: Angela liu yyll2...@yahoo.com
Cc: mysql@lists.mysql.com
Date: Monday, January 17, 2011, 10:09 PM
reply inline
On Mon, Jan 17, 2011 at 9:30 PM, Angela liu yyll2...@yahoo.com 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.ber...@gmail.com
http://www.ebergen.net