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] <kay.rozeb...@iowa.gov > 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
