Announcement

Collapse
No announcement yet.

How server intensive is Vb 5.2.3?

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

  • How server intensive is Vb 5.2.3?

    I have been using Vb5 for over a year now. For the first year up until my last upgrade to 5.2.3 I got away with 2 CPUs 3.0ghz and 2 Gigs of Ram. I noticed that the evening I installed Vb 5.2.3 that the site would return a 503 error (server unreachable) because it reached its overhead max. I gave it 1 more gig of ram, the problem persisted, and now I'm at a total of 5 gigs of ram on a scalable server. Mind you, my traffic hasn't gone up.

    I contacted the host and they did some research and said that my site is using a massive amount of queries on page load 200+. I don't know anything about that. My question is how do I minimize queries and make the site run more efficiently? Is this a normal amount of queries? Here's what my host had to say in our last correspondence:

    I have analyzed your account and found the following problems:

    1. It appears that there are too many executions which are eating up too much of the server resources. Below you can see which of your Scripts are causing that issue to happen and the nuber of the executions each of those scripts have:

    Code:


    /home/religio9/public_html/index.php 12653


    What I would recommend you to do is reducing the number of the executions of your site. Here is how you can see how you can do that easily:

    https://www.siteground.com/tutorials...executions.htm

    2. The second thing I notices, and most probably the reason for the issue, was that there is a lot of bandwidth generated by:
    Code:


    Other logins (and/or anonymous users)


    You can check that from your AwStats tool in your cPanel account.

    In most cases the issue is caused by malware and for this reason I have made a thorough scan of your account. You can see the output below:
    Code:


    Scanning [/home] ...se wait...
    [GEN]eval_base64decode [01/03/13] /home/xxx/tmp/awstats/awstats022013.religiousverse.com.txt
    [HEX]eval_base64_mixed [02/08/16] /home/xxx/public_html/core/includes/adminfunctions_template.php
    [STR]google_referer [03/08/16] /home/xxx/public_html/.htaccess
    -----------------------------------------
    Scanned Files: 52463
    Scanner Hits: 3
    Time Taken: 62 (sec)
    Scan Report: report-040816-024140


    As you can see there are 3 files marked as infected. They look like false positive, but just in case I would recommend to review and if possible delete them. Be careful with the .htaccess file as deleting may cause problems with the internal links of your site. Would recommend to ask your developer to review it.

    Also I please review the links below which can give more details about such other logins and hints on how you can solve the problem:

    https://forums.cpanel.net/threads/aw...d-users.25934/

    https://forums.totalchoicehosting.co...howtopic=33739

    https://sourceforge.net/p/awstats/di...read/acf12ba2/

    Additionally I have gone through the guardian server logs and it seems that there are some reports related to the IDLE email processes:
    Code:


    Aug 04 00:44:33 Killed long proc(21662) owner(dovenull) :: dovecot/imap-login
    Aug 04 00:44:33 Killed long proc(21656) owner(dovenull) :: dovecot/imap-login


    What you could do is disable those from your email clients as it seems they contribute to the issue in question:

    https://www.siteground.com/kb/disabl...-mail-clients/

    Something else that you could optimize is your databases as there are slow database queries reported:
    Code:


    === TOP 10 of 154 (total) Slow Queries for the past 24 hours ==========
    1. Executed 11h 49m 45s ago for 145.200913 sec on Database --> xxx
    Date: 2016-08-03 14:51:10 Query_time: 145.200913 Rows_examined: 1: Rows_sent 1 Lock_time: 5.599920
    SELECT * FROM session WHERE `userid` = 0 AND `host` = '37.60.239.48' AND `idhash` = 'xxx' LIMIT 1;
    --------------------------------------------------------------------------------------------------
    2. Executed 22h 27m 56s ago for 139.601014 sec on Database --> xxx
    Date: 2016-08-03 04:12:59 Query_time: 139.601014 Rows_examined: 1: Rows_sent 1 Lock_time: 132.401278
    SELECT * FROM cache WHERE `cacheid` IN ('vB_UserPerms0');
    ----------------------------------------------------------------------------------------------------
    3. Executed 22h 27m 56s ago for 139.600965 sec on Database --> xxx
    Date: 2016-08-03 04:12:59 Query_time: 139.600965 Rows_examined: 1: Rows_sent 1 Lock_time: 116.499943
    SELECT * FROM cache WHERE `cacheid` IN ('vB_UserPerms0');
    ----------------------------------------------------------------------------------------------------....


    There can be many reasons for slow database queries, but the following 3 are the most common ones:
    1. Large database
    2. Not well written scripts
    3. Large number of internal links that query the database directly.

    What you should do is optimising it. Here are some hints which you can use to do that:

    https://www.siteground.com/kb/how_to...ysql_database/

    https://www.siteground.com/kb/how_to...ng_phpmyadmin/

    Please be informed that the website/database optimization is a complex on-going activity which is best when performed by a professional developer.

    Please do check it from your end and do let us know if you have any further comments or require any further assistance.
    We are always here to help you.

    Best Regards,
    Tech Support
    Last edited by William Thomas Jr; Thu 4th Aug '16, 10:47pm.

  • #2
    I have two different clients who run vBulletin 5.2.3 on the same setup: Two CPU Cores, 3.0GHz, 2..GB RAM. They run default installations with no modifications or add-ons and have no issues.

    I just looked at one of those and it has 28 queries.

    Load your index page in Firefox. Press Control-Shift-Q (or Command-Shift-Q on a Mac) and you can see the individual queries and how much bandwidth each is using.

    That should give you a starting point as to which modifications or add-ons are causing the issues.

    Comment


    • #3
      https://gtmetrix.com/reports/www.chr...s.org/BXur6nzT

      Comment


      • #4
        I would be tempted to add, it sounds like you have a host that doesn't understand vBulletin or the nature of php-based software. Telling you to delete perfectly good files because they've decided they are 'infected' is never a good sign. Ask them exactly what they are 'infected' with. They won't know.

        The type of email they have sent you is the type that is probably leading up to them telling you that you are over-using resources and they want you off, or they want to sell you a higher package.

        i would be looking at alternative hosts. If you don't already have a VPS, I'd suggest heading down that road. Small shared hosting packages are rarely any good with vBulletin if there's any real traffic.
        MARK.B | vBULLETIN SUPPORT

        TalkNewsUK - My vBulletin 5.5.4 Demo
        AdminAmmo - My Cloud Demo

        Comment


        • #5
          As I pointed Replicant on WebTechSurface (don't know if he used them or not), you should check out my host for the cheapest packages that are the most professional. They're called NuWebHosting

          You can get a 4 GB RAM VPS for $15/mo and a 30% off the first year.

          I don't mean to advertise but because it's relevant to the subject i'll link you to the advertisement they put on WebTechSurface.

          http://www.webtechsurface.com/forum/...7-70-mo-30-off

          Also support is great and I've used them for around a year now. I use their 12 GB RAM package myself and it's quite affordable to me when paying yearly since I'm hosting more than one website and it's free cpanel on the last 2 packages.

          But since ChristForums is your only website I recommend 4 GB RAM or higher. I can't remember but I recall one of the techs here actually recommending at least 4 GB of RAM for vbulletin. I don't think you would need any more than that and if you do there's something wrong.

          To be honest I know shared hosts that charge double or triple what my host charges on VPS and they aren't an unprofessional gimmick. In fact their staff is amazing with support.

          Regards,

          TheXboxCloud

          Comment


          • #6
            I currently use the same host as William. I have their highest tier plan and have zero issues with them. I also purchased a VPS from Xboxcloud's recommendation which I have been using as a development server but plan on switching hosts soon. Not because of performance but price. My current host has been adequate. With the amount of extra addons and the number of online users at any given time on Christforums, it may warrant bumping up to a higher resource plan or VPS. Change of host isn't necessary unless price comes into play. There is no reason to believe the host is inadequate or doesn't understand the software. I have not adjusted any PHP values or MYSQL configuration at all on my site. As far a infected files go, they said in the email, "They look false positive" and should be reviewed and if possible delete.


            Comment


            • #7
              Originally posted by Replicant View Post
              I currently use the same host as William. I have their highest tier plan and have zero issues with them. I also purchased a VPS from Xboxcloud's recommendation which I have been using as a development server but plan on switching hosts soon. Not because of performance but price. My current host has been adequate. With the amount of extra addons and the number of online users at any given time on Christforums, it may warrant bumping up to a higher resource plan or VPS. Change of host isn't necessary unless price comes into play. There is no reason to believe the host is inadequate or doesn't understand the software. I have not adjusted any PHP values or MYSQL configuration at all on my site. As far a infected files go, they said in the email, "They look false positive" and should be reviewed and if possible delete.
              Thank you. Siteground servers are scalable so I have added 3 more CPUs and 3 more gigs of Ram which seemingly have cleared the error log. The site is working much better. The total is now 5 3.0 ghz Cpus and 5 gigs of Ram. I am using a Managed Cloud server from Siteground, and am pretty skeptical about moving away to another host. Tried one, Digital Ocean, and i realized that after managed services the price difference was minimum.

              William

              Comment


              • #8
                Siteground are usually quite reputable I believe, though I have not used them myself.
                MARK.B | vBULLETIN SUPPORT

                TalkNewsUK - My vBulletin 5.5.4 Demo
                AdminAmmo - My Cloud Demo

                Comment


                • Replicant
                  Replicant commented
                  Editing a comment
                  Zero downtime in two years for me and I have only waited 10 minutes one time for customer support. I've had four issues requiring support over two years and they were all solved in short order and were all four my fault. I have zero apprehension in recommending Siteground..

              • #9
                i was had the same problem, the vb 5.2.3 consume so much resourcers in older PHP (5.6) an get my server down. My solution was install PHP 7.0.9 and apply vb patch for login problem

                Comment


                • #10
                  Originally posted by josueinaki View Post
                  i was had the same problem, the vb 5.2.3 consume so much resourcers in older PHP (5.6) an get my server down. My solution was install PHP 7.0.9 and apply vb patch for login problem
                  Ever since vb 5.2.3. and having to downgrade to php 5.6 my forum runs slower, especially the loading of private messages and posting of private message replies, and I get a lot of database errors.

                  http://www.vbulletin.com/forum/forum...-has-gone-away

                  http://www.vbulletin.com/forum/forum...ll-of-a-sudden

                  I am hoping that vb 5.2.4 and ability to revert to PhP 7 will alleviate at least the slowness.

                  The VBV-16318.patch didn't work for me when I installed it Facebook integration/login disappeared.

                  Comment


                  • #11
                    Turn off vBulletin Messenger... Does your server use less resources? If so, adjust the polling options under Settings -> Options -> Private Message Options. Chat like features can be very resource intensive.

                    Also you shouldn't be getting table locks if your database tables are using INNODB as they should be. You should not use MyISAM with vBulletin. If you can upgrading MySQL to 5.7 will give you a significant performance boost as well as the ability to have fulltext indexes on INNODB tables.
                    Translations provided by Google.

                    Wayne Luke
                    The Rabid Badger - a vBulletin Cloud customization and demonstration site.
                    vBulletin 5 Documentation - Updated every Friday. Report issues here.
                    vBulletin 5 API - Full / Mobile
                    I am not currently available for vB Messenger Chats.

                    Comment

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