MySQL Forums
Forum List  »  InnoDB

Re: Slow inserts/restore from backup
Posted by: Michal Koscielny
Date: January 02, 2019 07:03PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
158
October 02, 2018 02:55AM
Re: Slow inserts/restore from backup
26
January 02, 2019 07:03PM


Sorry, only registered users may post in this forum.

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.