Announcement

Collapse
No announcement yet.

server host complaining vb queries are inefficient

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

  • [Forum] server host complaining vb queries are inefficient

    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?

  • #2
    Is this a shared server, VPS, Cloud or dedicated server? How much are they charging you a month for this hosting service?

    Comment


    • #3
      My view - when a host starts this nonsense (trying to blame poor server performance on a perfectly usable and optimised 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.
      MARK.B | vBULLETIN SUPPORT

      TalkNewsUK - My vBulletin 5.6.3 Demo
      AdminAmmo - My Cloud Demo

      Comment


      • #4
        Originally posted by Andy View Post
        Is this a shared server, VPS, Cloud or dedicated server? How much are they charging you a month for this hosting service?
        What does that have to do with the efficiency of vb queries? As a customer, I'm sure it's obvious what I think when both key providers point at each other.

        I don't know how the server is configured. When I last talked with them a few months ago, when they worked with me to set up *abundant* service parameters, they told me my account was sharing a server but it would not be a problem. I have no other site with traffic on the account.

        Nonetheless, shared server or not ... if a forum is running fine 95% of the time, and has some sort of capacity problem on the day that is the lightest day of the week re user traffic - the same day the subscription email notices go out - that would indicate that the send of those notices is doing something beyond expectations.

        Comment


        • #5
          Originally posted by Mary303 View Post
          Nonetheless, shared server or not ... if a forum is running fine 95% of the time, and has some sort of capacity problem on the day that is the lightest day of the week re user traffic - the same day the subscription email notices go out - that would indicate that the send of those notices is doing something beyond expectations.
          Hosts usually do not like too many emails.
          Hundreds of users online could mean thousands of emails.


          vB5 is unequivocally the best forum software, but not yet...

          Comment


          • #6
            Originally posted by Mary303 View Post
            What does that have to do with the efficiency of vb queries?
            In troubleshooting a problem information about the environment is very important. You didn't indicate what type of web hosting plan you have which is the first thing to know when trying to diagnose a problem as you describe.

            Knowing even how much you spend per month might seam irrelevant, but it's not. We have seen over and over again the low cost $20 dollar a month shared server accounts have issues with the web hosting company as you are describing.

            There might very well be a solution so you don't have to spend more money a month, pruning subscriptions for example, but it's always good to know the details of the web hosting service and that's why I asked.

            Comment


            • #7
              Mary,

              Andy is correct and on many occasions it's as simple as what Mark B. said as well unfortunately... I've dealt with some of the best and worst hosts over the years and blaming a script and not offering solutions is not what you want in a host at all. I recommend finding a alternative Host HOWEVER you need to know what you actually need otherwise you may fall into the same situation again... check here first if you do decide to switch - https://www.vbulletin.com/forum/show...monials-thread

              Now with that being said, it could be a valid issue the host has IF your on a shared hosting plan with that many users online at once.


              Former vBulletin Support Staff
              Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
              Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

              Comment


              • #8
                My host is HostGator (but after today I don't know how much longer that will be true - based on an incident with them today, not this thread.) I have been with them since 2007. 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.)

                Today my site was down for 7 hours. HG said they have an automated block that shuts down a site if certain parameters are exceeded - no idea what those parameters are, nor is there any way for me to know this is coming. The same thing happened last weekend, downtime 3 hours.

                I have let HG know in no uncertain times that what is needed is communications, not shutdowns. Tell me in advance that limits are getting close and we will work together to figure out what to do. That doesn't seem possible for them to do. I have to have a host I can rely on - unfortunately after so many years, that doesn't seem to be HG right now.

                I appreciate the help and feedback. And also the Host Experiences thread - I will definitely be reading it carefully.

                Comment


                • #9
                  Originally posted by Mary303 View Post
                  My host is HostGator (but after today I don't know how much longer that will be true - based on an incident with them today, not this thread.) I have been with them since 2007. 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.)

                  Today my site was down for 7 hours. HG said they have an automated block that shuts down a site if certain parameters are exceeded - no idea what those parameters are, nor is there any way for me to know this is coming. The same thing happened last weekend, downtime 3 hours.

                  I have let HG know in no uncertain times that what is needed is communications, not shutdowns. Tell me in advance that limits are getting close and we will work together to figure out what to do. That doesn't seem possible for them to do. I have to have a host I can rely on - unfortunately after so many years, that doesn't seem to be HG right now.
                  Talk to another host....there's a UK based one, http://www.nimbushosting.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.
                  Last edited by Mark.B; Sun 24 Jun '12, 11:37pm.
                  MARK.B | vBULLETIN SUPPORT

                  TalkNewsUK - My vBulletin 5.6.3 Demo
                  AdminAmmo - My Cloud Demo

                  Comment


                  • #10
                    Originally posted by TheLastSuperman View Post
                    ... blaming a script and not offering solutions is not what you want in a host at all ...
                    Hey they even suggested some coding so I could re-work the vb query script. They must have mistaken me for a vb developer.



                    Originally posted by TheLastSuperman View Post
                    ... I recommend finding a alternative Host HOWEVER you need to know what you actually need otherwise you may fall into the same situation again... check here first if you do decide to switch - https://www.vbulletin.com/forum/show...monials-thread
                    Thanks very much ... I feel I can't count on them any more. I've worked with them for a long time - some good service, some corrections. But shutting off the site with no warning, with hours of downtime - twice, after a dialog that promised it wouldn't happen again, and then general clueless-ness by support last week & today - is something I can't live with.



                    Originally posted by TheLastSuperman View Post
                    ...Now with that being said, it could be a valid issue the host has IF your on a shared hosting plan with that many users online at once.
                    See my post above and see what you think. Sunday is by far the lowest user day for my site, right now 300 users are on. Usually 275-500 users online at once, a lot of them just reading (international & American night owls, so it's working all night as well as all day.) I think it is the weekly email send-off that is tripping the shut-off. If I could stagger that it might avoid the demands on the server. In the meantime I am turning it off for the time being. However, that email does bring users back to the site, keeps them attracted to it. I want to be able to use it as designed.

                    Many of my users are addicted to the site and the friendships they have there. They have created a fb page so they could talk about the site being down when it is down.

                    Comment


                    • #11
                      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.

                      Comment


                      • #12
                        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.)

                        Comment


                        • #13
                          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.

                          Comment


                          • #14
                            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
                            environment: Centos 6.9, Apache v2.4.25, PHP 5.6.30/xCache, MariaDB 10.22 -- vB5 Connect Licensed

                            AusPhotography - Australia's Premier Photographic Forum vB4.2.3
                            Rick (site owner) and Kym (site tech) sharing this account

                            Comment


                            • #15
                              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 ?


                              vB5 is unequivocally the best forum software, but not yet...

                              Comment

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