Search code examples
mysqldatabasedatabase-designdatabase-management

Database Memory :: MySql Innodb how much storage memory allocation for empty field vs not empty field - varchar or text

I new in database, and dont know how and when mysql allocate memory space.

In MySql Innodb how much storage memory allocation for empty field (no string inserted) vs not empty field?

Other form of my question:

When memory allocated space In MySql Innodb for varchar/text field in time of table creation or when data inserted inside field?

Thank you,

Yosef

Solution

  • do you mean RAM or disk space?

    for disk space, the varchar will not use up space unless there are values in the string.