Announcement

Collapse
No announcement yet.

Slow Load For Message Center, Notifications

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

  • [Bug / Issue] Slow Load For Message Center, Notifications

    I've been testing a current VB 5.5.5, which is an upgrade from our 3.8x version.

    I've seen others post about this, not sure of the fix, but there is a huge lag when an Admin clicks on Notifications or Message Center.

    For normal users, there appears to be no issues. I even tested under one registered user account and it was very fast, but once I made him an Admin, the lag for clicking on either Message Center or Notifications was heavy.... as much as 5-10 seconds to load - even after wiping out all messages and notification items.

  • #2
    You can't actually delete private messages in vBulletin 5 due to the way they are stored. Deleting them in the message center just hides them from the user until someone replies to the topic.

    How many private messages, notifications, and subscriptions does the user have? All of these will increase the display time for the user. A query would be needed to get this information. An example would look like this:

    Code:
    SELECT COUNT(pm.nodeid) AS 'Private Messages', COUNT(s.subscribediscussionid) AS 'Subscriptions', COUNT(n.notificationid) AS 'Notifications' FROM sentto AS pm
        JOIN subscribediscussion AS s ON (pm.userid=s.userid)
        JOIN notification AS n ON (pm.userid=n.recipient)
        WHERE pm.userid=1
    Change the pm.userid=1 to match your user name. If you use a table prefix, you must update the table names (sentto, subscribediscussion, and notifcation) to include it.
    Translations provided by Google.

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

    Comment


    • #3
      Using edit user under Admincp, we removed the subscriptions and private messages from user and it's still loading very slow.

      How do you perma delete the private messages?

      Comment


      • #4
        Delete the user. That is the only way to permanently delete their private messages that I know. It is a flaw in the system that doesn't currently have a fix.

        What is the MySQL time for the page? You see this when the site is in Debug Mode. https://www.vbulletin.com/go/vb5debug
        Translations provided by Google.

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

        Comment


        • #5
          Originally posted by Wayne Luke View Post
          Delete the user. That is the only way to permanently delete their private messages that I know. It is a flaw in the system that doesn't currently have a fix.

          What is the MySQL time for the page? You see this when the site is in Debug Mode. https://www.vbulletin.com/go/vb5debug
          Why delete the user? We are talking about Admin accounts with 20k+ posts. We have nearly 250K users.

          Can't we just delete the private messages inside the table to that user or run a cron that cleans out private messages site wide every few days or weeks, etc.?

          When I timed the lag on these admin accounts, it lasts as long as 10+ seconds.
          Last edited by boxingscene; Fri 20 Dec '19, 11:29am.

          Comment


          • #6
            Also keep in mind, this has something to do with User Groups.

            I just changed the Admin account to a Super Moderator and the lag was non-existent, it came up instant with Private Messages as well.

            This was tested in an earlier post, where I changed an Regular User to an Admin, and the lag was at least 10+ seconds.

            Comment


            • boxingscene
              boxingscene commented
              Editing a comment
              However, when I clicked on the trash folder - there was a decent lag of at least 6 seconds. A lot of stuff in there and I can't see a way to delete all of that at one time.

          • #7
            Originally posted by boxingscene View Post

            Why delete the user? We are talking about Admin accounts with 20k+ posts. We have nearly 250K users.
            I didn't say delete the user. You asked how to permanently delete their private messages. This is the only way that I know how to do that in vBulletin 5.

            Translations provided by Google.

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

            Comment


            • #8
              What is the MySQL time for the page? You see this when the site is in Debug Mode. https://www.vbulletin.com/go/vb5debug

              Click on the question mark to the right of "Database Asserts" to see the query information. It will be at the bottom of the page.
              Translations provided by Google.

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

              Comment


              • #9
                Originally posted by Wayne Luke View Post
                What is the MySQL time for the page? You see this when the site is in Debug Mode. https://www.vbulletin.com/go/vb5debug

                Click on the question mark to the right of "Database Asserts" to see the query information. It will be at the bottom of the page.
                I just had another VB 5.5 user, having the same issue, conduct the same test that I mentioned earlier.

                He switched an Admin to a Regular User - no issue. He switched a Regular User to an Admin - issue happens.

                There is some connection between this issue and a user being an Admin.

                Comment


                • #10
                  Originally posted by Wayne Luke View Post
                  What is the MySQL time for the page? You see this when the site is in Debug Mode. https://www.vbulletin.com/go/vb5debug

                  Click on the question mark to the right of "Database Asserts" to see the query information. It will be at the bottom of the page.
                  ...
                  Translations provided by Google.

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

                  Comment


                  • #11
                    Attached is the MYSQL time on Debug Mode. As you can see, it's really, really slow - just to run SQL - when clicking on notifications or message center. The entire board as a whole appears to lag when I click on it and I'm just one user testing.

                    Comment


                    • #12
                      The total SQL time is abnormal. On the same explain page, it should list slow queries. They are listed to towards the bottom. What are they?
                      Translations provided by Google.

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

                      Comment


                      • #13
                        Originally posted by Wayne Luke View Post
                        The total SQL time is abnormal. On the same explain page, it should list slow queries. They are listed to towards the bottom. What are they?
                        Attached.

                        Comment


                        • #14
                          Part of the first query is missing. Having the actual text of the queries instead of a screenshot would be a lot more beneficial as well. Text can be copied and used to create bug reports for the developers. Screenshots aren't as useful in this manner.

                          What type of table is your node table? It should be using INNODB.
                          Translations provided by Google.

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

                          Comment


                          • #15
                            Originally posted by Wayne Luke View Post
                            Part of the first query is missing. Having the actual text of the queries instead of a screenshot would be a lot more beneficial as well. Text can be copied and used to create bug reports for the developers. Screenshots aren't as useful in this manner.

                            What type of table is your node table? It should be using INNODB.
                            (SELECTnode.publishdate,
                            node.nodeid,
                            node.contenttypeid
                            FROMnodeASstarterUSEINDEX(primary)
                            INNERJOINnodeASnode
                            ON(node.starter=starter.nodeid)
                            WHERE(starter.parentidIN( 13, 18, 37, 1,
                            2
                            , 5, 7, 14,
                            16
                            , 26, 42, 49,
                            28930729
                            , 3, 8, 11,
                            20
                            , 31, 4, 9,
                            19
                            , 34, 39, 6,
                            10
                            , 21, 32, 22,
                            47
                            , 52, 12, 51,
                            38
                            , 35, 28, 29,
                            33
                            , 28931051, 28930805, 28930819,
                            28930830
                            , 28930851, 28930901, 28930783,
                            28930740
                            , 28930957, 28930785, 28931055,
                            28930829
                            , 28930836, 28930955, 28930744,
                            28930991
                            , 28930747, 28930840, 28930812,
                            28930861
                            , 28930846, 28930782, 28930925,
                            28930995
                            , 28930947, 28931014, 28931060,
                            28931112
                            , 28930760, 28930762, 28930734,
                            28930778
                            , 28930837, 28930875, 28930892,
                            28930950
                            , 28930818, 28930789, 28930877,
                            28930895
                            , 28930929, 28930943, 28930816,
                            28930749
                            , 28930741, 28930772, 28930924,
                            28931053
                            , 28930802, 28930841, 28931028,
                            28930959
                            , 28930984, 28930989, 28931117,
                            28930798
                            , 28930792, 28930817, 28930942,
                            28931023
                            , 28931026, 28930737, 28930731,
                            28930733
                            , 28930745, 28930750, 28930872,
                            28930956
                            , 28930869, 28930755, 28930773,
                            28930788
                            , 28930743, 28930774, 28930822,
                            28930807
                            , 28930803, 28930884, 28930742,
                            28931084
                            , 28930860, 28930759, 28930844,
                            28930867
                            , 28930790, 28930922, 28930821,
                            28930826
                            , 28930827, 28930833, 28930732,
                            28930751
                            , 28930763, 28930765, 28930777,
                            28930784
                            , 28930857, 28931046, 28930937,
                            28930949
                            , 28930801, 28930738, 28930730,
                            28930894
                            , 28931033, 28930735, 28930932,
                            28930975
                            , 28930976, 28930848, 28930889,
                            28930900
                            , 28930917, 28930926, 28930793,
                            28930824
                            , 28930769, 28930800, 28930938,
                            28930767
                            , 28930847, 28930739, 28930766,
                            28930916
                            , 28930958, 28930962, 28930753,
                            28930907
                            , 28930797, 28930842, 28930823,
                            28930746
                            , 28931069, 28931085, 28930850,
                            28930871
                            , 28930904, 28930775, 28930794,
                            28930768
                            , 28930796, 28930838, 28930972,
                            28930756
                            , 28930781, 28930752, 28930934,
                            28930979
                            , 28930754, 28930758, 28930764,
                            28930757
                            , 28930771, 28930806, 28930761,
                            28930748
                            , 28930791, 28930905, 28930804,
                            28930811
                            , 28930834, 28930770, 28930912,
                            28930873
                            , 28930780, 28930786, 28930776,
                            28930779
                            , 28930787, 28930799, 28930855,
                            28930862
                            , 28930868, 28930808, 28930795,
                            28930831
                            , 28930948, 28930814, 28930878,
                            28930810
                            , 28930809, 28930996, 28930997,
                            28930828
                            , 28930813, 28930893, 28930815,
                            28930853
                            , 28930859, 28930825, 28930832,
                            28930874
                            , 28930870, 28931063, 28930820,
                            28930845
                            , 28930923, 28930911, 28930835,
                            28930858
                            , 28930866, 28931036, 28930843,
                            28930852
                            , 28930913, 28930856, 28930882,
                            28930898
                            , 28931062, 28931050, 28930891,
                            28930930
                            , 28930854, 28930920, 28930864,
                            28930965
                            , 28931029, 28930876, 28930865,
                            28930881
                            , 28930939, 28930918, 28930879,
                            28930880
                            , 28931087, 28931090, 28931102,
                            28931106
                            , 28931074, 28930883, 28931017,
                            28930885
                            , 28930890, 28930897, 28930902,
                            28930933
                            , 28930978, 28930987, 28930886,
                            28930849
                            , 28931039, 28930928, 28930927,
                            28930896
                            , 28930899, 28930921, 28931059,
                            28931107
                            , 28930910, 28930903, 28930935,
                            28931001
                            , 28930906, 28930888, 28931077,
                            28930998
                            , 28930988, 28931004, 28931005,
                            28931006
                            , 28931007, 28930909, 28930931,
                            28930945
                            , 28930999, 28930908, 28930954,
                            28930915
                            , 28930944, 28930971, 28931012,
                            28931049
                            , 28930952, 28930914, 28930970,
                            28931123
                            , 28930919, 28930951, 28930961,
                            28930968
                            , 28930992, 28930977, 28930969,
                            28931043
                            , 28930936, 28930887, 28930964,
                            28931071
                            , 28931003, 28930980, 28931047,
                            28930941
                            , 28931041, 28930940, 28930983,
                            28930974
                            , 28930946, 28930953, 28930960,
                            28930985
                            , 28931009, 28930963, 28930736,
                            28930981
                            , 28930986, 28931010, 28931068,
                            28930973
                            , 28930839, 28930990, 28930982,
                            28931114
                            , 28931115, 28931019, 28931015,
                            28930994
                            , 28930993, 28931000, 28931002,
                            28931024
                            , 28931044, 28931054, 28931025,
                            28931008
                            , 28931020, 28931042, 28931110,
                            28931038
                            , 28931011, 28931031, 28931034,
                            28931064
                            , 28931013, 28931035, 28931027,
                            28931018
                            , 28931030, 28931016, 28931021,
                            28931070
                            , 28931022, 28931045, 28931098,
                            28931032
                            , 28930966, 28931066, 28931067,
                            28931040
                            , 28931065, 28930863, 28931057,
                            28931048
                            , 28931092, 28931093, 28931094,
                            28931096
                            , 28931052, 28931056, 28931058,
                            28931061
                            , 28931111, 28931113, 28931103,
                            28931118
                            , 28931075, 28931073, 28931072,
                            28931076
                            , 28931088, 28931089, 28931037,
                            28931082
                            , 28931079, 28931099, 28931078,
                            28931095
                            , 28931080, 28931105, 28931097,
                            28931081
                            , 28931083, 28931086, 28931104,
                            28931091
                            , 28931126, 28931100, 28931109,
                            28931101
                            , 28931120, 28931108, 28931116,
                            28931122
                            , 28931119, 28931121, 28931127,
                            28931124
                            , 28930967, 28931125, 28931129, 28931128
                            )
                            ANDnode.approved= 0
                            ANDnode.showpublished<> 0 )
                            ANDnode.contenttypeidNOTIN( 15, 39 ))
                            UNION
                            (SELECTnode.publishdate,
                            node.nodeid,
                            node.contenttypeid
                            FROMnodeASstarterUSEINDEX(primary)
                            INNERJOINnodeASnode
                            ON(node.starter=starter.nodeid)
                            WHERE(node.nodeid=node.starter
                            ANDstarter.parentidIN( 13 )
                            ANDnode.showpublished< 1 )
                            ANDnode.contenttypeidNOTIN( 15, 39 ))
                            ORDERBYpublishdateDESC
                            LIMIT
                            20






                            Here is the 2nd slow query:



                            SELECTCount(*)ASppCount
                            FROM((SELECTnode.publishdate,
                            node.nodeid,
                            node.contenttypeid
                            FROMnodeASstarterUSEINDEX(primary)
                            INNERJOINnodeASnode
                            ON(node.starter=starter.nodeid)
                            WHERE(starter.parentidIN( 13, 18, 37, 1,
                            2
                            , 5, 7, 14,
                            16
                            , 26, 42, 49,
                            28930729
                            , 3, 8, 11,
                            20
                            , 31, 4, 9,
                            19
                            , 34, 39, 6,
                            10
                            , 21, 32, 22,
                            47
                            , 52, 12, 51,
                            38
                            , 35, 28, 29,
                            33
                            , 28931051, 28930805, 28930819,
                            28930830
                            , 28930851, 28930901, 28930783,
                            28930740
                            , 28930957, 28930785, 28931055,
                            28930829
                            , 28930836, 28930955, 28930744,
                            28930991
                            , 28930747, 28930840, 28930812,
                            28930861
                            , 28930846, 28930782, 28930925,
                            28930995
                            , 28930947, 28931014, 28931060,
                            28931112
                            , 28930760, 28930762, 28930734,
                            28930778
                            , 28930837, 28930875, 28930892,
                            28930950
                            , 28930818, 28930789, 28930877,
                            28930895
                            , 28930929, 28930943, 28930816,
                            28930749
                            , 28930741, 28930772, 28930924,
                            28931053
                            , 28930802, 28930841, 28931028,
                            28930959
                            , 28930984, 28930989, 28931117,
                            28930798
                            , 28930792, 28930817, 28930942,
                            28931023
                            , 28931026, 28930737, 28930731,
                            28930733
                            , 28930745, 28930750, 28930872,
                            28930956
                            , 28930869, 28930755, 28930773,
                            28930788
                            , 28930743, 28930774, 28930822,
                            28930807
                            , 28930803, 28930884, 28930742,
                            28931084
                            , 28930860, 28930759, 28930844,
                            28930867
                            , 28930790, 28930922, 28930821,
                            28930826
                            , 28930827, 28930833, 28930732,
                            28930751
                            , 28930763, 28930765, 28930777,
                            28930784
                            , 28930857, 28931046, 28930937,
                            28930949
                            , 28930801, 28930738, 28930730,
                            28930894
                            , 28931033, 28930735, 28930932,
                            28930975
                            , 28930976, 28930848, 28930889,
                            28930900
                            , 28930917, 28930926, 28930793,
                            28930824
                            , 28930769, 28930800, 28930938,
                            28930767
                            , 28930847, 28930739, 28930766,
                            28930916
                            , 28930958, 28930962, 28930753,
                            28930907
                            , 28930797, 28930842, 28930823,
                            28930746
                            , 28931069, 28931085, 28930850,
                            28930871
                            , 28930904, 28930775, 28930794,
                            28930768
                            , 28930796, 28930838, 28930972,
                            28930756
                            , 28930781, 28930752, 28930934,
                            28930979
                            , 28930754, 28930758, 28930764,
                            28930757
                            , 28930771, 28930806, 28930761,
                            28930748
                            , 28930791, 28930905, 28930804,
                            28930811
                            , 28930834, 28930770, 28930912,
                            28930873
                            , 28930780, 28930786, 28930776,
                            28930779
                            , 28930787, 28930799, 28930855,
                            28930862
                            , 28930868, 28930808, 28930795,
                            28930831
                            , 28930948, 28930814, 28930878,
                            28930810
                            , 28930809, 28930996, 28930997,
                            28930828
                            , 28930813, 28930893, 28930815,
                            28930853
                            , 28930859, 28930825, 28930832,
                            28930874
                            , 28930870, 28931063, 28930820,
                            28930845
                            , 28930923, 28930911, 28930835,
                            28930858
                            , 28930866, 28931036, 28930843,
                            28930852
                            , 28930913, 28930856, 28930882,
                            28930898
                            , 28931062, 28931050, 28930891,
                            28930930
                            , 28930854, 28930920, 28930864,
                            28930965
                            , 28931029, 28930876, 28930865,
                            28930881
                            , 28930939, 28930918, 28930879,
                            28930880
                            , 28931087, 28931090, 28931102,
                            28931106
                            , 28931074, 28930883, 28931017,
                            28930885
                            , 28930890, 28930897, 28930902,
                            28930933
                            , 28930978, 28930987, 28930886,
                            28930849
                            , 28931039, 28930928, 28930927,
                            28930896
                            , 28930899, 28930921, 28931059,
                            28931107
                            , 28930910, 28930903, 28930935,
                            28931001
                            , 28930906, 28930888, 28931077,
                            28930998
                            , 28930988, 28931004, 28931005,
                            28931006
                            , 28931007, 28930909, 28930931,
                            28930945
                            , 28930999, 28930908, 28930954,
                            28930915
                            , 28930944, 28930971, 28931012,
                            28931049
                            , 28930952, 28930914, 28930970,
                            28931123
                            , 28930919, 28930951, 28930961,
                            28930968
                            , 28930992, 28930977, 28930969,
                            28931043
                            , 28930936, 28930887, 28930964,
                            28931071
                            , 28931003, 28930980, 28931047,
                            28930941
                            , 28931041, 28930940, 28930983,
                            28930974
                            , 28930946, 28930953, 28930960,
                            28930985
                            , 28931009, 28930963, 28930736,
                            28930981
                            , 28930986, 28931010, 28931068,
                            28930973
                            , 28930839, 28930990, 28930982,
                            28931114
                            , 28931115, 28931019, 28931015,
                            28930994
                            , 28930993, 28931000, 28931002,
                            28931024
                            , 28931044, 28931054, 28931025,
                            28931008
                            , 28931020, 28931042, 28931110,
                            28931038
                            , 28931011, 28931031, 28931034,
                            28931064
                            , 28931013, 28931035, 28931027,
                            28931018
                            , 28931030, 28931016, 28931021,
                            28931070
                            , 28931022, 28931045, 28931098,
                            28931032
                            , 28930966, 28931066, 28931067,
                            28931040
                            , 28931065, 28930863, 28931057,
                            28931048
                            , 28931092, 28931093, 28931094,
                            28931096
                            , 28931052, 28931056, 28931058,
                            28931061
                            , 28931111, 28931113, 28931103,
                            28931118
                            , 28931075, 28931073, 28931072,
                            28931076
                            , 28931088, 28931089, 28931037,
                            28931082
                            , 28931079, 28931099, 28931078,
                            28931095
                            , 28931080, 28931105, 28931097,
                            28931081
                            , 28931083, 28931086, 28931104,
                            28931091
                            , 28931126, 28931100, 28931109,
                            28931101
                            , 28931120, 28931108, 28931116,
                            28931122
                            , 28931119, 28931121, 28931127,
                            28931124
                            , 28930967, 28931125, 28931129,
                            28931128
                            )
                            ANDnode.approved= 0
                            ANDnode.showpublished<> 0 )
                            ANDnode.contenttypeidNOTIN( 15, 39 ))
                            UNION
                            (SELECTnode.publishdate,
                            node.nodeid,
                            node.contenttypeid
                            FROMnodeASstarterUSEINDEX(primary)
                            INNERJOINnodeASnode
                            ON(node.starter=starter.nodeid)
                            WHERE(node.nodeid=node.starter
                            ANDstarter.parentidIN( 13 )
                            ANDnode.showpublished< 1 )
                            ANDnode.contenttypeidNOTIN( 15, 39 )))ASdummy

                            Comment

                            Related Topics

                            Collapse

                            Working...
                            X