It's necessary to start with the mysqltuner launch on the server and trying to optimize. But it's more likely that you'll have to hire a developer for fixing mysql queries.
Enable slow queries log in /etc/my.cnf and monitor what queries are causing high load. The database size won't matter but the queries which are taking time could be a matter.
Also try to execute mysqlturner script after 24 hours of mysql uptime.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.