MySQL Forums
Forum List  »  Source, Builds, Binaries

Server profile installation however seems not using all resources available
Posted by: Filip Leze
Date: April 29, 2022 03:47AM

Dear community,

I installed MySQL with the server profile on my personal machine.
Aim is to run queries with full resources available on the computer.

However I noticed that while it runs queries from 10 mins to few hours neither the CPU, disk read/write or ram memory are fully used.

Overall I might be around 10% CPU usage, 15% ram memory and 0% read/write activity on SSD disks.

Still the query is running up to an hour awaiting results. I tried to set innodb_thread_concurrency=0 but it does not help.

If I could give full usage of computer resources to execute a query, that would be great :-) thanks for your help

Options: ReplyQuote


Subject
Views
Written By
Posted
Server profile installation however seems not using all resources available
534
April 29, 2022 03:47AM


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.