When should I use the autoextend option for the InnoDB file...Even after emptying the tables the files keeps its size and for new insertions it gets even bigger instead of using the already allocated space(which I suppose should be available after emptyibg the tables).
thank you friends aik_b p.s. MySQL doesn't seem to do a good usage of the disk space and the InnoDB file size and its density..anyway
