Community

Illustrating Primary Key models in InnoDB and their impact on disk usage

(Michael Coburn) On a recent engagement I worked with a customer who makes extensive use of UUID() values for their Primary Key and stores it as char(36), and their row count on this example table has grown to over 1 billion rows.

Read More - Register for Free Membership