[MDEV-20748] How are blobs stored in row_format=dynamic in overflow pages ? Created: 2019-10-04  Updated: 2019-10-07

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Michael Graf Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Since the change from MariaDB server 5.5.57 to 10.3.18 the errorlog now contains messages like:

2019-10-04 6:21:40 10 [Warning] InnoDB: Cannot add field `EventAttributes` in table `zissystem`.`eustatus00000101495_history` because after adding it, the row size is 8483 which is greater than maximum allowed size (8126) for a record on index leaf page.

Can this message be suppressed ?

As far as I understand this message means that the row_format of the table has to be migrated from 'COMPACT' to 'DYNAMIC'. In the table are contained 9 blob columns.
What does this mean for the used table space if the table uses row_format 'DYNAMIC' instead of 'COMPACT' ?

Does this mean that if each blob is filled with data that 9 overflow pages a 16kB are used ?


Generated at Thu Feb 08 09:01:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.