Re: file_per_table=1 question

[Rick James]

> 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?

Yes and no.

I suspect it will consume that 6MB down to 4MB, then allocate another 4MB. (Or something like that.

That's a Data_length of 9.7GB, correct? That plus free=6MB tells me
(1) it is as optimized as it can be,
(2) nothing needs to be done now,
(3) 6MB is such a tiny percentage of 9.7GB as to be insignificant. (Rule of Thumb: Don't worry about speed/space things unless you can see a possible gain of 10%.)

Watch Data_free...
* If you are not deleting (etc), it will be exactly 4MB/5MB/6MB/7MB.
* If you are DELETEing, it may grow past that.
(Caveats: Does not apply to tiny tables. Applies to each PARTITION, not whole table.)