I’m not quite sure if it’s the speed of the box I’m on or the fact that the mysql server I’m on (gwen) is just slammed, but my database driven website (my main site as well as my gallery) load pretty damn slow for sitting on a quad xeon (xevious.dreamhost.com) and am leaning towards that the SQL server is just overwhelmed with queries. Maybe some of the rest of you can check, but this seems a bit high for users on one machine:
[xevious]$ wc -l /etc/passwd
It looks like 42 of those are system accounts for daemons etc, but that’s still over 800 users on one machine. I’m sure I’m not the only person using database-driven sites to notice the speed (or lack thereof) of their sites.
I’m not going to say I expect superior speed knowing that I signed up for a year of service for under 10 bucks with domain registration (along with god knows how many other people in December), but there has to be something I can do. Possibly switch to another box, or at least a different SQL server (or both?)?
Suggestions? How about hearing from someone at DH on this one?