aescarcha / uuid-storage-test Goto Github PK

CREATE DATABASE uuidtest;

USE uuidtest;

CREATE TABLE `users` (
  `id` varchar(36) NOT NULL,
  `created` datetime(6) DEFAULT CURRENT_TIMESTAMP(6),
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `users_num` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime(6) DEFAULT CURRENT_TIMESTAMP(6),
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

node index.js

docker run -p 3308:3306 --name mysql-latest -e MYSQL_ROOT_PASSWORD=toor -d mysql:latest  --default-authentication-plugin=mysql_native_password

Total: Total miliseconds took
Avg: Average milisecond duration per batch
batchSize: How many rows inserts each batch
Batches: How many batches were ran
Rows: Total rows inserted

Uuid result: { 
  total: 10995,
  avg: 2.199,
  batchSize: 50,
  batches: 5000,
  rows: 250000 }
Numeric result: { 
  total: 9013,
  avg: 1.8026,
  batchSize: 50,
  batches: 5000,
  rows: 250000 }


Uuid result: { 
 total: 500366,
  avg: 10.00732,
  batchSize: 50,
  batches: 50000,
  rows: 2500000 }
Numeric result: {
  total: 131499,
  avg: 2.62998,
  batchSize: 50,
  batches: 50000,
  rows: 2500000 }


Uuid result: {
  total: 1620982,
  avg: 32.41964,
  batchSize: 100,
  batches: 50000,
  rows: 5000000 }
Numeric result: { 
  total: 214456,
  avg: 4.28912,
  batchSize: 100,
  batches: 50000,
  rows: 5000000 }


Uuid result: { 
  total: 1614770,
  avg: 64.5908,
  batchSize: 200,
  batches: 25000,
  rows: 5000000 }
Numeric result: { 
  total: 154715,
  avg: 6.1886,
  batchSize: 200,
  batches: 25000,
  rows: 5000000 }

Uuid result: { 
  total: 23539,
  avg: 4.7078,
  batchSize: 50,
  batches: 5000,
  rows: 250000 }
Numeric result: {
  total: 21264,
  avg: 4.2528,
  batchSize: 50,
  batches: 5000,
  rows: 250000 }


Uuid result: {
  total: 380339,
  avg: 7.60678,
  batchSize: 50,
  batches: 50000,
  rows: 2500000 }
Numeric result: {
  total: 247198,
  avg: 4.94396,
  batchSize: 50,
  batches: 50000,
  rows: 2500000 }

Uuid result: { 
  total: 959457,
  avg: 19.18914,
  batchSize: 100,
  batches: 50000,
  rows: 5000000 }
Numeric result: { 
  total: 407903,
  avg: 8.15806,
  batchSize: 100,
  batches: 50000,
  rows: 5000000 }

Uuid result: {
  total: 872368,
  avg: 34.89472,
  batchSize: 200,
  batches: 25000,
  rows: 5000000 }
Numeric result: { 
  total: 346356,
  avg: 13.85424,
  batchSize: 200,
  batches: 25000,
  rows: 5000000 }