IPv4 addresses stored as String(255) instead of INT
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
Wishlist
|
dk647 |
Bug Description
IPv4 addresses can be more efficiently stored in MySQL as an (UNSIGNED) INTEGER instead of as a UTF8 VARCHAR(255). The former requires only 4 bytes; the latter requires between 8 bytes (a.b.c.d) and 16 bytes (aaa.bbb.ccc.ddd) of storage, and up to 765 bytes of memory for certain operations where MySQL allocates memory based on the max row size (eg, sorts and in-memory temp tables). Changing both `fixed_
I can't speak to the efficiency of other databases from experience, but I expect the performance difference would be similar.
Changed in nova: | |
importance: | Undecided → Wishlist |
status: | New → Confirmed |
Changed in nova: | |
assignee: | nobody → dk647 (meizu647) |
Changed in nova: | |
status: | Confirmed → In Progress |
Fix proposed to branch: master /review. openstack. org/12557
Review: https:/