Details
-
New Feature
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
Description
MariaDB provides the UUID method that generates UUID v4, however UUID v4 generates non linear UUIDS that will spread data across different linear partitions based on key or hash.
The new UUID7 (https://uuid7.com/) will guarantee that continuous records are time sortable and a good collision resistance.
The main advantage of UUID7 function is that it will allow to MariaDB avoid the limitation of use an unique combined primary key for time series records, where an unique ID and a date is required in order to create key/hash partitions. With UUID7 is possible only use only the key as ID and time reference.
Right now is possible to generate UUID7 using a poor custom UDF however it may be very slow.
Attachments
Issue Links
- causes
-
MDEV-33710 Implement Timestamp Extraction for UUIDv7
- Open
- is blocked by
-
MDEV-33827 UUID() returns a NULL-able result
- Closed
- is part of
-
MDEV-23748 support not-MAC-address based UUID versions
- Open
- relates to
-
MDEV-32583 UUID() should be treated as stochastic for the purposes of forcing query materialization
- Closed
-
MDEV-33711 Increase Tests for UUIDv7
- Open
-
MDEV-11339 Support UUID v4 generation
- Closed
-
MDEV-34981 Functions missing from INFORMATION_SCHEMA.FUNCTIONS
- Open