From: Eric Bergen Date: January 18 2011 6:09am Subject: Re: Innodb table space questions List-Archive: http://lists.mysql.com/mysql/224096 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 reply inline On Mon, Jan 17, 2011 at 9:30 PM, Angela liu 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