Urgent help on MYSQL CPU Usage

[CERTCGOD]

Hi Team,

I am using DLE and database size is 2+GB, now my mysql process is using more than 170% CPU usage.
With this all my sites are very very slow.

Can you someone help me in identifying/tuning mysql?

Thanks

 

[itsyndicate]

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.

 

[imort]

Can you someone help me in identifying/tuning mysql?
Thanks

You can start with posting 'mysql status' here and to look for 'slow queries' metric at least?

And I think that if you haven't much experience in MySQL performance troubleshooting you'll need to find a person who will.

 

[SAXSystem]

you can take a look mysqltuner

and look into modifying the /etc/my.cnf file

 

[24x7serverman]

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.

 

[Upmoney]

Did you try to use search? Look at here: https://www.wjunction.com/177-technical-help-desk-support-archive/88504-dle-heavy-cpu-load.html
I hope you can find some useful info there.

 

[CERTCGOD]

any sql guy in this forum to fix this? i can pay for him once it is resolved

 

[24x7serverman]

any sql guy in this forum to fix this? i can pay for him once it is resolved

Hi, we can look at server at peak time and can advise accordingly.