Mysql CPU Load Problem

Started by blackstar, February 21, 2018, 12:09:45 PM

Previous topic - Next topic

blackstar

there are a total of 10k hits. but sometimes MySQL is doing CPU Load. what could be the problem? and cwp has recently started to update very often. Could it be related to this?

http://prntscr.com/ihrws6
__________________________________
Apache version: Apache/2.4.29
PHP version: 5.6.33
MySQL version: 10.1.31-MariaDB
FTP version: 1.0.30

blackstar

http://prntscr.com/ii1ewi

there seems to be no problem. but the load is rising. What are friends becoming? The entire site is attached to the cloudflare.

bullten

Did you try to optimize mysql with mysqltuner?

24x7servermanagement

What's the output of the below command?

mysqladmin pr
https://www.24x7servermanagement.com/
Server Management, Server Security, Server Monitoring.
India's Leading Managed Service Provider !!

blackstar

http://prntscr.com/ikpat7

and also. I installed mysqltuner and tuning-primer. The two of them have different results. Which one is better for you?
I played with my.cnf file a bit. I think the problem has been solved a bit. I don't really know what I'm doing.

bullten