Dedicated Hosting and shared-MYSQL CPU & Bandwidth


#1

So far, I’m impressed with Dreamhost, I’ve been using the BASIC shared hosting account.
They now offer DEDICATED hosting (except the MYSQL IS STILL SHARED)

I understand there are many variables, but on average,
is MYSQL PERFORMANCE more at fault for slowing down a website, than BANDWIDTH or server CPU?

What is your experience? Thanks for any answers.


#2

It really depends on the nature of your site, if you are serving up lots of dynamic content pulled from a database, then obviously MySQL performance is going to have a significant impact on overall site speed. However, if your site consists of mainly static content, with the occasional dynamic page, then it is going to have a lesser impact. Of-course, this is a bit of a simplification, as there are ways to speed up the dynamic content through intelligent caching etc.

My own sites tend to be affected more by server load than MySQL performance. I have noticed that whenever my sites are slow (thankfully not a regular occurrence), logging-in via SSH invariably shows a high server load.

If MySQL performance is of paramount concern to you, perhaps you should be looking at a real dedicated server with root access etc, rather than the dedicated/shared hybrid offered by DreamHost. DreamHost does have a partnership with hosting.com, perhaps one of their dedicated offerings would suit?

Mark


Save [color=#CC0000]$50[/color] on DreamHost hosting using promo code [color=#CC0000]SAVEMONEY[/color] ( Click for promo code details )


#3

As Mark said, if your website relies heavily in sql, then I would go for a solution with dedicated sql, or you’ll always be limited with that.

Dreamhost $97 promo code

[color=#CC0000]97promo[/color] will give you $97 off
[color=#CC0000]90promo[/color] will give $7 to Unicef


#4

if i have enough money, i will go for dedicated one :stuck_out_tongue:

Save [color=#CC0000]$97[/color] (max discount) on dreamhost by using promo code: [color=#CC0000]97MONEY[/color].