How to define the initial space for a table

2010-07-14 Thread alba.albetti
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

Re: How to define the initial space for a table

2010-07-14 Thread Prabhat Kumar
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.itwrote: