Announcement

Collapse
No announcement yet.

Search mostly slow or hangs

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

  • 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

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

    Comment


    • #3
      Originally posted by In Omnibus View Post
      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


      • #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 - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment


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

          Comment


          • #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 - Full / Mobile
            Vote for your favorite feature requests and the bugs you want to see fixed.

            Comment


            • #7
              Originally posted by Wayne Luke View Post
              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


              • #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 - Full / Mobile
                Vote for your favorite feature requests and the bugs you want to see fixed.

                Comment


                • #9
                  Originally posted by Wayne Luke View Post
                  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


                  • #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 - Full / Mobile
                    Vote for your favorite feature requests and the bugs you want to see fixed.

                    Comment


                    • #11
                      Originally posted by Wayne Luke View Post
                      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


                      • #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 - Full / Mobile
                        Vote for your favorite feature requests and the bugs you want to see fixed.

                        Comment


                        • #13
                          Originally posted by Wayne Luke View Post
                          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 17th Jan '18, 2:33am.

                          Comment

                          Related Topics

                          Collapse

                          Working...
                          X