The short version of the story is that there were about 10 different things wrong with the server. Some of those things were configuration issues, and some of them were database tables getting out of hand.
We tweaked file system caching, we tweaked file system journaling, we tweaked the mariadb connection timeout, we tweaked mariadb memory allocation, we tweaked a couple Drupal modules, we fixed an out-of-control spam problem that was elsewhere on the server, and I'm sure we did some other things that I'm not remembering at the moment.
Load average has gone from about 18 to a balmy 1.7.
We'll see how things hold during peak hours, but right now things are looking a lot better. Again, sorry for all of the issues lately.
Peace,
Bart
Comments
Thanks for the work done. :)
Great to hear :) was a bit worried there but glad it's all solved.
Performance is very much improved. Awesome great job.
Performance is great so far. Works like a charm for me.