8:40 pm
January 7, 2022
Ever since I started using CyberSEO Pro our server is regularly getting overloaded and going offline every few days. I had a system admin take a look and he said something is hijacking the MySQL and causing it to spike. I'll paste his full response below, but he thinks it's CyberSEO, is there anything I can adjust to stop it from spiking the CPU and overloading the server?
I can give you the same answer as here: Login to see this link
In your case your site makes a series of MySQL queries to check every post in the syndicating thread for uniqueness among the others in your database. As you can see above, that's a valid MySQL query and there is no error.
Your MySQL server is just unable to process such amount of quires. If you want to reduce them, try to pull less feeds at once and don't do it very often.
Your feed contains 150 items (posts). It's 15x times more than a default WordPress feed size. Thus the plugin takes the same amount of your server resources (CPU and memory) as if you pulled 15 standard WordPress feeds at once.
When you pull your feed, the plugin takes the first post and asks the MySQL server check for it in the database. If post exists (no news since the last parse), it takes another and repeat the procedure all 150 times.
This is what happens with your server every time when that feed is being pulled. I would suggest you to find out how often the feed owner publishes a new post there and then set CyberSEO to pull the feed with a roughly same periodicity. I mean there is no need to pull a daily updated feed every single hour.
Most Users Ever Online: 541
Currently Online:
10 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
ninja321: 84
s.baryshev.aoasp: 68
Freedom: 61
Pandermos: 54
MediFormatica: 49
B8europe: 47
Member Stats:
Guest Posters: 337
Members: 2796
Moderators: 0
Admins: 1
Forum Stats:
Groups: 1
Forums: 5
Topics: 1600
Posts: 8158
Newest Members:
caseydipen8848, paulosos184, nicholashull7, it.mmnl, sameerz, markus.raum-gAdministrators: CyberSEO: 3857