i have a vps with this specs : CPU Model: Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz CPU Details: 4 Core (2200 MHz) Distro Name: CentOS Linux release 7.6.1810 (Core) Memory RAM : 8 GB i am running Centos web panel on it, i have two wordpress websites , one (which has the problem i think ) has over 30000 posts, and the other has 6000 posts. when i run the server on php5.6 every thing goes well but the cpu load is high, and when i upgrade it to php7 CPU load became lower and nice for about 8 hours and suddenly a Query run and CPU load became 100% and my websites go down. i do not know why , i tried a lot of solutions but nothing happened. can any one please help!! The Query : https://imgur.com/a/7lZXjc2 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.