Hi,
I've just converted my databases so they are using per_table
tablespaces.
When I do a show table status in that database the Comment line
still shows
the amount free, but I assume this doesn't mean anything now ?? It
doesn't
make sense ?
As innodb_file_per_table makes individual files for each table and
each of these files is an autoextending file the information here is
somewhat limited in value. If there is "space available" it's usually
because the table needed to be that large at some point, and since
that point some of the data has been removed. If InnoDB needs more
space than that it will just grow the table's space on disk a little
at the time it needs it. So you don't need to worry about this
generally speaking.
There is an exception to this however... InnoDB can not grow the
table file larger than the Operating System's limits of largest file
size. For example if you can only have a 4Gbyte file on your
Operating System, InnoDB will start complaining the table is full
once your file reaches that size and the space inside the file has
been used. If you do have such a table you will be in trouble unless
you moved it to the shared table space which can exist across several
files, or to MyISAM or some other table type which keeps it's indexes
and data in separate files.
Genrally speaking though, for most people, the "space available"
display doesn't mean much when using the auto extending files created
when you switch to innodb_file_per_table.
Best Regards, Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
