My website show below error.
The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET/@@@@@@.net/
Reason: Error reading from remote server
Apache/2.2.15 (CentOS) Server at hostgator.com 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?