Re: Server profile installation however seems not using all resources available

[Filip Leze]

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.