Announcement

Collapse
No announcement yet.

server host complaining vb queries are inefficient

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • slinky
    replied
    So here's a terrible question... how many plugins do you have installed in VB?

    Leave a comment:


  • Mary303
    replied
    I don't code. I don't mean "I don't want to code." I mean "I don't know how to code." It makes zero sense to think that I go from being a customer who buys working software, to one who becomes a developer as well. This is a fantasy of left-brained vendors who don't realize that their biggest customer potential is from people who specialize in things other than technology - that is, people who are right-brained and use the technology for staging.

    The problem with a dedicated server is that the customer has to manage it. I researched this as extensively as I could when I was on the verge of dumping HG last fall and just couldn't find enough information or tutorials to feel confident I could trust a significant part of my business to the idea, especially on a hot cut, as it were. (That crisis was inspired by another customer service faceplant by HG, after which they offered the account package we settled on although I was willing to go bigger with another company.)

    For some reason hosts don't seem to comprehend that the jump from shared to dedicated is too large in terms of skills required and cost. Double in both cases, at least. There need to be intermediate steps so the learning curve is not so steep and sudden. Couldn't even find manuals or classes on managing a dedicated server. Not much guidance from hosts, either.
    Last edited by Mary303; Sun 1 Jul '12, 11:10am.

    Leave a comment:


  • scylla22
    replied
    vb optimize claims to cut back on mysql queries. Two more things you can do is follow as many steps as possible in my guide and try to enable cloudflare for your site (will only work with .www appended to the urls so use this to do that. )

    Code:
    ### BEGIN CLOUDFLARE REWRITE (domainB.com to www.domainB)
    RewriteEngine on
    RewriteCond %{HTTP_HOST} ^domainB.com$ [NC]
    RewriteCond %{SERVER_PORT} ^80$
    RewriteRule ^(.*)$ http://www.domainB.com/$1 [R=301,L]
    ### END CLOUDFLARE REWRITE ###################
    And finally, one last thing to do after you have done all of the above is to make a thread here where eva2000, will more than likely be the person to respond to your thread.
    https://www.vbulletin.com/forum/foru...-Configuration

    Originally posted by Mary303 View Post
    My server host is telling me that my forum "fits" into the account that was arranged for it, in terms of database size and traffic on the site. In fact, when this was set up several months ago they told me there was "plenty" of room for expansion. However, a recent problem is giving me doubts about either the host or the software - maybe both? About once a week when certain processes run the site is demanding too much server resources and it is automatically shutting down for several hours. The server host is specific "these are not space or memory limits, but actual processing power limitations."

    Size-wise the site is almost at 2 million posts, but has only a few hundred users active on it at any one time. This outage occurs only when certain internal processes run, only about once a week. I am finding out how to turn off the notification email to users until a more permanent solution is determined (either a change in server account or a change in vBulletin.)

    Host message included: " ... the sign of the need for some optimization of coding. Where it be some type of caching, or adding indexes to your database tables." Well, I don't code that stuff. I'm the software customer, not the developer.

    Has anyone else run into this? Thoughts?
    Not at all, I still use hostgator and I plan to make another 3 year renewal for their shared hosting

    Originally posted by Pathum View Post
    Host Gator

    This gets me worrying as I am also running on hostgator servers...

    Time to change?

    Leave a comment:


  • Pathum
    replied
    Host Gator

    This gets me worrying as I am also running on hostgator servers...

    Time to change?

    Leave a comment:


  • Mark.B
    replied
    Originally posted by Deathjam View Post
    Bah ripoff I pay $99 or about £63 for a e3-1270 16gb ram dedicated server (OK OK it's unmanaged but yeah )

    Sent from my HTC One X using Forum Runner
    Yeah but Nimbus is made of awesomeness, it never goes wrong.

    You don't half get used to never having your site go unexpectedly offline only to be told it's your own fault. I got so sick of that. Doesn't happen now ever since I went with Tim, first with his original company (which went downhill after he left) and now with Nimbus.

    Leave a comment:


  • Deathjam
    replied
    Originally posted by Trevor Hannant

    At today's rates - 75.00 USD = 48.11 GBP. Holy crap, for shared hosting?! I don't pay much more than that for a higher end vPS with Nimbus that Mark's linked you to above...
    Bah ripoff I pay $99 or about £63 for a e3-1270 16gb ram dedicated server (OK OK it's unmanaged but yeah )

    Sent from my HTC One X using Forum Runner

    Leave a comment:


  • Deathjam
    replied
    Originally posted by Mary303
    Also this still begs the question of the email surge when the email notifications go out. This is a brief but very large expansion of the resources needed for any site. It changes the requirements for a site like mine that otherwise fits very well inside the space allocated. If it were not for the way the emails go out - all at once, instead of being staggered - likely I would not be having problems right now. Why isn't this staggered? vB certainly knows the load it creates on server resources. It seems ridiculous to double the cost of server needs just for one function a week.
    What are your settings under the options > email options in the admincp

    There are some mail queue settings in there

    Sent from my HTC One X using Forum Runner

    Leave a comment:


  • Mark.B
    replied
    Originally posted by Mary303
    Do they have a US # that you know of? I like very much what I see on their site. I have to get off HG as fast as possible. They can't keep the site up. I get what they are trying to do, but they are making an absolute hash of it, and poor communications - and my users are getting the bad end of it.
    Drop an email to [email protected]

    Sent from my iPhone using Forum Runner

    Leave a comment:


  • Mary303
    replied
    Originally posted by Mark.B View Post
    Sorry. Late at night, got the URL wrong.

    http://www.nimbushosting.co.uk is indeed correct. I've edited my post.
    Do they have a US # that you know of? I like very much what I see on their site. I have to get off HG as fast as possible. They can't keep the site up. I get what they are trying to do, but they are making an absolute hash of it, and poor communications - and my users are getting the bad end of it.

    Also this still begs the question of the email surge when the email notifications go out. This is a brief but very large expansion of the resources needed for any site. It changes the requirements for a site like mine that otherwise fits very well inside the space allocated. If it were not for the way the emails go out - all at once, instead of being staggered - likely I would not be having problems right now. Why isn't this staggered? vB certainly knows the load it creates on server resources. It seems ridiculous to double the cost of server needs just for one function a week.

    Leave a comment:


  • Trevor Hannant
    replied
    Originally posted by Mary303 View Post
    ... I pay $75 per month (have been at that level for a long time.) A few months ago we negotiated a new arrangement, and I put it on HG to tell me what was going to work, given their history with my account, and what I was telling them about expected growth. I was prepared to consider a bigger account. They assured me this arrangement that *they* came up with would work for quite a long time. The server is shared - their choice - they call it mini-dedicated. My largest db, the one that is active, is 6120mb. (I have a copy on a test site, but it isn't being used.)
    At today's rates - 75.00 USD = 48.11 GBP. Holy crap, for shared hosting?! I don't pay much more than that for a higher end vPS with Nimbus that Mark's linked you to above...

    Leave a comment:


  • Mark.B
    replied
    Sorry. Late at night, got the URL wrong.

    http://www.nimbushosting.co.uk is indeed correct. I've edited my post.

    Leave a comment:


  • beishe8
    replied
    Originally posted by Mary303 View Post
    (The link did not lead anywhere, though. If you have a phone number you can share I can connect with them that way.)
    Perhaps it's not nimbus but nimbushosting ?

    Leave a comment:


  • AusPhotography
    replied
    Originally posted by Mark.B View Post
    My view - when a host starts this nonsense (trying to blame poor server performance on a perfectly usable and optimized commercial script), it's time to leave.
    Find a new host, then email your old host and tell them you are leaving due to their atrocious service.
    Sometimes!! Eg. A 2million post site probably should not be on shared hosting.

    Any of the VPS hosts that use Kernel based virtualisation (eg. Hostgator with Virtuozzo (or OpenVZ)) can suffer from over selling.

    If you use a VPS then find a good XEN (bare metal) based service.
    A dedicated means you get what you pay for.

    Kym

    - - - Updated - - -

    Also: http://hostcube.com/blog/tag/vps/ (as to why XEN is better than OpenVZ/Virtuozzo) NB: We don't use Hostcube, we use Photovps XEN

    Leave a comment:


  • Andy
    replied
    Originally posted by Mary303 View Post
    First note ... one of the reasons I chose HG initially (it was a newer company then) was that it is headquartered in Houston, where I have many connections.
    Perhaps a dedicated server with HG is your best bet. You've been with them for a long time so you should be able to get great customer service. Perhaps ask for a second hard drive be installed for no charge based on your loyalty. This second drive can be used for backing up your data.

    Leave a comment:


  • Mary303
    replied
    Originally posted by Andy View Post
    Hi Mary,

    Sorry to hear of the issues you're having. I'd be extremely pissed off too.

    Is your forum a local forum? Meaning are most of your members from Texas? If so I suggest you find a small independent web hosting company that is located in the nearest big city to where you are located. You mentioned willing to pay a bit more, I would suggest a dedicated server. They typically cost in the $150 to $250 dollar range. It's so nice to have a dedicated server as you have full control over all aspects of the server. Paying $150 a month might seam like a lot, but these days it's pretty easy to ask for donations and members are typically very happy to chip in if you are providing a great service/forum. Use paypal to accept donations, it's so easy to set up.

    Anyway those are some considerations for you to think about.
    First note ... one of the reasons I chose HG initially (it was a newer company then) was that it is headquartered in Houston, where I have many connections. They now have another building in Austin, just over 3 hours drive from me. Theoretically I could show up on their doorstep and complain.

    No, it is not a local site, it is international. A slight majority of members are in the Eastern Time Zone. Have many from Europe, even some from Asia. (Also many Americans that seem to post a good part of the night.) It is active 24/7/365.

    - - - Updated - - -

    Originally posted by Mark.B View Post
    Talk to another host....there's a UK based one, www.nimbus.co.uk, who have an excellent reputation and are actually vBulletin specialists, Tim Dunton is your man. Search on here there's a lot of positive stuff about them. Doesn't matter that you're not in the UK.
    Thanks for the tip. I will talk to them.

    (The link did not lead anywhere, though. If you have a phone number you can share I can connect with them that way.)

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X