Why do small inserts into the database give a maximum of 4mb / s on ssd?

Question

MySQL

I am writing to the mysql innodb database on nvme samsung evo and faced the fact that iotop shows a maximum of 4mb / s and 90% load on the io resource. Multiple parallel streams does not increase write speed. Insertion of a million records is about 300-500 bytes. Drive without raids. Tried on another server - same story.

Answer 1

Two directions:
1) innodb_flush_log_at_trx_commit=0 or 2 ( https://dev.mysql.com/doc/refman/8.0/en/innodb-par... ) and other basic settings
2) bulkinsert as already mentioned, etc. ., see https://medium.com/@benmorel/high-speed-inserts-wi...

Answer 2

Looking for bulkinsert