Messages

31

CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down

« on: July 31, 2019, 03:32:22 PM »

/etc/my.cnf.d/server.cnf :

Code: [Select]

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]

#
# * Galera-related settings
#
[galera]
# Mandatory settings
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
#bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.1 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.1]



32

CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down

« on: July 31, 2019, 03:14:05 PM »

thank you for your reply ,

that is my my.cnf file :

Code: [Select]

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d


it just the normal one , i didn't change anything to it.

33

CentOS 7 Problems / Mysql High CPU , all my Websites are down

« on: July 30, 2019, 10:05:57 PM »

hi , i have a contabo vps which have DDOS attacks protection and cloudflare with the main domain, VPS specs:
CPU Model: Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
CPU Details: 4 Core (2200 MHz)
Ram : 8GB
Distro Name: CentOS Linux release 7.6.1810 (Core)
Kernel Version: 3.10.0-957.21.3.el7.x86_64
i run CWP Pro.
i have installed 3 wordpress sites , there is one with about 35000 posts.

Now, the CPU usage is 100% and all my websites are down because of mysqld service

there are some screenshots of the CWP processes and mysql queries.

https://imgur.com/Q8yK9A7



https://imgur.com/uzFLNm3


https://imgur.com/577yZ5V

please help me , how can i optimize mysql for better performance?

34

CentOS 7 Problems / Re: PHP-FPM high CPU and Mysqld

« on: May 31, 2019, 12:50:41 PM »

i am using wordpress , and publishing posts nearly one post every five minutes.

how can i check SQL queries (mysqladmin pr) please?!

35

CentOS 7 Problems / Re: PHP-FPM high CPU and Mysqld

« on: May 30, 2019, 08:51:57 PM »

unfortunately nothing changed, is it normal that mysqld time looks like that in the photo : https://imgur.com/NmEa9mr


i have these performance issues in PhpMyAdmin Advisor in this photo : https://imgur.com/Lj7Yoqm

i fix them but when i restart Mysql every thing became the same. how can i make these changes to still in mysql settings ?

36

CentOS 7 Problems / PHP-FPM high CPU and Mysqld

« on: May 30, 2019, 09:33:39 AM »

can you please help me to know what is the best configuration for php-fpm and mysql .

My VPS specs:

Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
Ram : 8 G
Disk: 150 G SSD

Apache version: Apache/2.4.39
PHP version: 5.6.21
MySQL version: 10.1.40-MariaDB

i have only one user

i attached a photo of live monitor , where there was only 30 visitor on my sites at the same time , and the stats doesn't change if they are 30 or 300 .

Photo : https://imgur.com/4Nn3TIL

37

CentOS 7 Problems / Re: Can you help me plzz

« on: May 30, 2019, 09:23:32 AM »

I had the same issue , this code saved me.

login using SSH and paste the code:
# systemctl stop mysqld

#systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"

# systemctl start mysqld

i hope it works for you