MySQL Forums
Forum List  »  Source, Builds, Binaries

Re: Server profile installation however seems not using all resources available
Posted by: Filip Leze
Date: April 29, 2022 04:15PM

innodb_thread_concurrency=0

innodb_buffer_pool_size=32G
innodb_buffer_pool_instances=32

I assume the value of the pool chunk size is automatically adjusted as it changes when I change the buffer pool size. Plus I don't see the pool chunk size setting in the my.ini:
innodb_buffer_pool_chunk_size=134217728

Running on 64G RAM.

I found out the bottleneck: 1 core is loaded at 100%. So no matter the size of the buffer, that core is limiting the overall progress.

I cut my query in multiple queries which are not overlapping in calculation. I was able to run them in parallel, loading multiple cores at 100%. I had a result in 10 mins VS more than 1 hour, running on a single core.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Server profile installation however seems not using all resources available
173
April 29, 2022 04:15PM


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.