Siteground Hosting - Admin WP db optimizing causing 504 Timeout

Website, Application, Performance DNS & Network
1

Hello All

I experience 504 Timeout Errors when i work in the WP Backend.

This Tasks result in 504:

  1. Bulk Edit Products (fetching the WP db)
  2. Getting db entries by a plugin to optimize WP tables (fetching the WP db)
  3. Any other task that needs more than approx. 1 Minute

Siteground support said, that it has nothing to do with slow server response from their side.

Any idea?

Thanks

Daniel

2

The question is does it take that long because the query simply takes that long or because their servers are overloaded. If it is the former you will need to optimise that query, if it is the latter they need to fix that.

The timeout simply happens because the answer takes too long and Cloudflare closes the connection.

3

Hello Sandro

thank you for your answer.

Well, fetching the db might take it’s time and i have been trying to pause Cloudflare for this task without success.
Is there no possibility to bypass CF for this task? I need to do it just once all 6 months or so.

Thank you

Daniel

4

Pausing should do the trick, however you’d need to wait until the DNS records actually point to your server. You could keep a “secret” host which keeps pointing to your server (:grey: instead of :orange:), in this case you wouldnt need to pause anything and could directly access your server whenever necessary, just keep in mind this might also reveal your IP address - if that is of concern.

Alternatively you could optimise the query or split it into chunks.

5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.