Why does insert take more than 0.01 seconds?

Question

MySQL

Good day! I installed clean CentOS 8, Mysql 8.0.17 created a simple table

CREATE TABLE IF NOT EXISTS `service`.`properties` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE)
ENGINE = InnoDB

trying to insert

INSERT INTO properties (name) VALUES (1);
INSERT INTO properties (name) VALUES (2);
INSERT INTO properties (name) VALUES (3);
...

there are 10,000 records in it and ... they are inserted as much as 60 seconds. Although on my local server on macos with ssd instead of nvme they are inserted in just 2 seconds on the same mysql8. Do not tell me why and how to edit? Thank you!

Answer 1

Wrap all inserts in a transaction.
To avoid confusion: the right example of how to wrap INSERTs in a transaction

Answer 2

This will be faster

INSERT INTO properties (name) VALUES 
(1), 
(2), 
(3), 
(4), 
... 
(10000);

Answer 3

because you need to prepare a request and wrap it in a transaction

Answer 4

did you set up the server? or just set?

Answer 5

Remove indexes from the table, and after restore.

Answer 6

BULK-inserts work with get_last_id, you just need to get the last id after such a batch and use the number of entries to programmatically restore the identifiers in the script. This is about optimization in general.