It turns out that the guy who had been contracted for the accounting software integration had modified the active theme to include an obscure and weird PHP class that syncs the available products/SKUs with the accounting software.

This was a heavy task and took about a minute to run manually and was triggered by a request to index.php, using a specific GET parameter.

@alda

I didn’t find anything in the list of cron jobs on that machine and WordPress did not have a plugin or a wp-cron job that indicated anything happening every 3 hours.

The guy also rambled something about our machines being seriously underprovisioned, so we allocated more memory and CPU cores for this and while it did recover quicker, it still crashed regardless of havin 16 GB of memory and 4 cores.

And it was index.php of all things that was blowing everything up every 3 hours on the hour.

@alda

So I started monitoring things — and yes, it the server crashed every 3 hours as exponential amounts of memory were being reserved until the machine crashes.

I had a hard time isolating the issue as it seemed to stem from index.php (which is unusual), so I did the usual thing and cleaned out some large-ish values from the wp-options table and installed memcached.

Then I contacted the guy who had done this accounting software integration, who rambled something about a cron job.

@alda

An issue that I ran into last week:

A business sought me out because of an issue with a #WordPress site they were running. The server got overloaded and crashed every 3 hours for half an hour at a time and it was important to get to the bottom of this.

The hints that I got were that the site had been migrated to a new server in order to isolate it and that the issue started when someone was hired to integrate certain accounting software with it. 🧵

@alda

Twitter: I follow news and political giants, but all I see are bad people and arguments
Bluesky: I follow 10% of my old friends who were able to get out of twitter in time and sometimes it works
Threads: I follow my friends but I can’t see them through the algorithm of businesses
Mastodon: oh look a beekeeper in the Netherlands

@kittywifclaws