New message pulldown and opening of messages in general very slow

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Maltair
    Senior Member
    • Feb 2009
    • 575
    • 5.7.5

    New message pulldown and opening of messages in general very slow

    I thought that once I upgraded to vb 5.2.4 and reverted to PhP 7.0.9 that this would be solved, but still:

    1. In general, the message center operates much more slowly than reading/posting at the forum. Opening/reading, writing/posting messages is pretty slow.

    2. The new message center operation (the pulldown menu) experiences especially slow operation. (The old message inbox once you get to it, operates faster than the new fancy pulldown and trying to access messages via those new fancy pulldown links.)

    I am running on a shared server, hostgator.

    Anyone else experiencing slow message center operation versus the speed of the forum in general?
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    It is doing an AJAX call to your server in both instances to retrieve the information. Are you using an external caching system like Memcached? What is the size of your cache and cacheevent tables in the database?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • Maltair
      Senior Member
      • Feb 2009
      • 575
      • 5.7.5

      #3
      Hostgator told me that there is no memcached on or even available on my shared server, and:

      Here is the row count of the database:


      Here is the size of each

      This is in MB

      Comment

      • Maltair
        Senior Member
        • Feb 2009
        • 575
        • 5.7.5

        #4
        What do you think?

        Comment

        • Wayne Luke
          vBulletin Technical Support Lead
          • Aug 2000
          • 73981

          #5
          This is probably related to your MySQL Gone Away errors but since they probably aren't reported and the system just repolls for new messages, it will be hard to check. Every time you select this menu, it will run a query to get the information.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

          • Maltair
            Senior Member
            • Feb 2009
            • 575
            • 5.7.5

            #6
            Perhaps, but whatever the case the forum and posting in forums isn't bad at all, while most of the time accessing the inbox or opening a private message thread or posting a new private message takes a ridiculously long time.

            Comment

            • Mark.B
              vBulletin Support
              • Feb 2004
              • 24286
              • 6.0.X

              #7
              As Wayne says, your server is struggling with vBulletin 5, as demonstrated by the MySQL server has gone away errors.

              This is going to be related to that and nothing support can do is going to change the fundamental problem which is that it's a server issue.
              MARK.B
              vBulletin Support
              ------------
              My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
              My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

              Comment

              • Maltair
                Senior Member
                • Feb 2009
                • 575
                • 5.7.5

                #8
                I always got the occasional database error but started getting flooded with them only after vb 5.2.3 Maybe this new messenger system is very taxing?

                Comment

                • Wayne Luke
                  vBulletin Technical Support Lead
                  • Aug 2000
                  • 73981

                  #9
                  Yes, Chat functionality can be taxing on the server... With the default settings, the system is going to check for new messages every 30 seconds for every user on your system. This creates database queries. For every active vBulletin Messenger window, the system will check for new messages every 1-30 seconds. The more active the window, the faster it checks. Windows are considered inactive after 5 minutes. So if someone has 5 active chat windows, they are doing at least 6 queries every 30 seconds until they are idle for 5 minutes. It can be as many as 151 queries. The more active your users are in chat, the more resources it will take.

                  These values can be adjusted in the AdminCP under Settings -> Options -> Private Messaging Options. Setting them too high can reduce the value of chat for your users.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API

                  Comment

                  • Maltair
                    Senior Member
                    • Feb 2009
                    • 575
                    • 5.7.5

                    #10
                    Well what setting would you suggest for my situation?

                    Comment

                    • Mark.B
                      vBulletin Support
                      • Feb 2004
                      • 24286
                      • 6.0.X

                      #11
                      Originally posted by MDawg
                      Well what setting would you suggest for my situation?
                      Personally, I'd try turning it off completely in the first instance.

                      Then monitor whether things improve.

                      If they do, you've isolated your problem and then we can play about with the settings.
                      MARK.B
                      vBulletin Support
                      ------------
                      My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                      My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                      Comment

                      • Maltair
                        Senior Member
                        • Feb 2009
                        • 575
                        • 5.7.5

                        #12
                        I turned vbmessenger off entirely. I'll leave it there for a day or so. At first I thought that access to the inbox, opening messages, posting messages, was a little faster but now I'm not so sure. Will see.

                        Comment

                        • Maltair
                          Senior Member
                          • Feb 2009
                          • 575
                          • 5.7.5

                          #13
                          With vbmessenger off still received a stack of database errors this morning such as:

                          Database error in vBulletin 5.2.4:

                          Invalid SQL:
                          UPDATE session SET `styleid`=11,`languageid`=1
                          WHERE (`sessionhash` = 'ff0a0839a91be34221c5bd3c3abbaccc')
                          /**session**/;

                          MySQL Error : MySQL server has gone away
                          Error Number : 2006
                          Request Date : Tuesday, September 27th 2016 @ 05:10:30 AM
                          Error Date : Tuesday, September 27th 2016 @ 05:14:28 AM
                          Script : http:///forums/forum/XXX
                          Referrer :
                          IP Address : 192.185.XXX.XX
                          Username : Guest
                          Classname : vB_Database_MySQLi
                          MySQL Version :

                          Comment

                          • Mark.B
                            vBulletin Support
                            • Feb 2004
                            • 24286
                            • 6.0.X

                            #14
                            It's a server issue - there really isn't much more we can suggest I'm afraid. vBulletin itself does not cause that error, there is a restriction or limitation on the server that is causing it.
                            MARK.B
                            vBulletin Support
                            ------------
                            My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                            My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                            Comment

                            • Wayne Luke
                              vBulletin Technical Support Lead
                              • Aug 2000
                              • 73981

                              #15
                              Best to follow up in the ticket while we try to troubleshoot. Posting in both locations just duplicates work and doesn't help us try to resolve the issue quicker.
                              Translations provided by Google.

                              Wayne Luke
                              The Rabid Badger - a vBulletin Cloud demonstration site.
                              vBulletin 5 API

                              Comment

                              Related Topics

                              Collapse

                              Working...