I’m having problems with a Drupal site. During the day it’s painfully slow, with lots of errors 500 and 404. I searched a lot through Drupal forums, here, the wiki. Many people has the same problem with Dreamhost, but I found no solution.
Tried to change from Fast CGI to CGI, disable modules to a bare minimum, change cache times… Nothing.
In periods like past-midnight, things seems to look OK. Site becomes really snappy.
Support here confirms that Dreamhost has a problem with massive queries CMSs like Drupal. This has something to do with the latency of separate MySQL and PHP servers, the hardware configuration here. They suggest to upgrade to PS. I won’t because there are similar priced hosts with no reported Drupal incompatibilities.
In any case, anybody had luck around this kind of problems?
Thanks in advance.