InnoDB free: 4096 kB

[bartonc]

This comment ("InnoDB free: 4096 kB") appears in the MySQL Table Editor on a brand new InnoDB table. Does this mean that this table will soon be full? Do I have some setting that must be change in order to get larger tables or will additional space be added when I reach this size? Thanks for your assistance with this issue,
Barton

[ronverdonk]

This comment ("InnoDB free: 4096 kB") appears in the MySQL Table Editor on a brand new InnoDB table. Does this mean that this table will soon be full? Do I have some setting that must be change in order to get larger tables or will additional space be added when I reach this size? Thanks for your assistance with this issue,
Barton

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).

So, back to your question: when you defined your table, an initial amount of 4096Kb space was allocated to it. When your table grows, more space will be allocated. When you delete rows from the table, it releases the space to other users.

Ronald :cool:

[bartonc]

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).

So, back to your question: when you defined your table, an initial amount of 4096Kb space was allocated to it. When your table grows, more space will be allocated. When you delete rows from the table, it releases the space to other users.

Ronald :cool:

Thanks, Ronald. That one has been bugging me for a long time. I've got the docs, but hadn't managed to run across that one yet. It's a good feeling knowing that there is such expertise "righ next door". Thanks, again,
Barton

[ronverdonk]

Most welcome. It's not really 'live' expertise as knowing where to find it. Most important thing IBM classes taught me 35 years ago was: doesn't matter what you know, important is to know where to find it (and apply it of course).

Ronald :cool: