MySQL Usage


#1

I have been doing a little research on the conueries concept, and it makes sense.
What I want to know is what would be considered “high” usage?
I want to move my forums from my server at home to DH.

If I convery MySQL stats from my server to ‘conueries’
(Connections*25)+queries=

I get 7,445,931 ‘conueries’ in the 29days, 9hours of MySQL uptime. About 10,600 per Hour.

Would I be better off finding somewhere else to host these?

Thank You.


#2

You have done some good research there, and I think it is great that you took the time to investigate thoroughly whether or not DH shared hosting is appropriate for what you want to do :wink: .

Dreamhost has changed it’s policy on conuerie allocation recently. From the March, 2002 DH Newsletter:

Then, from the “current” KB/Wiki entry:

[quote] How many conueries am I allowed per month?

There are no longer any hard limits on conueries for any of our plans!

We still track them, but unless you’re in the top .01% of our database users, you’ll never need to worry about conuery usage again!

We reserve the right to have ultra-heavy users curtail their database usage (or switch to a dedicated server), but honestly unless you’ve got a crazy (and crazily inefficient) database-driven site that gets thousands and thousands of visitors a day, don’t sweat it!

If we do contact you about heavy conuery usage, we’re very nice about it and will very likely be able to work something out we can all live with! [/quote]
While Dreamhost Support is the only place to get an “authoritative” answer, it looks like you would probably be “OK” on the conuerie side of things. A couple of my “smallish” databases without a lot of traffic generate about half of what you anticipate using, so I don’t think your number of 7.5Mcn (Million conueries) is particularly high. Given that that amount is less than half what DH plans offered 4 and a half years ago, I can’t imagine it would be considered “high” today, with everybody now running CMS systems and other dynamically created content.

The only other concern you might have is that, irrespective of conuerie usage, your application(s) will be running on a shared server, so CPU usage could become a concern, depending upon how efficiently your applications are coded. Since you know about conueries, I assume you have found the Dreamhost Wiki, and I suggest you search that, or this forum, for additional information/discussion of CPU usage monitoring and limitations.

The only other thing that might make a difference to your forum is that DH MySQL databases are not hosted on the same server(s) as your web services. This means there is an additional “roundtrip” within the Dreamhost network for data to move between the web and MySQL servers. WHile this is not a problem for many, in the event of very heavy usage, or any internal routing issues withing the DH network, there can be a “lag” while accessing MySQL databases. This has not been a problem for me, but I felt I should mention it as there are other architectures in use on other hosts that do not have this characteristic. Of course, some of those systems have “quirks” of their own, so this is very much a YMMV kind of beast.

Don’t forget, Dreamhost offers a 97 day Money-Back Guarantee (if you pay with a charge card - read the terms carefully!), so if you gave it a try you have over three months to see if DH meets your needs (and it doesn’t, you haven’t lost any money :wink: .

–rlparker