« previous next »
Pages: [1]

Author Topic: Mysql CPU Load Problem  (Read 9619 times)

0 Members and 1 Guest are viewing this topic.

Offline
blackstar
*
Mysql CPU Load Problem
« on: February 21, 2018, 12:09:45 PM »
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
Logged
Offline
blackstar
*
Re: Mysql CPU Load Problem
« Reply #1 on: February 21, 2018, 10:53:33 PM »
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.
Logged
Offline
bullten
***
Re: Mysql CPU Load Problem
« Reply #2 on: February 22, 2018, 05:03:54 PM »
Did you try to optimize mysql with mysqltuner?
Logged
Offline
24x7servermanagement
**
Re: Mysql CPU Load Problem
« Reply #3 on: February 26, 2018, 06:57:01 PM »
What's the output of the below command?

mysqladmin pr
Logged
https://www.24x7servermanagement.com/
Server Management, Server Security, Server Monitoring.
India's Leading Managed Service Provider !!
Offline
blackstar
*
Re: Mysql CPU Load Problem
« Reply #4 on: February 28, 2018, 02:33:05 AM »
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.
Logged
Offline
bullten
***
Re: Mysql CPU Load Problem
« Reply #5 on: February 28, 2018, 09:31:55 AM »
I have only tried mysqltuner.
Logged
Pages: [1]
« previous next »