Re: file_per_table=1 question

[Lance Evans]

Hi Rick

Thank you very much for your reply, really appreciate it.

So just to clarify I ran show tables status;

And the table in question is listed below. It has innodb free: 6873088 k


| workflow_task_log | InnoDB | 10 | Compact | 277 817 | 35101 | 9751855104 | 0 | 0 | 0 | 390402 | 2013-11-08 05:21:23 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 6873088 k

Does this mean that when new data is written in this table, it will be written to the innodb free space first, before increasing the overall file size?

Thanks again
Lance