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.albe...@libero.it>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.prab...@gmail.com > > -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
