Viktor DorotovičPartitioning InnoDB tables by time-based pseudo-sequential UUIDsPartitioning has multiple uses — spreading load onto multiple disks, cold storage of older data on cheaper disks, and probably others. Most…Oct 18, 2022Oct 18, 2022
Viktor DorotovičUUIDs Are Bad for Database Index Performance, enter UUID7!UUIDs, Universal Unique Identifiers, are a specific form of identifier designed to be unique even when generated on multiple machines…Oct 11, 2022Oct 11, 2022
Viktor DorotovičChoose the right primary key to save a large amount of disk I/OImagine you’re working in a large book warehouse and in charge of new arrivals. There’s a separate, digital system for metadata like…Oct 4, 2022Oct 4, 2022