fixed-size row format issue?

[Blostre]

Hello folks,
I tend to ensure tables have fixed-size row format. Is there any point at all to this in InnoDB? Performance? Recovery? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

hi, The InnoDB performs updates of clustered indexes in place if the lengths of the updated columns do not change or the update will be done by delete and insert.
In ROW_FORMAT=REDUNDANT, fixed-size columns occupy a fixed amount of space, no matter if they are NULL. In ROW_FORMAT=COMPACT, NULL columns take 0 bytes. Also, in that format, UTF-8 CHAR(n) columns are in fact variable-length. These changes were to save space. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --