Hi,
The comment is just telling you how much free space is in your InnoDB
datafile(s). When that approaches 0, InnoDB will add the data file.
Image that there's a box, say it Innodb tablespace, this box is consist of
your data,
and innodb free is the same as the (capacity of your box - usage)
To increase the size simply add innodb data file.
MySQL documentation: The data files (tables) that you define in an InnoDB
form the tablespace of InnoDB. The tablespace consists of database pages
with a default size of 16KB. The pages are grouped into extents of 64
consecutive pages (i.e. 1024Kb). InnoDB allocates space starting from the
first data file (table). InnoDB can add a large segment up to 4 extents at
a time to ensure good sequentiality of data (4096Kb).
Thanks,
On Thu, Nov 10, 2011 at 10:03 AM, Rozeboom, Kay [DAS] wrote:
> In the "show table status" output, there is comment field labeled "InnoDB
> free". Can someone explain what kind of free space is counted in this
> figure? Is it space that is not currently part of any segment? Does it
> include empty pages within segments? Does it include unused space within
> pages?
>
> Kay Rozeboom
> Information Technology Enterprise
> Iowa Department of Administrative Services
> Telephone: 515.281.6139 Fax: 515.281.6137
> Email: kay.rozeb...@iowa.gov
>
>
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat