Laravel migrations/db:seed super slow
In this case, I think that the buffer pool size increment is required. Set the following:
[mysqld]innodb_io_capacity = 2000innodb_read_io_threads = 64innodb_thread_concurrency = 0innodb_write_io_threads = 64
if you are using MySQL 8
in my case, the problem was MySQL 8 slower insert speed which occurredafter updating MySQL 5.7 to 8
A difference between 5.7 and 8.0 is that binary logging (to be used for replication and PITR) is on by default in MySQL 8.0. To run without binary logging in 8.0
the quick fix of this problem is to start your MySQL server with --disable-log-bin
or you can write below codes in your my.cnf
[mysqld]skip-log-binfor more information, please visit