How to define the initial space for a table

Is it possible in MySQL to define the initial space that the table is goi=
ng to use and the space for its growth? I usually work on Oracle where th=
e syntax is:

create table MYTABLE
(...fields...)
tablespace MYTABLESPACE
(initial 2M
next 1M);

that means Oracle reserves a data block of 2Mb for the table and where an=
d whether the table will grow, it will allocate more block of 1Mb in the =
tablespace.
How does MySQL behave about that? By the way is there any Manual where it=
's explained how MySQL manage tablespaces, datafiles, ...?
Thanks!


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

Re: How to define the initial space for a table

--0015175746d85833ea048b55c35f
Content-Type: text/plain; charset=ISO-8859-1

I am no sure you are taking about cluster table space or innodb table space.

Just check :


http://dev.mysql.com/doc/refman/5.1/en/create-tablespace.htm l

http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration. html


On Wed, Jul 14, 2010 at 2:52 PM, alba.albetti wrote:

> Is it possible in MySQL to define the initial space that the table is going
> to use and the space for its growth? I usually work on Oracle where the
> syntax is:
>
> create table MYTABLE
> (...fields...)
> tablespace MYTABLESPACE
> (initial 2M
> next 1M);
>
> that means Oracle reserves a data block of 2Mb for the table and where and
> whether the table will grow, it will allocate more block of 1Mb in the
> tablespace.
> How does MySQL behave about that? By the way is there any Manual where it's
> explained how MySQL manage tablespaces, datafiles, ...?
> Thanks!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>
>


--
Best Regards,

Prabhat Kumar
MySQL DBA

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--0015175746d85833ea048b55c35f--