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.


Topics - leebrimlow

Pages: [1]
1
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?

2
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

Pages: [1]