@Holo
I fear that we will continue to be in situation for a while and you have addressed the why it is happening, but no solutions has been given. Has there been any talks to fix it such as the below:
1. Optimize performance
Earlier we saw how overwhelming traffic cause overwhelming database requests. So part of your strategy should be identifying heavy database requests and then limiting the number, size, and complexity of those requests. There are many ways to build performance into your website. Some ideas include:
Use a content distribution network (CDN), which responds to browser requests for your static pages, like your Contact Us or Privacy Policy pages, freeing up your servers to focus on dynamic content, like your checkout pages.
Compress images and upload them at their intended display size. Use lazy loading to load media on demand, rather than all at once. According to Google, visitors perceive sites that load this way as faster, even if the actual load times are comparatively slow.
Minimize the use of plugins where possible. They can quickly become out of date, and may not always maintain compatibility with your CMS or ecommerce platform.
2. Downgrade the user experience
If you’re expecting a surge in online traffic, you can identify processes on your website that aren’t critical and either temporarily remove them or scale them back.
For example, in lieu of an advanced, CPU-heavy search function, you can use a simpler search function in order to free up the database for business-critical purposes.