Optimise Large Mysql Wordpress Database

Job ID: 35083164

Budget: ₹1,500 – ₹2,500 INR

Hi,
I have a news portal built in wordpress running on a dedicated server. the mysql database exceeds 1.5 GB. the server core is getting utilised by Mysql db resulting in low speed. Also there are number of long queries running in Apache.

Can someone optimised the mysql database in such a way that it does not consume resources on the server & not all the cores being utilised?
Related categories: PHP Linux WordPress Apache MySQL