innodb_file_per_table doesn't work

Question

Hello I am trying to use the innodb_file_per_table option of my mysql 5.0.

my relevant my.cnf is:

innodb_data_file_path           = ibdata1:100M:autoextend  
innodb_file_per_table 
innodb_autoextend_increment = 100

but when i drop & recreate my schema & DB, i see the split files for tables, but they are too small! (they dont start from 100MB)

what can be the problem?

thanks!

Answer 1

innodb_autoextend_increment only affects the shared tablespace.

You can set neither the initial size nor the increment size for the per-file tablespaces:

http://forums.mysql.com/read.php?22,26788,63040#msg-63040

Answer 2

Thanks. so if its impossible to autoextend flie-per-table, what is the best performance-wise and fragmentation-wise - to use single shared tablespace or file-per table? thanks!