[MDEV-28102] NULL storage size Created: 2022-03-16 Updated: 2022-06-14 Resolved: 2022-06-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Nuno | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Hello Is it possible to add some documentation about how much a NULL value takes in terms of storage? I couldn't find any reference in these pages: https://mariadb.com/kb/en/null-values/ https://mariadb.com/kb/en/data-type-storage-requirements/ I understand NULL is not an empty string nor a 0. A 0 in a BIGINT field would take 8 bytes as far as I understand. And does it depend on the ROW_FORMAT? (assuming InnoDB Barracuda anyway) Thank you very much! |
| Comments |
| Comment by Ian Gilfillan [ 2022-06-14 ] |
|
Some details added to https://mariadb.com/kb/en/data-type-storage-requirements/#nulls |