Control Web Panel
WebPanel => MySQL => Topic started by: blackstar 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
-
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.
-
Did you try to optimize mysql with mysqltuner?
-
What's the output of the below command?
mysqladmin pr
-
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.
-
I have only tried mysqltuner.