I have a vps with these specifications:
CPU Model: Intel (R) Xeon (R) CPU E5-2630 v4 @ 2.20GHz
CPU details: 4 cores (2200 MHz)
Distribution name: CentOS Linux version 7.6.1810 (Core)
RAM memory: 8 GB
I'm running the Centos web panel on it, I have two WordPress websites, one (which has the problem, I think) has more than 30,000 posts, and the other has 6000 posts.
when I run the server in php5.6 everything goes fine, but the CPU load is high, and when I update it to php7, the CPU load became lower and nice for about 8 hours and suddenly a Query Run and the CPU load became 100% and my websites fall.
I don't know why, I tried many solutions but nothing happened. Can someone help me please!!
The query: https://imgur.com/a/7lZXjc2
My active add-ons: https://imgur.com/u7hshya
Topic: Editor Version 7.6.0
- I am using the same theme and add-ons on both websites, but only the one with 30,000 posts is causing the problem.