My website show below error.

Proxy Error
The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET/
Reason: Error reading from remote server
Apache/2.2.15 (CentOS) Server at Port 443

Response from Hostgator:

The site is currently expericing MySQL timeout due to the queries that the site is processing is exceeding the maxium time allowed. The query which is getting killed by the server is attempting to exicute "SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' " and this is most likely occurring due to the wp_options database table being in excess of 10GB.

How to change MySQL timeout / maximum time allowed? Where can change and where can i find these settings?

It's likely something you will have to contact the host to help you with. Most of the time, shared VMs will have a hard cap limit on what they can execute and how many resources they can take up, based on what you pay for.

As an alternative, how about you limit your query down to something a little more realistic. If you are getting that many results with a 10gb database, what good is all that data doing you? You may consider pagification, or simply being more concise with the data you are looking for.

You may also wish to look at their TOS as it references exactly what is happening to you :-/

TL;DR - call them or fix it so you're not pulling so much data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.