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

0 Members and 1 Guest are viewing this topic.

Offline
**
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

Offline
**
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.

Offline
***
Re: Mysql CPU Load Problem
« Reply #2 on: February 22, 2018, 05:03:54 PM »
Did you try to optimize mysql with mysqltuner?

Offline
***
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
https://www.24x7servermanagement.com/
Server Management, Server Security, Server Monitoring.
India's Leading Managed Service Provider !!

Offline
**
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.

Offline
***
Re: Mysql CPU Load Problem
« Reply #5 on: February 28, 2018, 09:31:55 AM »
I have only tried mysqltuner.