Re: Slow inserts/restore from backup
I've tried with innodb_buffer_pool_size=6012954214 since I have 8GB of RAM but it didn't change anything. Still there is very high and inefficient CPU usage of mysqld.exe.
Maybe it has something to do with multithreading? If MySQL 8 consumes up to 90% of CPU then it must be using all of my cores during import. MySQL 5.7 seemed to use roughly one core if it consumed around 25% - I have a 4-core FX-4300 CPU. I would have thought that by utilizing more cores the import would be faster but it's the other way round.
Subject
Views
Written By
Posted
1417
October 02, 2018 02:55AM
2563
January 02, 2019 07:31AM
1027
January 02, 2019 12:09PM
1300
January 02, 2019 03:18PM
983
January 02, 2019 04:41PM
Re: Slow inserts/restore from backup
1075
January 02, 2019 07:03PM
913
January 11, 2019 02:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.