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?
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)
it refers to free innodb tablespace.
From: Rozeboom, Kay [DAS] kay.rozeb...@iowa.gov
To: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Thursday, November 10, 2011 10:03 AM
Subject: InnoDB free - What does it really mean?
In the show table status output
