My current server has 12 cores and 96gb of RAM. But due to my MYSQL queries, up to 100% of the server is always in usage while ram is less than 5%. I know the major issue is with the SQL queries. From logs, it turned out to be some queries that sums up values in all columns. Now due to how huge the application is, optimizing the queries will not be possible in the short term.
As a short term solution, should I get a new server with 32 cores? Or is there a way to move some of the processing power to the server's RAM? That way over 90gb of RAM won't just be going to waste.