(full disclosure: I'm a DreamHost employee, with all the biases that come with that) :>
Specifically, he has complained of problems with the MySQL server that seem to have gone unremedied, and I noticed myself that bringing up his Web site often takes 30 seconds or more
It's not entirely clear what the problems are that he has had with our MySQL server. If it's a configuration error on our end or something of that nature, I can see a definite link to his dissatisfaction and our actions. If that's the case, and he doesn't feel that support has been adequately concerned with his problem, tell him to feel free to contact me directly (email@example.com) and I'll look into it personally.
We don't like unhappy customers here. We're not perfect, but we prefer to make good on any mistakes we make.
If it's a case where things just seem slow and sluggish, though, that muddies things a bit. Performance tuning is one of the most complex aspects of database-driven web sites.
For example, on a (personal) project I've worked on recently I decided to go through and speed things up. I dropped the number of SELECT statements I used in half, which helped. But by the use of indexing, I sped up a query from about 1 second to .03 of a second - a vast improvement. Recent improvements to our web panel also made a very noticeable speed increase as well (although we have some work to do still in that department).
Even identical database schemas can even vary drastically in speed depending on what kind of data is stored in them.
In other words, it could be all sorts of things. That's not saying that it can't be our fault (it could always be us, and if the database worked flawlessly with another host, it's very possible), but there are a lot of factors involved.
That said, I'm not in a position to give an honest, unbiased appraisal of our MySQL speed or service in general. I'm sure someone will be happy to give you their opinion, though. :>
- Jeff @ DreamHost
- DH Discussion Forum Admin