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
