Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - leebrimlow

Pages: [1]
1
CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down
« on: August 19, 2019, 11:22:40 AM »
thank you for your help :)
i think your answer is the most right answer . i will disable it for two days and see what will happen.

But what if it was the problem, how can i fix this, i am totally depending on it in my website !!

thanks advanced :)

2
CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down
« on: August 17, 2019, 11:06:35 PM »
thank you very much ,
recently, i have found that :
when i am running the server on php5 nothing happen , no problem at all except the high CPU usage of phpfm.
And when i change it to php7 CPU load became very low and every thing is very good for about 8 hours and suddenly the query run and my websites go down.

So, the problem is between my website and php7 .
The Query : https://imgur.com/a/7lZXjc2
this is my active plugins : https://imgur.com/u7hshya
Theme : Publisher Version 7.6.0

i am using the same theme and plugins on both websites , but only the one with 30000 posts is making the problem.

3
CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down
« on: August 03, 2019, 11:37:12 PM »
that is the process or the queries when it run my sites stopped and CPU load became full :\

https://imgur.com/NGPmKxy



Any one can help me please !

4
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]


5
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.

6
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?

7
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?!

8
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 ?

9
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

10
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 :)

Pages: [1]