List:General Discussion« Previous MessageNext Message »
From:alba\.albetti Date:July 14 2010 9:22am
Subject:How to define the initial space for a table
View as plain text  
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!

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