Innodb table space questions

--0-1825960614-1295328646=:84336
Content-Type: text/plain; charset=us-ascii

Folks :

two questions:

1. can Innodb create per database table space , not per table table space?

2. can we store table on specific tablespace like Oracle or DB2 when creating table?

Many thanks.




--0-1825960614-1295328646=:84336--

Re: Innodb table space questions

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@gmail.com
http://www.ebergen.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Innodb table space questions

--0-1690347071-1295334127=:65543
Content-Type: text/plain; charset=us-ascii

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 wrote:

From: Eric Bergen
Subject: Re: Innodb table space questions
To: "Angela liu"
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 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@gmail.com
http://www.ebergen.net




--0-1690347071-1295334127=:65543--