List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:July 14 2010 9:39am
Subject:Re: How to define the initial space for a table
View as plain text  
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.html

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


On Wed, Jul 14, 2010 at 2:52 PM, alba.albetti <alba.albetti@stripped>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=1
>
>


-- 
Best Regards,

Prabhat Kumar
MySQL DBA

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

Thread
How to define the initial space for a tablealba\.albetti14 Jul
  • Re: How to define the initial space for a tablePrabhat Kumar14 Jul