Search mostly slow or hangs

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • William Thomas Jr
    Senior Member
    • Nov 2014
    • 526
    • 5.1.x

    Search mostly slow or hangs

    I have been having an issue for sometime now. When searching, a search may come up rather quickly, however, most often the search is slow or just hangs on working. During which time the site is unbrowseable to the one who made the initial search.

    Here is the url to my site: https://www.christforums.org/

    I have no idea what may cause this, as there shows 4gb on avg of ram available etc. This began rearing its nasty head after an update around version 5.3.0 and has remained ever since. I also notice that emails are received from the server saying the database went away when the site search hangs. I was approached today by a member complaining about this, but this is the first time I reported it though I've experienced it often.

    Thanks,
    William
  • In Omnibus
    Senior Member
    • Apr 2010
    • 2310

    #2
    I tried a search on your site and your addthis json is hanging up. Disabling it may resolve the issue.

    Comment

    • William Thomas Jr
      Senior Member
      • Nov 2014
      • 526
      • 5.1.x

      #3
      Originally posted by In Omnibus
      I tried a search on your site and your addthis json is hanging up. Disabling it may resolve the issue.
      I removed Addthis altogether and the same issue is still present.

      Comment

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

        #4
        Delete your System Cache. Does the same problem still occur?
        Translations provided by Google.

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

        Comment

        • William Thomas Jr
          Senior Member
          • Nov 2014
          • 526
          • 5.1.x

          #5
          Originally posted by Wayne Luke
          Delete your System Cache. Does the same problem still occur?
          Yes, same issue after deleting system cache.

          Comment

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

            #6
            I ran a search on your site for the word "evolution". I received a 502, bad gateway error from Cloudflare. If you have Cloudflare disabled do you have the same issues?
            Translations provided by Google.

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

            Comment

            • William Thomas Jr
              Senior Member
              • Nov 2014
              • 526
              • 5.1.x

              #7
              Originally posted by Wayne Luke
              I ran a search on your site for the word "evolution". I received a 502, bad gateway error from Cloudflare. If you have Cloudflare disabled do you have the same issues?
              Disabled CloudFlare, and currently searching the same keyword "evolution" the system returned a bad gateway. Is this because the server is "going away" during searches?

              During which time I receive an email:

              Database error in vBulletin 5.3.4:

              MySQL Error : MySQL server has gone away
              Error Number : 2006
              Request Date : Tuesday, January 16th 2018 @ 08:35:45 PM
              Error Date : Tuesday, January 16th 2018 @ 08:44:59 PM
              Script : https://www.christforums.org/search?...elevance%22%7D
              Referrer : https://www.christforums.org/
              IP Address : xxx.xxx.xxx.xxx
              Username : Guest
              Classname : vB_Database_MySQLi
              MySQL Version :


              Stack Trace:
              #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
              #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
              #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
              #3 vB_Database->query_write() called in [path]/vb/db/query/update.php on line 116
              #4 vB_dB_Query_Update->doUpdates() called in [path]/vb/db/query/update.php on line 101
              #5 vB_dB_Query_Update->execSQL() called in [path]/vb/db/assertor.php on line 303
              #6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 540
              #7 vB_dB_Assertor->update() called in [path]/vb/session.php on line 522
              #8 vB_Session->save() called in [path]/vb/shutdown.php on line 86
              #9 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 486
              #10 vB::shutdown() called in on line

              Comment

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

                #8
                Could be. What are the timeout values for MySQL?

                show variables like '%timeout%';
                Translations provided by Google.

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

                Comment

                • William Thomas Jr
                  Senior Member
                  • Nov 2014
                  • 526
                  • 5.1.x

                  #9
                  Originally posted by Wayne Luke
                  Could be. What are the timeout values for MySQL?

                  show variables like '%timeout%';
                  Here are my mysql.cfg settings:

                  max_allowed_packet=268435456
                  bulk_insert_buffer_size=64M
                  table_open_cache=32768
                  open_files_limit=65536
                  sort_buffer_size=8M
                  read_buffer_size=2M
                  read_rnd_buffer_size=4M
                  myisam_sort_buffer_size=128M
                  myisam_max_sort_file_size=10G
                  thread_cache_size=8
                  myisam-recover-options = DEFAULT
                  query_cache_size=256M
                  query_cache_limit=2M
                  # Try number of CPU's*2 for thread_concurrency
                  #thread_concurrency=16
                  max_connections=100
                  #max_user_connections = 40
                  max_delayed_threads=0
                  log-error="/var/log/mysql.error.log"
                  log-warnings
                  ft_min_word_len=3
                  wait_timeout=300
                  tmp_table_size=512M
                  max_heap_table_size=512M
                  table_definition_cache=12000
                  join_buffer_size=256K

                  Comment

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

                    #10
                    You may want to consider moving your keyword search to the Sphinx engine.

                    You're not using MyISAM tables, are you? You may also need to increase your innodb buffers.
                    Translations provided by Google.

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

                    Comment

                    • William Thomas Jr
                      Senior Member
                      • Nov 2014
                      • 526
                      • 5.1.x

                      #11
                      Originally posted by Wayne Luke
                      You may want to consider moving your keyword search to the Sphinx engine.

                      You're not using MyISAM tables, are you? You may also need to increase your innodb buffers.
                      Thank you Wayne, but Sphinx is over my head, though I have root access on my server, it seems that many people are having issue with Sphinx especially after updates? I had a developer look into utilizing the Sphinx search on my server and site months ago, but they couldn't get it to work.

                      Lastly, I am unfamiliar with using MyISAM tables? Is this recommended? Could you point me to a resource for increasing innodb buffers and any recommended settings?

                      Comment

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

                        #12
                        INNODB tables are recommended.

                        https://dev.mysql.com/doc/refman/5.7...imization.html

                        Settings are going to vary based on the server, your innodb settings and the database size. Unfortunately, this is outside the scope of support. All I can suggest at this time is to increase the wait_timeout value.
                        Translations provided by Google.

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

                        Comment

                        • William Thomas Jr
                          Senior Member
                          • Nov 2014
                          • 526
                          • 5.1.x

                          #13
                          Originally posted by Wayne Luke
                          INNODB tables are recommended.

                          https://dev.mysql.com/doc/refman/5.7...imization.html

                          Settings are going to vary based on the server, your innodb settings and the database size. Unfortunately, this is outside the scope of support. All I can suggest at this time is to increase the wait_timeout value.
                          Thanks Wayne,

                          My day has been fruitful learning how to run commands etc. I was able to find out Innodb was not the default database, but MyISAM was. I changed the database engine and adjusted settings in the mysql.cnf file to adjust for the amount of server ram.

                          Ran a search and it for the first time did not lose the database or freeze up for the keyword evolution.

                          Thank you for your time and efforts!

                          And for reference, these are my current settings:

                          [mysqld]
                          # other variables here
                          innodb_buffer_pool_size = 3G
                          innodb_log_file_size = 256M
                          innodb_flush_log_at_trx_commit = 1
                          innodb_flush_method = O_DIRECT
                          innodb_io_capacity_max=6000
                          innodb_io_capacity=3000
                          Last edited by William Thomas Jr; Wed 17 Jan '18, 1:33am.

                          Comment

                          Related Topics

                          Collapse

                          Working...