events_uuid – UUID binary(16) PRIMARY KEY events_int – 自增序列bigint(20) NOT NULL AUTO_INCREMENT, events_uuid_ordered – Rearranged UUID binary(16) as PRIMARY KEY
I created three stored procedures which insert 25K random rows at a time into the respective tables. There are three more stored procedures which call the random insert-stored procedures in a loop and also calculate the time taken to insert 25K rows and data and index size after each loop. Totally I have inserted 25M records.
Data Size Horizontal Axis – Number of inserts x 25,000 Vertical Axis – Data Size in MB The data size for UUID table is more than other two tables. ###2.索引大小 Index Size Horizontal axis – Number of inserts x 25,000 Vertical axis – Index Size in MB ###3.总大小 Horizontal Axis – Number of inserts x 25,000 Vertical Axis – Total Size in MB ###4.时间Time taken Horizontal axis – Number of inserts x 25,000 Vertical axis – Time Taken in seconds 参考https://www.percona.com/blog/2014/12/19/store-uuid-optimized-way/