Recent content by LukeD

Thanks, this is very likely one of our issues. I happened to stumble across the node setting that hides threads/pages beyond a certain date from end users to prevent the attempted load of the super high pages, and it seems to have helped a lot.

We run a fairly large network of XF sites, running on AWS against Aurora MySql (our 100+ XF sites are partitioned across several writer/read replica clusters). It runs well for quite awhile (weeks, sometimes months) but with no obvious trigger the DB writer in a cluster pegs 100% CPU and...

Thanks Brogan, the Batch Update is exactly what I needed. A bit slow but at least I can set it up to do 200k at a time and walk away. :)

I've a spammer that managed to create 152,000 threads. Trying to run the Spam Cleaner results in an out-of-memory error from mysql. We found this issue because the db crashed due to a 10gb temp table that I assume Spam Cleaner was creating trying to process this massive amount. Other than using...