Re: "InnoDB free" - What does it really mean?

2011-11-10 Thread Angela liu
it refers to free innodb tablespace. From: "Rozeboom, Kay [DAS]" To: "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

Re: "InnoDB free" - What does it really mean?

2011-11-10 Thread Prabhat Kumar
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

"InnoDB free" - What does it really mean?

2011-11-10 Thread Rozeboom, Kay [DAS]
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 page